How can i transfer db between to places

[jeff_borden]

i need to use my db at two different locales. My ftp software doesn't let me upload the mysql db's. is there away that i can transfer the db's between the two places? thanks

[nnichols]

It doesn't sound like a good idea to have the db in two places as the data would not be synchronized. Surely it would be better just to access the database remotely.

But in answer to your question - if you have shell access on both servers you can pipe the results from mysqldump straight into the other server. Something like this -

mysqldump -hhost -uuser -ppass db_name | mysql -hhost -uuser -ppass db_name

Hope this helps 😉

[jeff_borden]

thx for the reply. the project i am working on is in development so I want to send the test db home from work so i can work on it. unfortunately, i'm not running on unix... is there a way to do this on a window$ platform?

[nnichols]

Run mysqldump to get a dump from the db at work -

mysqldump -hhost -uuser -ppass --opt db_name > somefile.sql

Then at home you need to create a db to insert the tables + data into -

mysqladmin -hhost -uuser -ppass create db_name

then run the data into the new db -

mysql -hhost -uuser -ppass db_name < somefile.sql

Once you have the db at home and at work you should also add '--add-drop-table' when running the dump -

mysqldump -hhost -uuser -ppass --opt --add-drop-table db_name > somefile.sql

Hope this helps (makes sense) 😉

[nnichols]

It is worth looking at grabbing one of the gui tools for doing this on a regular basis.

My favorite is MySQL-Front available for download here - http://mysqlfront.venturemedia.de/index.php?act=ST&f=2&t=328

[nnichols]

You can ignore what I said above about adding "--add-drop-table" as this is done automatically when using "--opt".

[jeff_borden]

thank you for your replies. I'll give this a go and see how it works out.....