Following on from our previous post (https://www.linuxtutorial.co.uk/cpanel-mysql-backup-script/) there is another script for the full backup of CPanel web directories.

The original post is taken from http://r00t3r.com/cpanel-full-backup-cron-script-for-automated-backups/ which contains a link to download the PHP files.

The main file to worry about is the config.php which contains a cpanel section:

// CPANEL ACCOUNT TO BACKUP
define( 'CPANEL_SERVER_ADDRESS',		'abc.def.ghj.mnp' );	// IP address or domain name for the server with the cPanel account
define( 'CPANEL_PORT_NUM',				'2083' );	// The port number for the cPanel. If you have problems, try 2082
define( 'CPANEL_ADMIN_USERNAME',		'admin-username' );	// the admin username for your cPanel account
define( 'CPANEL_ADMIN_PASSWORD',		'veryStrongPassword' ); // the admin password for your cPanel account

and the FTP server section:

define( 'FTP_SERVER_ADDRESS',			'npq.rst.uvw.xyz' );     // IP address or URL of the FTP server
define( 'FTP_SERVER_PORT',			'21' );			 // FTP(S) Port. Default is 21.
define( 'FTP_USERNAME',				'ftp-username' );	 // FTP Username
define( 'FTP_PASSWORD',				'ftp-password' );	 // FTP Password
define( 'FTP_PATH_TO_COPY',			'/ftp/path/to/copy/' );	 // FTP Path (where do you want to copy the files?)

Simply enter in your CPanel and FTP server account details to this PHP script.

Once in place setup the cron job to run on a regular basis e.g.

1 1 * * * php -q /home/user/path_to_phpscript/cpanelbackup.php

Simple PHP MySQL backup script for CPanel. Create a php file and insert the following code:

<?
$datestamp = date("Y-m-d");// Current date to append to filename of backup file in format of YYYY-MM-DD

/* CONFIGURE THE FOLLOWING THREE VARIABLES TO MATCH YOUR SETUP */
$dbuser = "username";// Database username
$dbpwd = "password";// Database password
$dbname = "database";// Database name. Use --all-databases if you have more than one
$filename= "backup-$datestamp.sql.gz";// The name (and optionally path) of the dump file

$command = "mysqldump -u $dbuser --password=$dbpwd $dbname | gzip > $filename";
$result = passthru($command);

/* CONFIGURE THE FOLLOWING FOUR VARIABLES TO MATCH YOUR FTP SETUP */
$ftp_server = "hostname";// Shouldn't have any trailing slashes and shouldn't be prefixed with ftp://
$ftp_port = "21";// FTP port - blank defaults to port 21
$ftp_username = "username";// FTP account username
$ftp_password = "password";// FTP account password - blank for anonymous

// set up basic connection
$ftp_conn = ftp_connect($ftp_server);

// Turn PASV mode on or off
ftp_pasv($ftp_conn, false);

// login with username and password
$login_result = ftp_login($ftp_conn, $ftp_username, $ftp_password);

// check connection
if ((!$ftp_conn) || (!$login_result))
{
echo "FTP connection has failed.";
echo "Attempted to connect to $ftp_server for user $ftp_username";
exit;
}
else
{
echo "Connected to $ftp_server, for user $ftp_username";
}

// upload the file
$upload = ftp_put($ftp_conn, $filename, $filename, FTP_BINARY);

// check upload status
if (!$upload)
{
echo "FTP upload has failed.";
}
else
{
echo "Uploaded $filename to $ftp_server.";
}

// close the FTP stream
ftp_close($ftp_conn);

unlink($filename);   //delete the backup file from the server
?>

Now add a cron job to trigger the backup script when required:

1 1 * * * php -q /home/user/path_to_phpscript/sqlbackup.php

The above code will trigger the backup to run at 1:01 a every day of the year.

Use a cron calculator to sepcify the time and days you would like your cron to run: http://www.csgnetwork.com/crongen.html

Following on from the ISPConfig3 running on nginx tutorial I then came to installing a WordPress site within ISPConfig. Piece of cake, right?

So I went about the usual process of setting up a new site and database within the ISPConfig interface. Then I grabbed the latest WordPress (wget http://wordpress.org/latest.tar.gz), placing it in the correct location inside the “web” directory for this particular site. Ownership/permissions were then updated – everything as per normal in this environment.

I then enter the URL into my browser and low and behold the WordPress home page appeared. Great! Until I browsed to any other page within the test site:

ERROR 404 – Not Found!

From a considerable bit of Googling I found the following piece of code needs to be appended to your nginx Directives (ISPConfig > Website > Options)

location / {
try_files $uri $uri/ /index.php?$args;
}

Restarted nginx and we’re back in business. All pages loading as they should.