4images code on GitHub Click here to visit GitHub.
0 Members and 1 Guest are viewing this topic.
Code: [Select]<?php$host = "XXXXXXXX";$db = "XXXXXXXX";$dbuser = "XXXXXXXX";$dbpw = "XXXXXXXX";MYSQL_CONNECT($host, $dbuser, $dbpw) or die ( "<H3>Datenbankserver nicht erreichbar</H3>");MYSQL_SELECT_DB($db) or die ( "<H3>Datenbank nicht vorhanden</H3>");$path = getenv('DOCUMENT_ROOT')."/DB_backup";$result = MYSQL_QUERY("SHOW TABLES");$numrow = MYSQL_NUM_ROWS($result);for($i = 0;$i < $numrow;$i++) { $date = date("D"); $table = MYSQL_RESULT($result,$i); echo "$date.$table ... "; system(sprintf("mysqldump --opt -h $host -u $dbuser -p$dbpw $db $table | gzip > %s/$date.$table.sql.gz",$path)); echo "DONE <br><br>";}MYSQL_CLOSE();?>You can use this PHP Script to make a Backup from the DB with a Cronjob... (o:
<?php$host = "XXXXXXXX";$db = "XXXXXXXX";$dbuser = "XXXXXXXX";$dbpw = "XXXXXXXX";MYSQL_CONNECT($host, $dbuser, $dbpw) or die ( "<H3>Datenbankserver nicht erreichbar</H3>");MYSQL_SELECT_DB($db) or die ( "<H3>Datenbank nicht vorhanden</H3>");$path = getenv('DOCUMENT_ROOT')."/DB_backup";$result = MYSQL_QUERY("SHOW TABLES");$numrow = MYSQL_NUM_ROWS($result);for($i = 0;$i < $numrow;$i++) { $date = date("D"); $table = MYSQL_RESULT($result,$i); echo "$date.$table ... "; system(sprintf("mysqldump --opt -h $host -u $dbuser -p$dbpw $db $table | gzip > %s/$date.$table.sql.gz",$path)); echo "DONE <br><br>";}MYSQL_CLOSE();?>