{"id":3536,"date":"2016-02-27T21:32:58","date_gmt":"2016-02-28T02:32:58","guid":{"rendered":"http:\/\/underhost.com\/blog\/?p=3536"},"modified":"2016-02-27T21:41:44","modified_gmt":"2016-02-28T02:41:44","slug":"automatic-cpanel-backup-domain-mysql-with-cron-php","status":"publish","type":"post","link":"https:\/\/underhost.com\/blog\/automatic-cpanel-backup-domain-mysql-with-cron-php\/","title":{"rendered":"Automatic cPanel backup (Domain & MySQL) with cron & PHP"},"content":{"rendered":"
Automatic cPanel backup (domain & MySQL) with cron & PHP<\/strong><\/div>\n
\n
\n

The situation is this: You use cPanel on our web hosting server. You use the cPanel backup tool to regularly backup \/home directory (includes my web files, mail, etc), and my MySQL databases. You love the fact that you can use it to backup to a remote FTP server, and you do that on a fairly regular basis.<\/p>\n

The major drawback is that you have to remember\/schedule to perform this backup manually. This becomes especially difficult if you have multiple cPanel accounts. It would be amazing if you could just schedule the cPanel backup to run at regular intervals, perhaps with cron. Well, although there’s no option for that in cPanel, the script below will allow you to do exactly that!<\/p>\n

This backup script includes SSL support. This isn’t necessary if you run the script on the server for which you’re generating the backup; but the SSL support is very important if you’re running the script somewhere else to connect to your cPanel hosting account.<\/p>\n

\n
PHP Code:<\/div>\n
<?php
\n\/\/\u00a0PHP\u00a0script\u00a0to\u00a0allow\u00a0periodic\u00a0cPanel\u00a0backups\u00a0automatically,\u00a0optionally\u00a0to\u00a0a\u00a0remote\u00a0FTP\u00a0server.
\n\/\/\u00a0This\u00a0script\u00a0contains\u00a0passwords.\u00a0KEEP\u00a0ACCESS\u00a0TO\u00a0THIS\u00a0FILE\u00a0SECURE!\u00a0(place\u00a0it\u00a0in\u00a0your\u00a0home\u00a0dir,\u00a0not\u00a0\/www\/)<\/code><\/code><\/code><\/div>\n
\/\/\u00a0*********\u00a0THE\u00a0FOLLOWING\u00a0ITEMS\u00a0NEED\u00a0TO\u00a0BE\u00a0CONFIGURED\u00a0*********\/\/\u00a0Info\u00a0required\u00a0for\u00a0cPanel\u00a0access
\n$cpuser\u00a0=\u00a0“username”;\u00a0\/\/\u00a0Username\u00a0used\u00a0to\u00a0login\u00a0to\u00a0CPanel
\n$cppass\u00a0=\u00a0“password”;\u00a0\/\/\u00a0Password\u00a0used\u00a0to\u00a0login\u00a0to\u00a0CPanel
\n$domain\u00a0=\u00a0“example.com”;\u00a0\/\/\u00a0Domain\u00a0name\u00a0where\u00a0CPanel\u00a0is\u00a0run
\n$skin\u00a0=\u00a0“paper_lantern”;\u00a0\/\/\u00a0Set\u00a0to\u00a0cPanel\u00a0skin\u00a0you\u00a0use\u00a0(script\u00a0won’t\u00a0work\u00a0if\u00a0it\u00a0doesn’t\u00a0match).\u00a0Most\u00a0people\u00a0run\u00a0the\u00a0default\u00a0x\u00a0theme\/\/\u00a0Info\u00a0required\u00a0for\u00a0FTP\u00a0host
\n$ftpuser\u00a0=\u00a0“ftpusername”;\u00a0\/\/\u00a0Username\u00a0for\u00a0FTP\u00a0account
\n$ftppass\u00a0=\u00a0“ftppassword”;\u00a0\/\/\u00a0Password\u00a0for\u00a0FTP\u00a0account
\n$ftphost\u00a0=\u00a0“ftp.example.com”;\u00a0\/\/\u00a0Full\u00a0hostname\u00a0or\u00a0IP\u00a0address\u00a0for\u00a0FTP\u00a0host
\n$ftpmode\u00a0=\u00a0“ftp”;\u00a0\/\/\u00a0FTP\u00a0mode\u00a0(“ftp”\u00a0for\u00a0active,\u00a0“passiveftp”\u00a0for\u00a0passive)\/\/\u00a0Notification\u00a0information
\n$notifyemail\u00a0=\u00a0“you@example.com”;\u00a0\/\/\u00a0Email\u00a0address\u00a0to\u00a0send\u00a0results\/\/\u00a0Secure\u00a0or\u00a0non-secure\u00a0mode
\n$secure\u00a0=\u00a00;\u00a0\/\/\u00a0Set\u00a0to\u00a01\u00a0for\u00a0SSL\u00a0(requires\u00a0SSL\u00a0support),\u00a0otherwise\u00a0will\u00a0use\u00a0standard\u00a0HTTP\/\/\u00a0Set\u00a0to\u00a01\u00a0to\u00a0have\u00a0web\u00a0page\u00a0result\u00a0appear\u00a0in\u00a0your\u00a0cron\u00a0log
\n$debug\u00a0=\u00a00;<\/p>\n

\/\/\u00a0***********\u00a0NO\u00a0CONFIGURATION\u00a0ITEMS\u00a0BELOW\u00a0THIS\u00a0LINE\u00a0*********<\/p>\n

if\u00a0($secure)\u00a0{
\n$url\u00a0=\u00a0“ssl:\/\/”.$domain;
\n$port\u00a0=\u00a02083;
\n}\u00a0else\u00a0{
\n$url\u00a0=\u00a0$domain;
\n$port\u00a0=\u00a02082;
\n}<\/p>\n

$socket\u00a0=\u00a0fsockopen($url,$port);
\nif\u00a0(!$socket)\u00a0{\u00a0echo\u00a0“Failed\u00a0to\u00a0open\u00a0socket\u00a0connection…\u00a0Bailing\u00a0out!\\n”;\u00a0exit;\u00a0}<\/p>\n

\/\/\u00a0Encode\u00a0authentication\u00a0string
\n$authstr\u00a0=\u00a0$cpuser.”:”.$cppass;
\n$pass\u00a0=\u00a0base64_encode($authstr);<\/p>\n

$params\u00a0=\u00a0“dest=$ftpmode&email=$notifyemail&server=$ftphost&user=$ftpuser&pass=$ftppass&submit=Generate\u00a0Backup”;<\/p>\n

\/\/\u00a0Make\u00a0POST\u00a0to\u00a0cPanel
\nfputs($socket,”POST\u00a0\/frontend\/”.$skin.”\/backup\/dofullbackup.html?”.$params.”\u00a0HTTP\/1.0\\r\\n”);
\nfputs($socket,”Host:\u00a0$domain\\r\\n”);
\nfputs($socket,”Authorization:\u00a0Basic\u00a0$pass\\r\\n”);
\nfputs($socket,”Connection:\u00a0Close\\r\\n”);
\nfputs($socket,”\\r\\n”);<\/p>\n

\/\/\u00a0Grab\u00a0response\u00a0even\u00a0if\u00a0we\u00a0don’t\u00a0do\u00a0anything\u00a0with\u00a0it.
\nwhile\u00a0(!feof($socket))\u00a0{
\n$response\u00a0=\u00a0fgets($socket,4096);
\nif\u00a0($debug)\u00a0echo\u00a0$response;
\n}<\/p>\n

fclose($socket);<\/p>\n

?><\/p>\n<\/div>\n<\/div>\n

To schedule the script to run regularly, save it as fullbackup.php in your top directory (not \/public_html, which would be less secure), and enter a new cron job like the following:<\/b><\/p>\n

\n
Code:<\/div>\n
15 2 * * * \/usr\/local\/bin\/php \/home\/youraccount\/fullbackup.php<\/pre>\n<\/div>\n
(Runs every night at 2:15 a.m.)<\/p>\n
or<\/p>\n
\n
Code:<\/div>\n
15 2 * * 1 \/usr\/local\/bin\/php \/home\/youraccount\/fullbackup.php<\/pre>\n<\/div>\n
(Runs every Sunday night at 2:15 a.m.)<\/p>\n
Just contact us if you want to orders a secured backup space into a backup servers.<\/a><\/b><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Automatic cPanel backup (domain & MySQL) with cron & PHP The situation is this: You use cPanel on our web hosting server. You use the cPanel backup tool to regularly backup \/home directory (includes my web files, mail, etc), and my MySQL databases. You love the fact that you can use it to backup to […]<\/p>\n","protected":false},"author":1,"featured_media":302,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,11],"tags":[],"class_list":["post-3536","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-controlpanel","category-how-to"],"_links":{"self":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/3536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/comments?post=3536"}],"version-history":[{"count":8,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/3536\/revisions"}],"predecessor-version":[{"id":3544,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/posts\/3536\/revisions\/3544"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/media\/302"}],"wp:attachment":[{"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/media?parent=3536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/categories?post=3536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/underhost.com\/blog\/wp-json\/wp\/v2\/tags?post=3536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}