Website backup usign cPanel.

Taking backup of your website is most important part which will be useful in case of server crash or some hardware failure. If you have backup of your site then you can easily restore it so as a webmaser you should always be prepared with backup copy of your entire website. if you opt for linux website hosting plan you may get cpanel as control panel using which you can easily upload your website, can take backup of your site including home directory, databases, emails etc… you can keep backupĀ  of your website in
zipped file which can be restored anytime you want.
For better security reasons it is always suggested to have automated backup for your website for this you will have to set such setting [ cron jobs ] using your cpanel. Using cPanel you can take Full backup, Home directory backup, MySQL database backup, email forwarders or filters which can be restored anytime.
If you opt for full backup of your site, you will have an archive of all files and configurations of your website. If you want to restore your Full website backup them you will have to contact your webhost, you cannot restore Full backup using your cPanel you will need to contact your webhost.

Steps fort taking Full Backup using cPanel :
*) Login to your cpanel and go to ‘backup’ section under “Site management”
*) Click on “Generate/Download a Full Backup”
*) Just choose proper option for backup of your site, if you want to copy full backup of your site onto other ftp server you can do so, else you can easily generate backup in your home directory of your account, which can be used further in case of server crash.
*) Proceed with email ID.
*) Finally, complete process by pressing ‘generate backup’
Taht’s all you have backed up full website usign cPanel.

Posted under Fantastico Hosting, Reseller Hosting, WHM cpanel Hosting, cPanel account Hosting

This post was written by on April 9, 2008

Tags: , , ,

Backup Restore databases using SSH

Taking backup and restore database via SSH :

You can easily take backup of your databases through SSH by firing few commands. You need to login to your accout via SSH client once you get into your account use following command /usr/bin/mysqldump $databasename -u $user -p$password > /path/to/file.sql
Please make sure you put all required info for all $varilables for above command. You can consider an example with username ‘jack’ and you want to backup a databases named ‘jack-phpbb’ which is accessed by user jack_forums and a password of supp0rt. so above command will look like following comand with all required parameters.
/usr/bin/mysqldump jack-phpbb -u jack_forums -psupp0rt > /home/jack/file.dump
In case if you are forget or don’t know the database username or password you can take help you of your MySQL screen of your cPanel to get required information. Make sure you don’t keep any space between passward and -p operator.
Thus you have backup of your database at /home/jack/file.dump which can be restored anytime you want. For some reason you need to restore your backup databases you will have to use following command so that you can restore them
mysql $databasename -u $user -p$password < /path/to/$dump_file
You will have to use all required substitue for $variables for above commands.
Let’s say you have a batabases backup file called backup.sql which is already uploaded under public_html directory and now you need to restore it. so you have account username as ‘jaack’ and you are looking for restoring databases called ‘jack-phpbb’ you will have to modify above command as per this parameters as
mysql jack_phpbb -u $jack_forums -p$supp0rt < /home/jack/public_html/backup.sql
Thus you can easily take and restore backup of databases through SSH using above commands.

Posted under Fantastico Hosting, Reseller Hosting, WHM cpanel Hosting, cPanel account Hosting

This post was written by on April 9, 2008

Tags: , , ,