| --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