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

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

• How to dump stored programs (stored procedures and functions, triggers, and events)

• How to dump definitions and data separately