Wednesday, February 13, 2008

GoDaddy MySQL and MSSQL Database Backup

What is the important part of your website ? I think it is a website data. If you are using one of website applications (like image gallery, CMS, blog, discussion board etc.) probably most of the information will be stored in the database. Without this information these applications aren't worth a lot.

What can occur to my database information ?
  • Database server crash. I know, web host must take care of it, but ...

  • Damage by hackers.

  • Application error.

  • "I didn't" factor.
If your information is valuable for you, it is recommended to get database backup as well as website files backup regularly (depending on your information growth). You can save a lot of effort creating database backups.

I want to explain an easy and quick method how to create MySQL and MSSQL backup files at GoDaddy:
  1. Log in to your Account Manager.

  2. Click Open next to the hosting account you want to backup.

  3. In the Databases section of the Hosting Control Center, Click the SQL Server or MySQL icon.

  4. Click the pencil icon next to the database you would like to backup to open its edit features.

  5. Click the Backup icon in the menu bar.

It's that simple! Your database backup file is created in the _db_backups folder on the root level of your hosting account. Download this file to your computer using an FTP client program.

Enjoy,
Alex Webs