Drupal, Wordpress And SEO Guru

Sometimes PhpMyAdmin refuses to import a database or the database is too big. Here an easy fix.

Open up a Command Prompt (I like to call it DOS prompt) on your Windows system.  Change your directory to where the file mysql.exe is located (on my system is c:\wamp\bin\mysql\mysql5.5.8\bin) using the DOS command i.e.: cd \wamp\bin\mysql\mysql5.5.8\bin

Start Mysql as root giving this command at the DOS prompt: mysql -u root

Once you get the Mysql prompt use this command: use databasename Obviously you need to use your database name and that must already exist; phpmyadmin should be able to create it. If not, you are in trouble!

Now give this command: source your_saved_database.sql This command assumes that you already copied in the current directory the source file containing the sql queries (change the name your_saved_database.sql into the filename you used to save the database). Otherwise you can give the complete path to that file.

You should get a few messages from Mysql informing you about operations on the database. Now you can quit Mysql giving this command: quit You should get back to the usual DOS command prompt.

Using phpmyadmin you can check if the database has the right number of tables and for each table, the right number of records. Do not be dumb! Always verify what’s going on with your system. The age of Windows (intended as operating system) created tons of careless so called system administrators. The real IT is made of attention to details!

Important: If you don’t have at least a basic knowledge of DOS and mysql databases, do not attempt to work on them!