An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Tuesday, February 24, 2009

MySQLDUMP Options for Database Backup

No comments :
MySQLDUMP Options for Database Backup

Following are the important MySQLDUMP options for your use:

MySQL Dump Options



Add a DROP DATABASE statement before each CREATE DATABASE statement


Add a DROP TABLE statement before each CREATE TABLE statement


Surround each table dump with LOCK TABLES and UNLOCK TABLES statements


Dump all tables in all databases


Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB Cluster table


Use complete INSERT statements that include column names


Include all MySQL-specific table options in the CREATE TABLE statements


Dump several databases


Include dump date in "Dump completed on" comment if --comments is given


Use multiple-row INSERT syntax that include several VALUES lists


Deprecated. Now renamed to --lock-all-tables


Do not dump the given table


Write INSERT statements with the IGNORE option


This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE


Lock all tables across all databases


Lock all tables before dumping them


This option suppresses the CREATE DATABASE statements


Do not write CREATE TABLE statements that re-create each dumped table


Do not write any table row information (that is, do not dump table contents)


Add SET NAMES default_character_set to the output


This option issues a BEGIN SQL statement before dumping data from the server


Override the --databases or -B option


Dump triggers for each dumped table


Verbose mode


Display version information and exit


Dump only rows selected by the given WHERE condition


Produce XML output

Featured Blog Topics:

No comments :