Whenever you need to make a change to your database, move it to another server or just want to back it up for safety purposes you can use phpMyAdmin and this is a very simple process.
- 1. Open up your Control Panel.
2. Select the "MySQL Manager" icon.
3. Now up at the top you will see "To Manage an Existing Database via phpMyAdmin: Have the login information ready and Click Here." click on the "Click Here" to begin.
4. Login to the database you want to backup.
5. Click on the database in the left frame and you should see it in the main frame.
6. Scroll down the page until you see "View dump (schema) of database"
7. Select the following:
a. Structure and data.
b. Send
8. Click on "Go" and it will dump the database to your harddrive with the name of the database and a .sql extension.
Thats it!
Linear Mode
