Exporting a database creates a downloadable copy of its contents, which is essential for backups, migrations, or moving a site between hosts. In DirectAdmin, you export using phpMyAdmin. This guide walks through it.
When you need an export #
- Backing up before making database changes.
- Migrating a website to another server.
- Handing a copy to a developer.
Exporting with phpMyAdmin #
- Log in to DirectAdmin and open MySQL Management.
- Click phpMyAdmin next to your database and log in.
- Select the database in the left panel.
- Click the Export tab.
- Choose the Quick method and SQL format.
- Click Go to download the .sql file.
Exporting large databases #
If a database is very large, a browser export can time out. In that case use the Custom export option and enable compression (zip or gzip) to produce a smaller file, or ask support for help with large exports.
Keeping your export safe #
- Store the .sql file somewhere secure, as it contains all your data.
- Label it with the date so you know how recent it is.
- Keep more than one recent copy for important sites.
Troubleshooting #
- Export times out: use compression or a custom export.
- File will not download: check your browser’s download settings and try again.
Need help? #
If you need to export a large database, our support team can assist over live chat.
