Backup MySQL DB of Your WordPress Blog Website on Amazon AWS S3 [PHP]

By Haktan Suren
In Blog
Apr 13th, 2014
0 Comments
6878 Views

Losing data sucks! This is the way you can automatically backup your MySQL database on Amazon AWS S3 any given time interval (Cronjob). This script uses the S3 library on Github. Main beauty of this function, it creates chronological folders on S3. So you can easily go through your MySQL database backups. I have used .gz extension to save some space but you are welcome to edit it to save as .sql as well. I believe this will be a complete life saver for most of the people. Please let me know, if you develop further, or if you have any question about the script.

Your comments ?


include('../wp-load.php');

BackupDBOnS3("YourSiteDb-Backup/DB/".date('Y')."/".date('m')."/".date('d'));

function BackupDBOnS3 ($bucketName){

 $user = DB_USER;
 $pass = DB_PASSWORD;
 $host = DB_HOST;
 $db = DB_NAME;

 $current_time = date('H.i.s', time());
 $file_name = "$db-$current_time.sql.gz";

 $upload_dir = wp_upload_dir();
 $output_file_path = $upload_dir['path']."/".$file_name;

 $output = `mysqldump --user={$user} --password={$pass} --host={$host} {$db} | gzip > {$output_file_path}`;

 if (!class_exists('S3')) require_once get_template_directory().'/S3.php';

 // AWS access info
 if (!defined('awsAccessKey')) define('awsAccessKey', 'PutYourAWSAccessKeyHere');
 if (!defined('awsSecretKey')) define('awsSecretKey', 'PutYourAWSSecretKeyHere');

 // Instantiate the class
 $s3 = new S3(awsAccessKey, awsSecretKey);

 if ($s3->putObjectFile($output_file_path, $bucketName, $file_name, S3::ACL_PRIVATE)) {
 print "$file_name : Sucessful!<br>";
 }
 else{
 echo "$file_name : Failed to copy file<br>";
 }

 unlink($output_file_path);

}

About the Author

Haktan Suren
- Webguru, Programmer, Web developer, Graduate student & Father :)

Wrap your code in <code class="{language}"></code> tags to embed!

Leave a Reply

E-mail address is required for commenting. However, it won't be visible to other users.

Loading Facebook Comments ...
Loading Disqus Comments ...