MySQL :: MySQL Backup and Recovery :: 1.4.5.1 Making a Copy of a Database

MySQL Backup and Recovery :: 1 Backup and Recovery :: 1.4 Using mysqldump for Backups :: 1.4.5 mysqldump Tips :: 1.4.5.1 Making a Copy of a Database

« 1.4.5 mysqldump Tips

1.4.5.2 Copy a Database from one Server to Another »

Section Navigation [Toggle]

1.4.5 mysqldump Tips
1.4.5.1 Making a Copy of a Database
1.4.5.2 Copy a Database from one Server to Another
1.4.5.3 Dumping Stored Programs
1.4.5.4 Dumping Table Definitions and Content Separately
1.4.5.5 Using mysqldump to Test for Upgrade Incompatibilities

1.4.5.1. Making a Copy of a Database

shell> mysqldump db1 > dump.sql
shell> mysqladmin create db2
shell> mysql db2 < dump.sql

Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql command line.

Top / Previous / Next / Up / Table of Contents