Hello,
Can any one help me with this problem?
I am trying to backup my MySQL database from php script using mysqldump. The script is:
<?php
$host = "hostname";
$database = "databasename";
$user = "username";
$pass = "password";
$dbh = mysql_connect($host, $user, $pass) or die ("Can't connect to MySQL");
mysql_select_db($database) or die ("Can't connect to db");
$bckp_file = $database.date("Y-m-d-H-i-s").".sql";
$command = "c/wamp/mysql/bin/mysqldump --add-drop-table --add-drop-database -u $user -p $pass $database > $bckp_file";
system ($command);
?>
In result I am getting only empty .sql files, without any content
when I run command "mysqldump --add-drop-table --add-drop-database -u $user -p $database > $bckp_file" from cmd its ok, i have the normal dump.
Can any tell me what's wrong with my php script?
backup MySQL database from php script
Moderator: General Moderators
- slightlymore
- Forum Newbie
- Posts: 9
- Joined: Sun May 18, 2008 5:24 pm
- Location: Oxford, England
Re: backup MySQL database from php script
try putting a colon after c, so it reads: "c:/wamp/mysql/......"