How To Back Up Your Entire Database
Log onto
phpMyAdmin
using your database name (which is your domain name without a dot, ie: yourdomaincom)
and your database password.
Click on your database name in the left side list.
Click on the Export tab link at the top.
Select Structure and Data
Click on the Select All link.
Click on the check boxes next to all the options:
- Add 'drop table'
- Complete inserts
- Extended inserts
- Enclose table and field names with backquotes
Click on the check box next to Save As File. Select gzipped.
Your download should start. Save this file to your hard drive.
You can extract the database file using any program that handles gzipped files
such as WinZip or
PowerArchiver.
For more information on importing and exporting your database, please
see How To Import and Export Data From A Database.
|