> 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.
On the production box: mysql -u dbusername -p dbname < dbname.bak.dump > 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? These should be OK. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
