Dumps, backups, and exports

Let us first clarify some vocabulary. In MySQL documentation, you will encounter the term dump, and in other applications, 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 to the export feature from within the web interface is more convenient. This is why phpMyAdmin offers the export feature with more export formats than mysqldump. This chapter will focus on phpMyAdmin's export features.

Before starting an export, we must have a clear picture of the intended goal of the export. The following questions may be of help:

• Do we need the complete database or just some tables?

• Do we need just the structure, just the data, or both?

• Which utility will be used to import back the data?

• Do we want only a subset of the data?

• What is the size of the...