Hello,

I am running two instances of mysql. They both run on different boxes, not networked.

Anyway, I have been developing on one machine, and trying to do a dump and keep the 
other box updated with Database changes.

I have ran this from the dev box.
mysqldump --add-drop-table -u dbusername -p dbname > dbname.bak.dump
// or better yet...
mysqldump --opt -u dbusername -p dbname > dbname.bak.dump

to get the latest dump. Then copy this to CD to reimport on the production box. The 
only problem, is I don't seem to understand how to reimport, or use this dump. 
Can anyone help.

PS, I have a lot of blobs and clobs within the Database. Is there anything else I may 
be missing to keep these two synchronized?

Thanks,
Scott


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to