I figured it out it was a permission problem with database username and
password
Monday, September 02, 2002, 12:51:12 AM, you wrote:
PA> put the exec(...) line OUTSIDE the while loop.As your codeis now, it's
PA> dumping with each new row , so i'ts overwriting itself.
PA> On Mon, 2002-09-02 at 09:47, [EMAIL PROTECTED] wrote:
>>
>> 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
>>
>> 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
>>
--
Best regards,
rdkurth mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php