I am having a problem with a script to dump a mysql database to a text
file. When I run the command below it creates the database.sql file but
it only puts the first three lines in that file they look like this
# MySQL dump 8.13
#
# Host: localhost Database: testdata1
#--------------------------------------------------------
# Server version 3.23.37
If I run the following at the command line it work perfect passing the whole
database to the txt file
/usr/bin/mysqldump -u testdata1 -ptestdata1 testdata1
> /home/sites/www.directphp.net/sitebackup/databases/testdata1.sql
Why is it stopping on the third line when I run it with a PHP script
This is my script
$sql="Select * from datba where domname = '$domname'";
$results=safe_query($sql);
while($row = mysql_fetch_array($result)){
$databasename=$row["databasename"];
$databaseusername=$row["$databaseusername"];
$databasepassword=$row["$databasepassword"];
exec("/usr/bin/mysqldump -u $databaseusername -p$databasepassword $databasename >
$Databasesdir/$databasename.sql");
}
--
Best regards,
rdkurth mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
