Before performing any procedures that affect your database (such as installing or upgrading a module), you should create a backup in case you need to restore your site. The database contains all of the content of your website, as well as its settings and configuration options. As such, any issues caused by bugs in modules, conflicts between code, or data errors can seriously impact the content and functionality of your website.

Most web providers use software called PhpMyAdmin to allow easy administration of the MySQL database software that is also commonly used. This tutorial will focus on using it to create a backup.

1. The exact method for reaching the PhpMyAdmin page for your website differs depending on your web host. Please consult their documentation or consult your system administrator for more detailed instructions in accessing it. It may simply be called something like “DB Admin”. 

1. This is the main page. Begin by clicking on the “Export” link under the MySQL section of the main browser window.

1. This is the export page. Be sure to choose your database’s name in the Export selection box before moving on.

1. Scroll to the bottom and select the “gzipped” compression method and check the “save as file” box.

1. A save file dialog box will pop up. The file you download will contain the backup of your website’s database. You can use this if you need to restore the contents and settings of your website.

Share

Close

• Social Web
• E-Mail

Delicious Digg StumbleUpon Reddit Magnoliacom Furl Facebook Google Yahoo Technorati

Your Email: *

Your Name: *

Send To: *

Enter one address or multiple addresses separated with commas.