mysqlddump to create file for replica build
Posted by: Tim Morgan-Barrett
Date: April 26, 2012 02:25AM

hi guys,

we have been using the following to dump our server, one so that we have a backup, and two so we can use the file to create the replica on another server.

here is the command line:

"mysqldump --host=192.168.*.* --user=user --password=password --routines --master-data=1 --comments --single-transaction --all-databases --extended-insert > d:\SQL01alldata.sql"

usually it works but the result is a little odd. we rebuild the file on the other server, but all the views are created as tables...

any ideas ?

Tim

Options: ReplyQuote


Subject
Written By
Posted
mysqlddump to create file for replica build
April 26, 2012 02:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.