Backing up your database using phpMyAdmin is easy: you've to do following steps:
  1. Once you have reached the phpMyAdmin screen, select the database you want to back up.
  2. Select the 'export' tab on the top right of the screen.
  3. Scroll down the page and click 'Save as file' and click on the 'go' button. This will save a copy of your database on your local computer.

You can select the preferred format: .SQL, .CSV, MS Excel, LaTeX, .PDF, .XML 
To make a backup copy, .SQL format is preferred.

Found this article interesting?
Subscribe to DomainRegister´s newsletter!

You can unsubscribe at any time by simply clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp s privacy practices here.

  • MySQL, phpMyAdmin
  • 24 Users Found This Useful
Was this answer helpful?

Related Articles

 How to automate MySQL backup using R1soft-Idera backup

Plain R1soft-Idera backup does not directly support mySQL database backup. But with this...

 How to Backup Your MySQL Database Using PHP

This simple PHP script will provide a full dump of your MySQL database.You need to provide...

 How to repair tables in MySQL

Table corruption in MySQL is a very frequent issue, which primarily happens due to failed/forced...

 How to import a db dump in a database with different name

 How to generate random string in MySQL

If you need to create random string (i.e., to be used as password) in MySQL, you can easily do it...