O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Exporting Structure and Data (Backup)

Keeping good backups is crucial to a project. Backups consist of up-to-date backups and intermediary snapshots taken during development and production phases. The export feature of phpMyAdmin can generate backups, and can also be used to send data to other applications.

Dumps, backups, and exports

Let's first clarify some vocabulary. In MySQL documentation, you will encounter the term dump, and in other applications, the term backup or export. All these terms have the same meaning in the phpMyAdmin context.

MySQL includes mysqldump—a command-line utility that can be used to generate export files. But the shell access needed for command-line utilities is not offered by every host provider. Also, access ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required