--addtodest | Do not rename target directory (if it exists); merely add files to it |
--allowold | Do not abort if a target exists; rename it by adding an _old suffix |
--checkpoint | Insert checkpoint entries |
--chroot | Base directory of the chroot jail in which mysqld operates |
--debug | Write debugging log |
--dryrun | Report actions without performing them |
--flushlog | Flush logs after all tables are locked |
--help | Display help message and exit |
--host | Connect to MySQL server on given host |
--keepold | Do not delete previous (renamed) target when done |
--method | The method for copying files |
--noindices | Do not include full index files in the backup |
--password | Password to use when connecting to server |
--port | TCP/IP port number to use for connection |
--quiet | Be silent except for errors |
--regexp | Copy all databases with names that match the given regular expression |
--resetmaster | Reset the binary log after locking all the tables |
--resetslave | Reset the master.info file after locking all the tables |
--socket | For connections to localhost, the Unix socket file to use |
--tmpdir | The temporary directory |
--user | MySQL user name to use when connecting to server |
Thanks for sharing this useful information. Its really useful for us.
ReplyDeletesccm migration
windows migrations