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

learn more… | top users | synonyms

2
votes
3answers
1k views

How can I automate retrieval of MySQL databases from shared hosting which disallows remote MySQL connections?

my situation is the following: I need to do an automated backup of a database I have only FTP access, PhpMyAdmin, and PHP So: No SSH means I can't use mysqldump No Perl (and no cron) means I ...
2
votes
2answers
1k views

phpmyadmin and stored procedures

I'm not able to view subprocedures in Phpmyadmin. I have created a sub procedure via the execute query option. Is there an option to list the subprocedure and edit them.
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
1answer
3k views

Apache VERY high page load time

My Drupal 6 site has been running smoothly for years but recently has experienced intermittent periods of extreme slowness (10-60 sec page loads). Several hours of slowness followed by hours of normal ...
2
votes
3answers
8k views

Accessing PHPMyAdmin via URL (without cPanel)

I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root. I cannot seem to be able to make another account for cPanel either, and research indicates this ...
2
votes
1answer
1k views

Trouble creating new MySQL user/database with PHPMyAdmin

I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I now want to add a new user and new database. So, I went to the ...
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 ...
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 ...
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 ...
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 ...
2
votes
2answers
2k views

Login script with member area/user

Is there a free script which I can use to: Share some PDF with my partners. But i need the user to reach only those PDFs which they have privileges for. So I need: login script with registration (i ...
2
votes
1answer
2k views

Can't log in to phpMyAdmin after removing MySQL root password

I get this messege: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried changing the password in phpMyAdmin config.inc.php from root to '' but all I got was Cannot connect:...
2
votes
1answer
2k views

How to ensure mysql starts automatically if server restarts on Ubuntu Server

Occasionally for various reasons my webhost 'reboots' my VPS after doing some routine maintenance or upgrades. However when they do, or if I reboot the server for any reason myself, mysql doesn't ...
2
votes
1answer
744 views

GoDaddy-Drupal Site down due to mysql password change, how to change it back?

PDOException: SQLSTATE[28000] [1045] Access denied for user 'lev1127301002684'@'188.121.41.131' (using password: YES) in lock_may_be_available() (line 167 of /home/content/69/8327469/html/includes/...
2
votes
1answer
327 views

Could you recommend a good shopping cart script? [duplicate]

Possible Duplicate: Which Ecommerce Script Should I Use? I'm looking for a PHP/MySQL script, free or not. Could you please recommend me one that can do the following: The site I'm trying to ...
2
votes
2answers
206 views

Photoblogging engine using PHP and MySQL or PostgreSQL

I am looking for nice looking and with good usability photo blogging software to run on my server. So far I have found PixelPost, Cheesecake and EZPX. PixelPost - look quite abandoned project ...
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 ...
2
votes
1answer
59 views

How do I solve this error when importing MySQL databases into phpMyAdmin?

As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their ...
2
votes
1answer
1k views

Managing Xampp on USB for Mac and Windows machines

I am working on some PHP projects (Wordpress mostly) with MySQL databases and primarily use my Windows Desktop to do the work on whilst running Xampp. This all works great until I need to take my ...
2
votes
1answer
117 views

Unified data source for k2 installed Joomla websites

I am responsible for a few web sites of my organization. I use Joomla! 2.5.9 for those web sites. They all are running at the same server. I use K2 component for content managing. I have a general ...
2
votes
2answers
985 views

php+mysql account management software?

I need an account system added to my website as a plugin to all of my HTML pages. The account system plugin needs to,register new users, log in current users, remove users who want to disconnect ...
2
votes
2answers
1k views

Wordpress 3.3.1 mySQL very high CPU usage [closed]

My host has given me this log and tells me its mySQL overloading my server: | 266976 | db_name | localhost | db_name | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS ...
2
votes
1answer
2k views

When I am root, “mysql” connects without a password, even though I've set one [closed]

When I am root, "mysql" connects without a password, even though I've set one: # mysqladmin -u root password 'whatever' # mysql -u root -p Enter password: (typing the 'whatever' above) Welcome to the ...
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 ...
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 ...
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 ...
2
votes
0answers
67 views

Good security practice for writing a php/mysql web app [closed]

I'm about to create a web app that is php/mysql based. It should contain multiple users and two levels of admin accounts. It will most likely not be very likely to be attacked in any way. Still I am ...
2
votes
0answers
111 views

How many connection can my website have? [closed]

As the traffic increased my website hangs quite regularly. The page visit is now averaging 50k per day. The static page loads fine, but when the page has mysql request it takes too much time to ...
2
votes
0answers
16 views

Hosting advice for a write-heavy dynamic website [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I have built a website using PHP and MySQL and now I am looking for a hosting service. I am expecting about a 1000 users ...
2
votes
1answer
74 views

i got mysql error on this statement i don't know why [closed]

i got mysql error on this statement i don't know why error is: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
1
vote
3answers
320 views

Multi site wordpress setup

Currently my company has 3 blogs and what I did was to install three instances of wordpress over Apache/MySQL, in different directories. The problem is that I have a Slicehost VPS with 256Mb RAM with ...
1
vote
4answers
83 views

Is it possible to represent MySQL database as text files?

I find manually editing MySQL databases tedious. If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
1
vote
4answers
653 views

Setting up a LAMP VM server for Development and Testing?

Info: I would like to set up a VM server on my local computer which will serve pages in the exact same way as my current hosting (but only to me on my local computer). I currently pay a big web ...
1
vote
2answers
261 views

Connecting to my new server

I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database. Now everything is done. But where can I find ...
1
vote
7answers
256 views

Things to consider while choosing a web hosting service? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? Also does the country matter?
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
10k views

Add more than one host to user login privileges in phpMyAdmin

As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames. How can I accomplish this?
1
vote
4answers
3k views

Best lightweight PHP/MySQL forum with spam-protection [duplicate]

Possible Duplicate: What Forum Software should I use? I have already searched and checked out posts like this and this but it isn't what I'm looking for. I'm looking for a lightweight PHP/...
1
vote
3answers
2k views

Symfony project on multiple servers

How can I use Symfony across multiple servers? I have a high-load project and I want to move parts of it(for example: image handlers, video handlers, registration) to other servers.
1
vote
3answers
95 views

What is hosting space and why is it increasing every day?

My hosting's disk space is increasing every day and I just wanted to know, why? I don't upload new files, but it still gets increased by every day. Anyone knows? Thank you.
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 ...
1
vote
3answers
58 views

Moving MySQL database to another server

I have a website build using Q2A engine Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes only. I've copied all the files and ...
1
vote
1answer
423 views

What database engine should I use? [closed]

I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
1
vote
2answers
1k views

How to run the PHP script at scheduled time

I need a valuable suggestion that I have to run the PHP script at the scheduled time daily to update some fields in database and to send automated email. How I can do this? Is it possible to write ...
1
vote
1answer
169 views

PhpMyAdmin - Changing charset

How may I change the database/Tables/Attributes charset using PhpMyAdmin (No SQL statement, only hand-and-mouse actions) ? I only see the option for the Collation (inter-classement).
1
vote
1answer
229 views

PHP - How to Backup and Move Wordpress Blog Website to different directory on the same host

I setup a blog for development purposes on the *.com/a/ directory and now want to move it to the root directory *.com on the same host. How do I Backup and Move the Wordpress Blog Website to the ...
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
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
3answers
101 views

How to download database of wordpress from another server?

I am writing a script to take backup of WordPress database through another server If I know ftp and wordpress login details, then how can I download wordpress database from another server. This is ...
1
vote
1answer
328 views

Changing MySQL password in WHM

When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password." If an account has multiple MySQL databases, what password is it going to ...