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 Gerenciamento do MySQL.
- Clique em phpMyAdmin next to your database and log in.
- Select the database in the left panel.
- Clique no botão Export tab.
- Escolha o Quick method and SQL format.
- Clique em 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.
Solução de problemas #
- Export times out: use compression or a custom export.
- File will not download: check your browser’s download settings and try again.
Precisa de ajuda? #
If you need to export a large database, our support team can assist over live chat.
