How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database using compression.

 

 1) Login to control panel

 2) From the Databases section, click phpMyAdmin

 3) Click the database you wish to export

 4) Click the Export tab

 5) Click the Custom option under method

 6) Under the output section, select the compression type. Please read our section above about using Zip

 7) Click Go at the bottom of the page

 

That’s it! Depending on the size of your database, it could take some time. However, once it is done compressing the files (on the server), it will automatically start downloading to your computer.

  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql'Then scroll down to the 'access hosts'...

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

Powered by WHMCompleteSolution