Entry

How can i transfer a database from my computer at home to the one at work ?

Feb 24th, 2008 00:21
dman, kevin cheung, Michael Mak, Teddy Simon, Daniel Platon, http://www.ttnr.org

1. Dump your database with the command mysqldump -u "User" -
p "Pass" "Databasename" > "Outfile".
2. Import the dumpfile in another database with the command mysql -
u "User" -p "Pass" "Databasename" < "Outfile from above".
There are some MySQL GUI tool for data transfer, you could try to 
download PremiumSoft Navicat (http://www.mysqlstudio.com), it supports 
to perform data transfer actions in these situations :
1. Local MySQL server to Remote MySQL server
2. Remote MySQL server to Remote MySQL server
3. Remote MySQL server to Local MySQL server
For Navicat, you can also set schedule for the data transfer action.