PHP Backup script fails
Posted: 25. September 2010 21:30Hi,
I have the following PHP code which works as expected on a Linux system with Apache, PHP and MySql installed, but fails on Windows XAMPP.
This works fine on my Linux system, but XAMPP simply creates a zero length file c:/rdg/home/backupdb/mybackup.sql
Any help will be greatly appreciated.
I have the following PHP code which works as expected on a Linux system with Apache, PHP and MySql installed, but fails on Windows XAMPP.
- Code: Select all
<?php
// turn on error reporting
error_reporting(-1);
ini_set('display_errors', true);
// Parameters for BINGO database
$username="user";
$password="password";
$hostname="localhost";
$dbname="bingodata";
// Backup file location
$tmpdir="/home/rdg/backupdb/";
// backup file name will be /home/rdg/backupdb/mybackup.sql
$dbh = mysql_connect($hostname, $username, $password)
or die("Connection to MSQL failed!");
$selected = mysql_select_db($dbname, $dbh)
or die("Could not access $dbname database:" . mysql_error() );
// Connection to database is established at this point;
$prefix = "db_";
$sqlFile = $tmpDir."mybackup.sql";
$creatBackup = "mysqldump -u ".$user." --password=".$password." ".$dbName." > ".$sqlFile;
echo "<html><title>Backup Bingo Database</title><body>";
echo "<center>";
echo "Bingo Reporting System<p>";
echo "Backup Bingo Database<p>";
echo exec($creatBackup)."<p>";
echo "Backup created "<p>";
?>
</body></html>
This works fine on my Linux system, but XAMPP simply creates a zero length file c:/rdg/home/backupdb/mybackup.sql
Any help will be greatly appreciated.
