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.

How to restore a mySQL database using phpMyAdmin:

Click on your database name shown on the upper left of phpMyAdmin

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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What database settings do I use for scripts?

Server Hostname: localhost Database Username: <your username>_<database name> e.g....

How do I add a wildcard subdomain for Wordpress MU?

This can be easily done by logging into your cPanel control panel and clicking on "Subdomains"....

Do you support Silverstripe Hosting?

Yes, we run Linux servers designed to run the New Zealand developed Silverstripe application. If...

Strict Standards Errors for PHP

If you are getting errors similar to:Strict Standards: Non-static method JLoader::import() should...

Fix permissions of all directories and files

To change all the directories to 755 (-rwxr-xr-x): find /home/xxx/public_html -type d -exec...