Linux mysqldump command help with mysqldump examples, syntax, and related commands. On Windows, connect to the. Mysqldump also does not dump the MySQL Cluster.
7.4.1 Dumping Data in SQL Format with mysqldump This section describes how to use to create SQL-format dump files. For information about reloading such dump files, see. By default, writes information as SQL statements to the standard output.
You can save the output in a file: shell mysqldump arguments filename To dump all databases, invoke with the option: shell mysqldump -all-databases dump.sql To dump only specific databases, name them on the command line and use the option: shell mysqldump -databases db1 db2 db3 dump.sql The option causes all names on the command line to be treated as database names. Without this option, treats the first name as a database name and those following as table names. With or, writes and statements prior to the dump output for each database. This ensures that when the dump file is reloaded, it creates each database if it does not exist and makes it the default database so database contents are loaded into the same database from which they came. If you want to cause the dump file to force a drop of each database before recreating it, use the option as well.
In this case, writes a statement preceding each statement. To dump a single database, name it on the command line: shell mysqldump -databases test dump.sql In the single-database case, it is permissible to omit the option: shell mysqldump test dump.sql The difference between the two preceding commands is that without, the dump output contains no or statements.
![Install Mysql Dump Windows Command Install Mysql Dump Windows Command](/uploads/1/2/5/4/125408800/627827418.jpg)
![Mysql export Mysql export](http://www.devarticles.in/wp-content/uploads/2010/10/mysqladd1.jpg)
This has several implications. When you reload the dump file, you must specify a default database name so that the server knows which database to reload. For reloading, you can specify a database name different from the original name, which enables you to reload the data into a different database. If the database to be reloaded does not exist, you must create it first. Because the output will contain no statement, the option has no effect. If you use it, it produces no statement. To dump only specific tables from a database, name them on the command line following the database name: shell mysqldump test t1 t3 t7 dump.sql.