Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion.

0
votes
0answers
8 views

What would be a good method to collect as a server data send as URL requests by a client?

Situation: I manage a set of linux based user computers: laptops and desktops with mainly Ubuntu 16.04 lts and Debian 9.x. (It's for about 120 users and the number is growing) I use the /etc/rc....
0
votes
0answers
18 views

Does the LOAD DATA LOCAL disabled on most shared hostings? [closed]

I want to use LOAD DATA INFILE to significantly faster MySQL import process in my plugin software. I hear that some shared hostings disabled this (cool) feature. Is it correct? If yes, why they did it ...
2
votes
0answers
40 views

Company / Product Info Directory Website - Copyright Laws

I want to create a large business directory website , which would allow a user (buyer) to search, filter and identify suitable products. I would require company logos and use of product names (TM,...
1
vote
2answers
23 views

Backend method to changing base wordpress domain to prevent redirect

My friend has come to me today to tell me he wants his wordpress site moved from example.com to example2.com. I have full access to the same server managing both those URLs, I copied the entire file ...
3
votes
1answer
53 views

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts. This time, I have decided to try to host my own site using WAMP ...
1
vote
0answers
29 views

Can dbadmin be secured under nginx by using a rewrite rule to a 404?

I'm trying to redirect all 404 pages to a custom handler with NGINX. I spent few hours to made the following rewrite in nginx but my question is: can it be a security breach? location ~ ^/(?!(dbadmin)...
0
votes
0answers
264 views

phpmyadmin Error - Script timeout passed, if you want to finish import, please resubmit the same file

I have a database named A. I want to export it, and import it to a new database B. I exported the A, no issues. While trying to import to the new database B, I faced the following error: Script ...
1
vote
0answers
143 views

how to handle email signup when the same email is pending approval

How do i handle multiple signups with the same email, while email confirmation is still pending? Here are my tables user uid - bigint primary key uname - varchar 255 unique uemail - varchar ...
1
vote
0answers
255 views

XAMPP phpMyAdmin - different users access same MySQL database [closed]

I have created a MySQL database on MyPHPAdmin (XAMPP 3.2). This is for a group project and I need to have different users access the same database. If they have XAMPP installed on their computer, is ...
1
vote
2answers
464 views

Can I use the Laravel Database Framework without using all of Laravel?

I work at a company with a custom PHP framework we have built over the years. For the most our custom framework suits our needs and includes almost everything Laravel offers, however, our database ...
0
votes
1answer
366 views

What Should be the ideal sequence to Learn Programming languages to become professional developer [closed]

I am new in programming i haven't learn any programming language yet. i have some basic knowledge of HTML and CSS and C++ can you please suggest me which language should be master in , to become a ...
4
votes
5answers
76 views

Moving website images to remote server vs moving database to remote server

I have a wordpress website that has gotten too big for a single server. I need to decide whether I should host the database externally i.e. purchase another server for the DB or if i should host the ...
2
votes
0answers
126 views

Sentora database dump works when run from command line, but not from cron

The Setup I'm running a webserver with CentOS 7.1 x64, Sentora, and suhosin module preinstalled. I need to trigger a PHP script which does this (among other things) echo exec('mysqldump -u'.USER.' ...
7
votes
2answers
879 views

Deleting backups - Request to delete customer data - Data Protection Act 1998

It was brought up today about the customers right to have their data deleted and went on to an interesting talk about backed up data (we have a rolling 93 day window for backups on AWS s3) I was ...
0
votes
1answer
37 views

Title Tag and Meta Description [duplicate]

Question is, if my title tag and meta description is getting some of content or text from DB how would this effect SEO? e.g. Isuzu D-Max 4x2 LS MT - Specs, Specification and Price List Where "Isuzu ...
2
votes
2answers
1k views

Does Amazon's RDS Multi-AZ deployment cost twice as much as the normal cost of a single instance?

It's not totally clear based on Amazon's provided documentation. Intuitively, it feels like it'd cost twice as much as a normal RDS instance for a two-zone deployment; does anyone here have experience ...
0
votes
1answer
142 views

Manually insert text into existing MediaWiki table row?

I'm trying to update a page for a MediaWiki database running MW version 1.26.4. The MediaWiki is currenty suffering unexplained Internal Server Errors, so I am trying to perform an end-around by ...
1
vote
0answers
18 views

Troubleshooting database connection [closed]

I got problem with my website database, as you can see in the attached image below. Unfortunately My Dev and I have no idea what's going on. I think this trouble occurred after WP installation.. For ...
2
votes
1answer
1k views

phpMyAdmin can't find tmp directory

I have a site hosted with BlueHost. I need to upload a rather large SQL file to the tmp directory so I can run an import. However, phpMyAdmin is giving me the following error: The directory you ...
1
vote
2answers
1k views

What are the pros/cons of using remote DB

As the question says, I want to know if is good or bad idea to use a remote database, and what pros and cons does this practice have.
3
votes
2answers
646 views

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

While exporting Magento database from xampp (using PhpMyAdmin).I am getting error .sql file. and also getting a warning message during export start. Warning: a form on this page has more than 1000 ...
3
votes
1answer
32 views

Is it possible to recover the content of a website no more available?

Some years ago I charged some information and pictures on a web platform which let companies and freelancers keeping in touch for professional purposes. In the meanwhile the website stopped working. ...
0
votes
3answers
265 views

Allow Link access to only one database

I have a hosting account where we have multiple domains hosted and many of them have their own database. Coming to question, Can I share access to particular database on phpmyadmin to a person who ...
2
votes
3answers
1k views

Is there any downside to using dokuwiki considering it does not use database?

I'm planing to use dokuwiki for my website but my friend told me since dokuwiki don't use database and store the data in plain text files it will put lots of strain on my host as my website grows and ...
3
votes
1answer
124 views

How to secure database access

I am developing a personal web-site with a lot of relatively sensitive (genealogical) information stored in a MySQL database. The site engine is written in PHP. So far (prototype phase) I have only ...
1
vote
1answer
262 views

homepage keeps on redirecting to install.php

I don't really have any clue what's causing this. It happened 3 times today already. The site that I'm assigned to work on keeps redirecting to http://atenews.ph/wp-admin/install.php and when I tried ...
1
vote
2answers
32 views

Wordpress DataBase Local Content different from Remote Content

Problem Description I am developing a project using Wordpress as a CMS for a web page of a Scientific Research Group to Publish Information, News, Publications and Projects of the Scientific Group. ...
1
vote
3answers
45 views

Should I ask for the state in a registration form for new clients who live in the USA?

Basically, on almost every international site, they ask for the united state you live in, once you selected that you live in the USA. Right now I'm programming a registration form for an Austria ...
2
votes
1answer
42 views

Migrate URLs with old primary keys to new primary keys

We have a database which we obtained via a crawling, where every row contains a primary key X, and an unique number Y obtained from the crawling procedure (the primary key of the original source). For ...
1
vote
1answer
38 views

Should I use SQL to save time? and How? [closed]

I created some landing page template in which I test various products. currently it is a .php file which I manually change each time, along with 3 other files, plus an image, and then upload all of ...
1
vote
1answer
2k views

How do I recover WordPress page content from MySQL database?

I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, etc......
0
votes
2answers
97 views

Duplicate Content Database driven Website

I have a listing based website similar to yelp. We have different pages for a listing for example basic information, photos, reviews, google map address etc. Now most content on this page is similar. ...
0
votes
1answer
745 views

How to Safely Share Access with Freelance web developers

I have a running website developed in Magento CMS and hosted in AWS EC2. I just recently hired a freelance web developer located overseas to revamp my website (design, features,etc). I have no ...
1
vote
1answer
235 views

How do I upgrade a seven year old version of MediaWiki to the current version and migrate from MySql to SQlite?

currently I have this: Old Mediawiki 1.11.0 (from 2007!) on shared webhosting (so no shell access) with about 200 articles and many thousand spam articles I deleted via the Webinterface (but they are ...
0
votes
1answer
115 views

Creating mysql db error

I am trying to run DVWA in my website hosting but i have a problem: This application at fist time needs to create mysql databases and it needs just click on a button but in my case it can't and ...
1
vote
1answer
63 views

How to change the directory in which MediaWiki is installed after upgrading a temporary directory?

I have a section in my website which uses MediaWiki. eg. sitename.com/codewiki/ It has been 3 years since I installed MediaWiki. Now i am getting errors so i wanted to upgrade to the latest version. ...
2
votes
2answers
466 views

How do domain names get into WHOIS database and which databases get updated for each domain?

The WHOIS query and response protocol is widely used for databases holding various Internet resources like IPv4 assignments, IPv6 assignments, AS numbers and RIR (for example ARIN in USA or RIPE in ...
2
votes
4answers
90 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. However,...
3
votes
3answers
64 views

Web user authentication methods

Is there any method besides using a DB with username and password for authenticating a user?
1
vote
1answer
2k views

Virtualmin cannot connect to MySQL database

I have a VPS running Webmin/Virtualmin. I host multiple domains, one of which is a Drupal 7 website that uses a MySQL database. Yesterday I went to 'Manage' the database and found that I recieved the ...
-1
votes
1answer
35 views

simple database edit webpage recommendations [closed]

It's been a long time since I've made something like this, I'm just wondering if I'm not re-inventing the wheel. My client currently has a bunch of data in an excel file and wants this to be on the ...
0
votes
1answer
899 views

How to do SEO for database driven web? Asp.net [duplicate]

Hi to everyone and thanks in advance for your time reading this question. Im kinda new on this SEO stuff and there is something that I can't figure out how it works despite all the readings that I ...
0
votes
1answer
35 views

Server Processes: Websites with and without database [closed]

I am on shared server and I have some limitations at "simultaneous processes". I have two websites: one which uses database and other without database (it's only HTML). Both are hosted on the same ...
1
vote
2answers
375 views

Should I learn html/css before php even for using database? [closed]

I have seen lots of questions about this topic and all of them were asking whether someone, who wants to use PHP for "building web pages", should learn HTML first, or not? Most of the answers said ...
10
votes
3answers
16k views

How can I tell how big my Amazon RDS database (MySQL) is?

I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
0
votes
1answer
44 views

What method should I use for copying data from one table to another one?

I'm wondering what method I should use for copying data from one table to another one. I'm letting users post data through a form which uses table1 to save data. Now for displaying results I use data ...
0
votes
1answer
75 views

How does stackexchange websites manage to have google see multiple questions as multiple webpages?

I'm not a web developer and I had some basic experiences of web developing (I made my own website some time ago, played around with php, css, some asp.net and other pretty straightforward stuff) but ...
2
votes
4answers
87 views

Will a standard CMS on a shared web hosting account work for this?

I have two questions concerning CMS's that I need answered if possible: I need to create a site with a Database. This site will in due time have lots of traffic and many users if things go as planned....
1
vote
1answer
67 views

Changing mysql query_cache_limit without having root priviledges

Can query_cache_limit in mysql 5 be set locally for a specific database? I don't have root privileges to change the global variable. Can query_cache_limit be set locally for each database?
2
votes
2answers
778 views

How do yelp and google business collect information about businesses?

Do they work with some governmental sources ? Do they only use the information sent by business owners themselves ? Do they scrap the web to collect these information ? Do they have employees that ...