MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

2
votes
3answers
2k views

How to find out what is causing “Entry Process” limit?

We're using an OpenCart 1.5.5.1 custom theme for our site. Well it hasn't been smooth sailing for us and we are facing problem after problem. So far the gist of it is we're currently on a business ...
0
votes
1answer
37 views

How much diskspace does a database take? [closed]

I'm looking for hosting at the moment for a wiki and wordpress site. Looking around it looks like most hosts offer a number of databases with a max size of 1GB. With this seeming to be the norm, ...
3
votes
1answer
74 views

Google Analytics not same with my database records

I got a website which will track all the post's visitor view and store each of them in a table with IP address, referrer website and user agent. But I found that in one day I got 100+ rows (pageviews) ...
0
votes
1answer
20 views

What are the options to gradually upgrade from shared hosting if the traffic to my site grows? [duplicate]

I have a site with php+mysql on shared hosting and it works well, has good traffic and I want to plan for the future when traffic to my site grows and shared hosting can't handle it. Since the code ...
8
votes
6answers
8k views

What is the best way to exclude bots from view counts?

My website is counting visitor views on certain pages. I noticed that Google and other Bots are "clicking" to my site like crazy and some of the pages get unrealistic view counts (compared to those ...
2
votes
0answers
9 views

I always wonder how this dynamic site content index very fast? [duplicate]

I am new to this field.Actually I am learning PHP/MYSQL.Five min before I asked a question in StackOverflow.And when I googling this suddenly my question appears.How does StackOverflow index very fast ...
7
votes
5answers
2k views

Open Source website backup tool suggestions

I'm looking for an Open Source website backup tool. I'm more interested in Open Source so I can make changes if need be and possibly contribute to the software. Automatic scheduled FTP backups ...
3
votes
2answers
836 views

Looking for full web based booking system

I've searched around here but could not find any booking system that would suit my need. I hope maybe you can help me out. I've already seen question #11379. Solutions provided there are not helping ...
1
vote
0answers
40 views

How can I migrate a phpBB3 forum from MySQL to PostgreSQL?

I have a phpBB3 forum running on a server with MySQL 5.5. I want to migrate the data to a PostgreSQL 9.3 database. I've looked at various guides and tools they were either Very old or Not specific ...
0
votes
2answers
960 views

How can I create a review site which is similar to craigslist? [closed]

I want to create a site where you can review different things in the town. Example could be a Restaurant, a park, a doctor, a school. The user creates review and uploads pic if he has. I want to ...
2
votes
3answers
69 views

How do I replace a MySQL Database?

I created a database on the host server using PHPMyAdmin. I exported the database for local development and have since added data and changed the schema slightly. How can I replace the database on ...
0
votes
1answer
26 views

Possible to make virtual servers on hosted web server? [closed]

I own a debian root web server at an ISP. By own I mean, I rent the server with a package, I do not own the hardware and such. No plesk or anything else. All configuration is done by hand (well, a ...
2
votes
2answers
70 views

How to analyse website performance

I've tried searching a lot and basically here is the problem. I have a website but I'm unable to pin point the reasons of why the performance of the website is so slow. We have shifted to a high end ...
1
vote
2answers
65 views

How to implement a software trial request form?

On my company's website I want to have a form where a visitor can provide an email address and pass an anti-bot challenge. The server would then email a trial key to the visitor. Background: I am ...
3
votes
1answer
95 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
4answers
5k views

MySQL Online Database

Can anyone suggest a good online free MySQL database. I've tried four till now: db4free FreeMySQL onPhP 000webhost Either of them gave me an timeout error on my connect file or actively restricted ...
3
votes
2answers
199 views

Does Google Show Phpmyadmin URL of site in search result

I've extracted phpmyadmin in public folder, and named it phpmyadmin-012940912830 Now I can access it using, mysiteurl.com/phpmyadmin-012940912830, I don't want anyone to know about this URL but what ...
1
vote
1answer
70 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
187 views

Possible to have an RDS > 3072GB on AWS?

I am a complete newb to AWS. I have a MYSQL database that is about 4TB and growing each day and would like to move it to AWS. According to this link the maximum allocated storage size is 3072 GB. How ...
1
vote
1answer
68 views

In what location does Tiki store articles: in the file system or in the MySQL database?

I have a dump of the directory structure from an old Tiki website from around 2010 that is no longer up. I would like to view the raw text of the articles but am unable to locate any files that ...
1
vote
0answers
31 views

Easy way to SELECT * with ExternalData in Mediawiki?

The ExternalData extension works fine when you I the column names I am looking for, but if I don't know them in advance I look them up from information_schema and then try and fail to hack them into a ...
1
vote
1answer
497 views

MySQL and SQL inserting data into JavaScript variable! [closed]

I have a javascript file that has the variable named locations, with some data in quotes for example, 'name', '123 lane', and etc. I want the variable to get data from a database and not the plain ...
1
vote
1answer
660 views

Automate backing up of MySQL DB on Godaddy Windows account

Does anyone know of a good way to set up an automated backup of our MySQL DB on a Godaddy Windows account? Most articles I have found talk about using mysqldump. But I can't figure out how to do ...
2
votes
1answer
149 views

Wordpress plugin not working after moving domains - I get this error message

I have moved a wodpress website to a new domain with a new host. The website looks, fine and most of the wp-admin area works just fine too. However, certain pages on the admin area don't display and ...
1
vote
1answer
111 views

Where does TWiki store articles: in the file system or in the MySQL database?

I have a dump of the directory structure from an old TWiki website from around 2010 that is no longer up. I would like to view the raw text of the articles but am unable to locate any files that ...
6
votes
2answers
20k views

How to create separate users in phpmyadmin, each one can't see others databases?

I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool, what i want is to make each user can create databases but can't see others databases. ...
1
vote
1answer
55 views

Character encoding issue in mysql database when working on a MacBook (OSX 10.10)

I'm attempting to get my web development environment running on my MacBook (OSX 10.10 with MAMP), but I'm stuck on an annoying character encoding issue. When originally developing my site in a Windows ...
7
votes
2answers
1k views

Make Google index over 90,000 user profiles

I have a large amount of user profiles hosted in this schema https://example.com/stats.php?player=name (It's not the prettiest URL, but .htaccess dramatically slows down my site and I don't understand ...
1
vote
1answer
35 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
134 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......
3
votes
1answer
59 views

Magento Backup using mysqldump

I have website using magento installed in ubuntu ec2 server. I would like to do a backup of the whole magento website. I stumbled on an article that tells me to run this command http://www....
2
votes
2answers
535 views

Sync MySQL databases?

I'm a first-time XAMPP user and was wondering what is the method of making sure my local test MySQL database is synced with the live remote database. Or, how do I 'push' the local database to the live ...
2
votes
2answers
428 views

How do I choose a web host with support for mysqli extension in PHP? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I have designed a website running in PHP and mySQL. And I used mysqli extension instead of the normal mysql extension in ...
1
vote
1answer
72 views

Basic looping on PHP for web design [closed]

I am very much a newbie in PHP. Could you tell me about basic looping in PHP if I want create a web design. Also, how do I connect to a MySQL database?
1
vote
2answers
106 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 ...
1
vote
1answer
1k views

Zpanel phpmyadmin lost password

I am moving my websites with cPanel management to a new VPS (more cheap and powerful) with zPanel management (the 10.1.1 version, apparently without huge security holes) But unluckily, I lose all ...
2
votes
2answers
366 views

How does mediawiki save the passwords?

I have mediawiki installed in my local machine. I had to use a form outside wiki which asks the user to upload files with the wiki username and password. In order to achieve this I went through the ...
0
votes
0answers
34 views

mysql open file limit issue [closed]

It is a little hard to explain but I have a WordPress site which runs really fast but every so many hours it is causing a large spike in system cpy utilization. User cpu is way down. Centos 6.5 ...
3
votes
10answers
2k views

How to check if person doesn't have multiple account?

I have two users in my website with the same IP. I asked them or him, idk, why does he have 2 accounts. He said that other account is owned by his roommate. His roommate uses other computer in my ...
-1
votes
2answers
39 views

Switch to Drupal [closed]

Currently I manage a website written entirely in html5, php, javascript and css3 with a mysql database. The site resides on a dedicated server with CentOS and Plesk is used for management. I thought ...
2
votes
4answers
84 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. ...
-4
votes
1answer
78 views

How to block all hacking? [closed]

The title explains most of my question. The OS is linux (Lubuntu). The servers are Apache2 (PHP5), MySQL 5.6 and FTP (Samba).
0
votes
1answer
2k views

Ubuntu server MySQL remote access from MySQL Workbench [closed]

I have a newly install Ubuntu installed the MySQL server. After the basic config: I changed the my.cnf file and commented out the bind_address I can start the server and added iptable for 3306. I ...
0
votes
1answer
680 views

Can not access phpMyAdmin

I tried to access phpMyAdmin but I get an error. Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the ...
5
votes
6answers
2k views

Adding a Forum to my site: build one from scratch or use existing open-source platform?

Note: I posted this originally to stackoverflow.com, had it closed, and was told to post it on programmers.stackexchange.com. So I posted it on programmers.stackexhange.com, had it cloased, and was ...
1
vote
1answer
933 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
vote
0answers
55 views

PHP installation missing while opening website [closed]

All was working fine but then suddenly Your PHP installation appears to be missing the MySQL extension which is required by WordPress came when I try to my site. Hosting:Godaddy PHP version:5.4.26 ...
2
votes
0answers
21 views

Really slow wordpress website admin panel with a total query time 1664ms for the home page [duplicate]

I have a problem with my WordPress website being too slow, I installed a debug bar to check queries in the home page, it reports 202 queries, and a total query time equal to 1665ms. The cpu and the ...
5
votes
3answers
3k 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 ...
2
votes
0answers
33 views

Store a formula in a table and use the formula in a javascript/PHP function [closed]

I have a MySql database where part of it handles instrument's depth of water. Each instrument has its own formula of calculation how depth the water when the operator collect the reading I stored the ...