Backing up the Databases

It's important to back up the CCWebworking Databases on a regular basis (once a week is ideal, every other month is probably the minimum). The databases contain everything about the site's function, including every blog post, article, image, etc., as well as many of the site's technical settings and options.

Here is the backup procedure:

1. Login to http://admin.1and1.com
   (The domain is ccwebworking.net, the password should be the same as your admin account).
2. Click on "MySQL Administration."
3. Click the "phpMyAdmin" button for the single database (db238043290).
4. Click the database name (db238043290) on the left of the screen.
5. Click "Export" at the menu that appears at the top of the screen.
6. Click "Select All" Under the "Export" header.
7. Check the box next to "Add DROP TABLE" if it is not already checked.
8. Check the box next to "Save as file" if it is not already checked.
9. Change the File Name Template to "__DB___%D" (This will include the date of your backup in the file name, making it easier to keep track of multiple backup files)

   Your screen should now look like this: Click for full size

10. Click the "Go" button. You will be prompted to save the file to your computer. Save it, and you're done!

It's advisable to keep a copy of this file on your personal computer, as well as on a designated Pratt computer. Old backups should be kept for at least five backup cycles, in order to enable returning to a previous, functional version if anything becomes corrupted and goes unnoticed for some time.