|
Database HowTo's -
MySQL HowTo's
|
|
Written by Allen Sanabria
|
|
Saturday, 09 February 2008 23:58 |
Now that you know how to backup your database,I will show you how to restore it on another database.
-
The most common and basic way to restore, is a restore of a database.
- mysql -u test1 --password=pass1 world < world.sql
-
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
|
|
Last Updated ( Wednesday, 14 May 2008 11:55 )
|
