MySQL Database Backup MySQLDump Parameters Option Utility, for backup or pour a database or multi-database for backup to another SQL server. Drop will contain the SQL statement that creates a table or a full table. Shell> mysqldump [options] Database [TABLES] If you do not give any table, the entire database will be poured. By performing mysqldump --help, you can get the option table for your MySQLDUMP's version support. Note that if you run mysqldump without --quick or --opt option, MySQLDUMP will load the entire result set to memory before the resulting result, if you are pouring a big database, this may be a problem. MySQLDUMP supports the following options: --Add-Locks increases Lock Tables before each table and then UNLOCK TABLE. (In order to make it faster into mysql). - ADD-DROP-TABLE adds a DROP TABLE before each CREATE statement. - Allow-Keywords allows you to create column names for keywords. This is died by the table name. -C, --Complete-INSERT uses a complete INSERT statement (with column name). -C, --Compress If both the customer and the server support compression, compress all information between the two. --Delayed inserts the line with the insert delayed command. -E, --Extended-INSERT uses a new multi-line INSERT syntax. (Give a more tightening and faster plug-in statement) - #, --debug [= Option_string] Tracking program (for debugging). --Help displays a help message and exits. --fields-terminated-by = ... --fields-enclosed-by = ... --fields-optionally-enclosed-by = ... --fields-escaped-by = ... --fields- Terminated-by = ... These options are used with -t selection and have the same meaning of the corresponding Load Data INFILE clause. See 7.16 Load Data Infile syntax. -F, --flush-logs is washed away in the Mysql server before starting dumping. -F, --force, even if we get a SQL error during a surface, continue. -H, --host = .. Dipped data from the MySQL server on the named host. The default host is Localhost. -L, --lock-tables. To start dumping all tables. -T, --NO-CREATE-INFO does not write table creation information (CREATE TABLE statement) -d, - NO-DATA does not write any of the line information. If you just want to get the dump of a table, it is useful! --Opt with --quick -dd-drop-table --add-locks --extended-insert --lock-tables. You should give you as fast as possible to read a MySQL server. -Pyour_pass, --password [= Your_pass] The password used when connecting to the server. If you don't specify a "= Your_Pass" section, MySQLDUMP needs a password from the terminal. -P port_num, --port = port_num The TCP / IP port number used when connecting to a host connection. (This is used to connect to hosts other than localhost because it uses UNIX sockets.) -Q, --quick does not buffer query, dump directly to stdout; do it using mysql_use_result ().
