How to back up your website (Part II)

Blog

Your website is a database driven site, which means that in order for it to function it needs program files (these are the files that provide functionality) and the database—this is where your content actually lives. When viewers click on links in your site, Drupal goes to the database and gathers the necessary content. The program files then display the content on the viewer's screen according to the design and layout Canister developed for you.

As you add pages and change content, your database grows, and images get stored in with your program files. While Canister does keep a copy of your initial site, we do not update our files as you change and frow your site. Therefore, it is important that you make regular backups of your site. Data loss on professionally managed servers is rare, but it can (and does) happen ... protect your investment of time and money! You can decide your own backup schedule, but we encourage you to stay on top of backups!

Backup database with PHPMyAdmin

In this article we describe how to back up your database using the tools you find in your Cpanel.

In order to perform any backup activities you need: Your website name, your cPanel username and your cPanel password

  1. Go to www.yourwebsitename.com/cpanel
    cpanel address
  2. In the login screen, enter your user name and password
    cpanel login
  3. Once you've logged into your control panel, click on PHPMyAdmin
    phpmyadmin

  4. Select the database you want to back up

    select database
  5. Click the "Export" tab at the top of the interface. This will lead you to the export dialogue.
    export tab
  6. Click on "Custom" to show you the options for exporting. Then click on "Select All" to ensure the entire database is selected.
  7. Click on "Save output to a file" and ensure that the format type is set to "SQL"
    export1

  8. Ensure that "Structure and data" is chosen, and check that the rest of the boxes are selected as show below


    export screen shot
  9. Click on the "Go" button to save the database to your computer.
  10. That's it, you're done! Make sure that you back up your website program files too!