exporting data from a database in phpMyAdmin

If you're reading this tutorial, chances are we have set up a form on your website to also send a copy of the data you requested to be stored in a database. This information is easily exported in to a format you can read and use (Word, Excel, PDF)

export all the data in the database

1. Log in to your hosting spaces Control Panel
   www.yourdomainname.com.au/cpanel
2. Click on the phpMyAdmin icon in the Databases section
3. In the left hand column, click on the name of the database group you are exporting
4. Near the top of the screen, click the Browse tab
5. Click the Check All link to select all of the information in the database. If you have a large database, change the number after the Show button to something higher than 30
6. Click the Export link in the Query results operations section at the bottom of the screen
7. In the export box, choose the file type to export - either Microsoft Word, Microsoft Excel or PDF. Excel is the logical choice as you can easily sort and manipulate the data.
8. Place a tick in the box next to Put field names in the first row
9. Scroll to the bottom of the screen, and in the right hand corner, click GO
10. At the prompt, save the file on your local computer. If you get any kind of warning/compatability message as you try to open any Excel file, click YES and continue.

delete data in the database

1. Log in to your hosting spaces Control Panel
   www.yourdomainname.com.au/cpanel
2. Click on the phpMyAdmin icon in the Databases section
3. In the left hand column, click on the name of the database group you are exporting
4. Near the top of the screen, click the Browse tab
5. If you're only deleting a few, simply click on the red cross in line with the database information (it's in a grey line with the name Joanne Musgrave on it in the diagram above).
6. If you're deleting a few, place ticks next to the records you want to delete, and click the red cross that's in line with the Check All / Uncheck All links