These instructions are based on my own setup where the database is on a localhost on my own computer. Situations may be slightly different if the database is hosted elsewhere.
For this example we're looking at backing up a database named 'joomla15'.
IMPORTANT NOTE : Within the SQL structure it is possible to select databases, tables, or individual fields for editing, backup, deletion etc. These work instructions however are only concerned with backing up the WHOLE database. Unless you know what you're doing I would suggest you don't deviate from them as you can really screw things royally.
Step 1: Step 1 - XAMPP Control Panel
i.Click on the Admin button from XAMPP control panel.
ii.Type 'http://localhost/phpmyadmin' into the URL bar of a web browser.
You might need to enter a password for the root user.
Once in, the interface should look like this
Step 3: PhpMyAdmin Interface
Step 4: Database Selection
Take note of the number in ( ). In this case it is 45 which means that there are 45 tables contained within the database.
Step 5: Database Tables
On the left there is a list of all the tables contained within the database (green). On the right (main) part of the screen the tables are listed again with a set of possible actions for each one (blue).
WARNING: Unless you're really sure you know what you're doing, don't fiddle with anything here.
At the top of the screen are a set of tabs. Select the one marked 'Export'.
Step 6: Export Main
Step 7: Export 1
In this section you can specify which tables you'd like to backup. The default is for all of the tables but it doesn't hurt to select the 'Select All' link again.
Step 8: Export 2
Step 9: Export Options
Leave as default settings.
Step 10: File Structure
We will select two extra check boxes, over and above the default.
The two images here show a before and after in the sql file, when using this option.
Step 12: Add Into Comments
Step 13: Save As File
Should you wish to include a date stamp to your backups you can use the following:
which would result in something like
Step 14: Download !
If you get a choice select where you want to save the file. If you don't get the chance you will need to select your default download location.
With WINDOWS this could be either the desktop or a directory under the 'My Documents'