How to restore a MySQL Database

 Uncategorized  No Responses »
Feb 102008
 

Now that you know how to backup your database,I will show you how to restore it on another database.

    1. The most common and basic way to restore, is a restore of a database.

    • mysql -u test1 –password=pass1 world < world.sql

    2. How about restoring your database to another database over the network with out logging into that box…

    • mysqldump -u test1 –password=pass1 world | mysql –host=170.20.10.32 -C world

Warning: fopen(/home/dynasty/linuxdynasty.org/wp-content/plugins/wp-google-plus-one/lib/standard.txt) [function.fopen]: failed to open stream: No such file or directory in /home/dynasty/linuxdynasty.org/wp-content/plugins/wp-google-plus-one/plusone.php on line 104

Warning: fread(): supplied argument is not a valid stream resource in /home/dynasty/linuxdynasty.org/wp-content/plugins/wp-google-plus-one/plusone.php on line 105

Warning: fclose(): supplied argument is not a valid stream resource in /home/dynasty/linuxdynasty.org/wp-content/plugins/wp-google-plus-one/plusone.php on line 106
.