mysqlddump to create file for replica build
Date: April 26, 2012 02:25AM
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 ?
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.