Followers

My SQL -Hot copy

mysqlhotcopy
FormatDescription
--addtodestDo not rename target directory (if it exists); merely add files to it
--allowoldDo not abort if a target exists; rename it by adding an _old suffix
--checkpointInsert checkpoint entries
--chrootBase directory of the chroot jail in which mysqld operates
--debugWrite debugging log
--dryrunReport actions without performing them
--flushlogFlush logs after all tables are locked
--helpDisplay help message and exit
--hostConnect to MySQL server on given host
--keepoldDo not delete previous (renamed) target when done
--methodThe method for copying files
--noindicesDo not include full index files in the backup
--passwordPassword to use when connecting to server
--portTCP/IP port number to use for connection
--quietBe silent except for errors
--regexpCopy all databases with names that match the given regular expression
--resetmasterReset the binary log after locking all the tables
--resetslaveReset the master.info file after locking all the tables
--socketFor connections to localhost, the Unix socket file to use
--tmpdirThe temporary directory
--userMySQL user name to use when connecting to server

1 comment: