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!
Share on Facebook