Backup all MySQL databases automagicly with the PHP admin script

Server administration software like Cpanel, Plesl, Webmin etc have already their backup solutions. But they are runned mostly once a week or max a day because of performance reasons. Let say we just want to backup all of our mysql-databases every 2 hours.

To do this:

  • Create a directory like /backup/mysql
  • Save code below under something like backup_mysql.php
  • Chmod it to 755
  • Run it manually or with cronjobs /root/scripts/backup_mysql.php
#!/usr/bin/php
<?php
// use this if your php.ini does not allow shell etc #!/usr/bin/php -n

$mysql_root_pwd = "YOUR-MYSQL-ROOT-PASSWORD";

function formattime() { return date("Y-m-d H:i:s"); }

echo "Starttime: ". formattime();

mysql_connect("localhost","root","$mysql_root_pwd");
$r = mysql_query("show databases");

while( $arr = mysql_fetch_array($r) ){
	$db = $arr[0];
	echo "\n\nExporting $db\n" . formattime() . "\n";
	 
	echo shell_exec("/usr/bin/mysqldump  -u root --password='$mysql_root_pwd' $db > /backup/mysql/".$db.".sql");
}

echo "\n\nEndtime: ". formattime() . "\n\n";

echo mysql_error();
mysql_close();

Kommentare

Neuen Kommentar schreiben

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <b> <pre> <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <div> <style><img> <br> <blockquote>
  • Lines and paragraphs break automatically.
  • You may insert videos with [video:URL]

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

CafeWebmaster.com(CW) is a free online community for webdevelopers and beginners. Anybody can share their code, articles, tips, tutorials, code-examples or other webdesign related material on the site. Newbies can submit their questions and reply to existing questions. CW does not guarantee or warrant reliability of code, data and information published on the site. Use the site on your own risk. The site takes no responsibility of direct or indirect loss or any kind of harm to its users. The site also doesn't take responsibility of infected files or source code with any kind of infection or viruses, worms, spywares, malwares, trojan horses. CW reserves the right to edit, move, or delete any of content for any reason.