MySQL Dump Import Database
September 14, 2010 0
Here's the simple command to restore the database using the file you dumped in the first step:
mysql -u USER -p DBNAME < dump.sql
You might have to make sure the database you're importing into is EMPTY because the import command listed above will not overwrite structures existing already. Use PHPMyAdmin or another set of delete/remove table commands to make sure the structures you're importing do not already exists in the database you're importing into. Other than that, it's simple as pie.
source: http://answers.google.com/answers/threadview?id=24558
Comments
There are no comments for this article yet. Leave a comment!

Latest Comments