How do I backup & restore a MySQL database using phpMyAdmin?

How to back up a mySQL database using phpMyAdmin:

You can backup your database using the PHPMyAdmin feature in your control panel. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As..." and click on the "Go" button. Simply save the database that begins to download, on your local computer.

While we do regular backups of all our servers, we do not provide restores for one specific account, folder, file, or database. You will need to make sure you have backed up your latest database(s) on your local machine.

How to restore a mySQL database using phpMyAdmin:

Click on your database name shown on the upper left.

Locate your back up file for the database that you want to restore. Open it and copy the entire contents.

Paste into the field called "Run SQL query/queries on database yourdomain_com" and click the "Go" button

  • 14 Χρήστες που βρήκαν αυτό χρήσιμο
Ήταν χρήσιμη αυτήν την απάντηση;

Related Articles

Can I connect to MySQL remotely?

Yes, you can connect to your MySQL database remotely. Remember to enter the IP address or...

What is the number of maximum connections allowed to a single MySQL database?

We allow up to 50 simultaneous connections per MySQL user, and up to 1500 simultaneous...

Connecting to MySQL through PHP...

Use the following outline to connect and begin querying the MySQL server from within your PHP...

How to I create a MySQL Database?

To create a mysql database, log into your control panel and select the 'MySQL Databases' link....

What version of mySQL are you currently running?

The latest stable build of mySQL. Generally we do not include the version information on the...