18 Dec 2011 @ 11:27 AM 

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!

Posted By: admin
Last Edit: 24 Dec 2011 @ 09:02 AM

Tags: , , ,
Categories: Computer tips


Responses to this post » (None)

Post a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

Let me check if you are a human! Answer the question: *

 Last 50 Posts
Change Theme...
  • Users » 4
  • Posts/Pages » 62
  • Comments » 155
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight