The mysqldump command is frequently used to create an empty instance, or an instance including data, on a replica server in a replication configuration. The following options apply to …

This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format Backups”. By …

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways:

You can use such MySQL programs as mysqldump and MySQL Shell to perform logical backups, dump databases, and similar tasks instead.

This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another

The mysqldump command is frequently used to create an empty instance, or an instance including data, on a replica server in a replication configuration. The following options apply to …

The following command dumps the contents of the db1 database to files in the /tmp database: $> mysqldump --tab=/tmp db1. The .txt files containing table data are written by the server, so …

To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client. If the dump file was created by mysqldump with the --all-databases or - …

$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql. Do not use --databases on the mysqldump command line because that causes USE db1 to be included in …

$> mysql < dump.sql. Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE statements that create the database if it does exist …