- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 3.23, 4.0, 4.1 Reference Manual :: 6 Backup and Recovery :: 6.4 Using mysqldump for Backups :: 6.4.5 mysqldump Tips :: 6.4.5.1 Making a Copy of a Database
Section Navigation [Toggle]
shell>mysqldump db1 > dump.sqlshell>mysqladmin create db2shell>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.
User Comments
Add your own comment.