Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: mysqlddump to create file for replica build


Advanced Search

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 Tim Morgan-Barrett 04/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.