From The Scripters Wiki

---

This page is for a tutorial for backing up your database.

Logging In

First, browse to <code><nowiki>http://www.{yourdomain.com}/cpanel</nowiki></code> and you'll see a login dialog like this:

Or this:

(Note: These are only samples of what you'll get.)

Next, log in with the user name and password that your host gave you (in the case that you're being hosted by us, it's the one we sent you). And you that will get you into cPanel.

phpMyAdmin

Scroll down to "Databases" and click on phpMyAdmin (as pictured below):

Selecting the Database

After phpMyAdmin loads, select your database, in most cases you'll want to select {username}_phpbb, _wdp01, etc. As you can see in this picture, it shows a list:

And here, I selected "thescrip_wiki" to backup the Wiki application (pages, posts, etc).

Exporting

When the database information shows up, click on "Export" along the top:

If not all the tables are selected, click "Select All" to highlight everything in the list.

The default option is usually "SQL" -- if it is leave it, if not change it to "SQL" and uncheck "Extended Inserts" under the "Data" section:

Lastly, if it's a large database (like phpBB or WordPress that's been running for at least a few months), then go ahead and select "gzipped" -- otherwise, it's okay to leave on "None." Then just click on "Go" on the bottom right.

This will bring up a "Save Download" window where you can download the backup to your computer for storage.

Congratulations!

You have now successfully backed up your database and your information is now safe.

To see how to restore a database, see Tutorial:DB Restore.