To backup your database, you will need to use phpMyAdmin. Most hosts have this script pre-installed. If you can't find it, contact your host.
When you have gotten into phpMyAdmin, you should see a welcome message saying something along the lines of "Welcome to phpMyAdmin".
On the left hand frame on the welcome screen, you should see, just below the home link, the name of your database with a number in brackets (the number in brackets is the number of tables within your database). By clicking this, the right hand frame should update, and you should be presented with a list of all your tables. Scroll down to near the bottom of this page until you find the option:
View dump (schema) of database
Select the option "Structure and Data" and click on the name of the top
table, scroll down to the bottom of the list of tables, hold shift and click
on the bottom table name. Then simply tick the box that says send, and click go,
you should now be presented with a file download box with databasename.sql as
the file. Simply save the file to your hard drive, and there you go, your
database is backed up!
If you want to re-upload your database, simply follow the commands above, but instead of going to "View dump (schema) of database", go to the section marked: Or Location of the textfile, hit the browse button underneath this, locate your .sql database file and click go. Then wait while your database is being uploaded and after that you should see all your database tables appear as normal.
And that's it, you're done!
Screenshot added by Daniel, 25 June 2002.
© 4WebHelp and Justin
Page URL: http://www.4webhelp.net/tutorials/db/backup.php
Back to the "pretty" page!
© 2018, 4WebHelp Team.