How to create a database dump using PHPMyAdmin?

Created:

2017-07-25 22:49:48 UTC

Modified:

2017-08-08 13:12:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to create a database dump using PHPMyAdmin?

Question

How to create a database dump using PHPMyAdmin?

Answer

  1. Go to Domains > example.com > Databases > database_name.
  2. Click PHPMyAdmin.
  3. Click on Export from the top set of tabs.
  4. Select the tables from the list that you would like to dump. To dump the entire database, click Select All.
  5. Make sure both the "Structure" and "Data" boxes are selected on the right.
    In the Structure section, check the "Add DROP TABLE / DROP VIEW" box to make exported file to be able to replace existing tables of the same name. To merge this backup with another database, do not select this.
  6. Check the "Save as file" box. Also, select a compression option (such as "gzipped") to compress the backup before downloading it from the server.
  7. Click the Go button, and, at the prompt, save the file to the local computer.
Have more questions? Submit a request
Please sign in to leave a comment.