put the exec(...) line OUTSIDE the while loop.As your codeis now, it's
dumping with each new row , so i'ts overwriting itself.
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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
