Backup MySQL Using PhpMyAdmin

Step 1 – Backing up using phpMyAdmin
1. Login to phpMyAdmin.

2. Select the database you wish to use.

3. On the navigation bar on the top, select “Export” (besides SQL, Structure, Search, Query… etc.)

4. You should now be presented with a nifty little page which shows all the tables in the database, SQL Options and Save Types. *

5. To backup the whole database, click “Select All” under the list of tables in the page.

6. To backup a selected few, just hold down CTRL on your keyboard and select the tables you wish to backup (release the key when all selecting is done).

7. SQL Options can be left as default, but I suggest ticking the “Add DROP TABLE” option as if you are restoring a backup on a database that already exists and has the table in it – you will get a lot of errors! This way, by ticking the “Add DROP TABLE” option you will avoid the errors. For more information on the options just click the little “?” icon after SQL Options.

8. If you want to save the backup as a file (recommended) then tick “Save as file” – Leave file name as is or edit for your needs. Select “gzipped” as compression. Now click “Go”. If asked, choose “Save to disk” and save it wherever on your computer (it may take sometime depending on the size).

9. If you want to show the whole backup SQL on your browser window, don’t tick “Save as file” – once you have selected the tables you wish to backup (explained in step 5/6) click “Go”. The page will now change and should show the SQL information (it may take sometime depending on the size). Copy and paste it to a text file or do whatever you want with it!

Note: Yes, the tables of the database will be shown to the far left in a frame, but they will also be displayed in a different form on this new page to the right in phpMyAdmin.

Congratulations! You have successfully backed up your database / selected tables!

Step 2 – Restoring your database using phpMyAdmin

1. Login to phpMyAdmin.

2. Select the database you wish to use.

3. On the navigation bar on the top select “SQL” (besides Export, Structure, Search, Query… etc.)

4. You should now be presented with a little page which allows you to run SQL query/queries on the database, either by inputting the query/queries to the input box or by locating a text file on your computer.

5. You now have 2 options: 1) Paste the SQL which you backed up earlier in the “Input Box” and click “Go” or 2) If you saved the file on your PC then use the option below the first one; Click Browse > Locate the File > Click “Go”. (Note: Most servers set a “Max File Size” for uploading the SQL, the size appears beside the Browse button.)

6. It may take sometime for the file to be uploaded and fully run, so give it a chance. Once it worked, it will bring you back to the same page and should confirm if all went well “Your SQL-query has been executed successfully: The content of your file has been inserted.”

3 thoughts to “Backup MySQL Using PhpMyAdmin”

  1. I have decided to move my domain to datakl servers and thanks for yesterday promotion i’ve already got what i need… but the question now, do i have to backup MySQL???

    I already backup my current page (blog) using the wordpress’s export feature , is that not enough??

    I haven’t start the migration… waiting for my previous server admin e-mail my domain cpanel login to change my domain dns.

  2. If you use Cpanel we can restore your site – email, database and files. We can backup and restore for you. Just request copy service from support.
    You need to have access to domain control panel to point the domain to our server.

  3. Great advice!!! But why have a different backup service when you can all your files with one service. I use SafeCopy backup, http://www.safecopybackup.com, to backup all my files plus I can backup my iPhone, smartphone, USB drives and share files as well. I can also backup both my Mac and PC with one account. I’m very happy with it.

Leave a Reply

Your email address will not be published. Required fields are marked *