Web Hosting Forum | Lunarpages

Author Topic: Ideal way of taking backup of website and database  (Read 4805 times)

Offline pratik

  • Trekkie
  • **
  • Posts: 18
  • i Design
    • Pratik Bagaria
Ideal way of taking backup of website and database
« on: March 20, 2010, 05:50:58 AM »
Hi there,

I hope its the right section I am posting into.

I manage many websites some small and some big ones. My client always asks me to take backup of there website, which I guess is right.
All my clients are hosted at Lp servers using cPanel.

The question here is how should I take backups of the site, so that incase of some problem the latest backup can be restored by the LP support team.  :-?

In cPanel I find 3 ways of taking backups, namely:
  • Full Backup
  • Home Directory
  • Download a MySQL Database Backup

Now, in Full Backup what happens is that it generates a full backup and emails me when its done. So that I can download the file on my local machine. This is fine for small websites. But for large websites downloading files over 500MB every alternate week is a problem. Here I have a query. Is it necessary to download the backup file on the local machine? or LP team can restore the data directly incase the site goes down or gets hacked? And where is this file located on my FTP, so that I can delete once I have downloaded it?

In Home Directory Backup, what does it actually contains? All the FTP files, including the sub-domains and addon domains?

I understand that MySQL DB Backup will backup my DB. But downloading all DB files and Home Directory individually is time consuming (as compared to downloading individual file in Full Backup)

 :help: Please someone could suggest me, the ideal way for taking backup for big and small websites, which if needed would be easy for the LP team to restore the same.

Thanks a ton.


Regards,
Pratik


Offline Mitch

  • Berserker Poster
  • *****
  • Posts: 12641
    • MitchKeeler.com
Re: Ideal way of taking backup of website and database
« Reply #1 on: March 22, 2010, 04:24:36 AM »
I would suggest doing the home directory backup and the mySQL database backup for each hosting account.  Full backup should do both, however this way you can lower the strain on the server (depending on how big your backups are) and it helps when organizing your data to store on your side after you have downloaded the backup.  Hope that helps!
New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!

Offline pratik

  • Trekkie
  • **
  • Posts: 18
  • i Design
    • Pratik Bagaria
Re: Ideal way of taking backup of website and database
« Reply #2 on: March 22, 2010, 11:51:29 PM »
I would suggest doing the home directory backup and the mySQL database backup for each hosting account.  Full backup should do both, however this way you can lower the strain on the server (depending on how big your backups are) and it helps when organizing your data to store on your side after you have downloaded the backup.  Hope that helps!

Thanks Mitch for your reply.

So as per you suggestion I am getting that doing a Full Backup once in 15 days will be quite enough. And then I can download that Full Backup file on my local machine.
Also can you let me know as to where the Full Backup files are saved on the server, so that I can delete the same once its downloaded.

Regards,
Pratik


Offline Mitch

  • Berserker Poster
  • *****
  • Posts: 12641
    • MitchKeeler.com
Re: Ideal way of taking backup of website and database
« Reply #3 on: March 23, 2010, 06:55:45 AM »
Should be in your user folder, outside of the public_html folder.  :thumb:
New to Web Site Hosting? Check Out the Lunarpages Blog Hosting Guide!


Follow us @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!

 

Share |