[PHP] dumping mysql database with php script

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: localhostDatabase: testdata1

Re: [PHP] dumping mysql database with php script

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

Re[2]: [PHP] dumping mysql database with php script

Hello Petre, There is more than one database to back up so every time it runs through the while loop it is suppose to back up the next database and it changes the name of the text file it is sending it to. I have already tried just doing one database without the while loop and I get the same

Re[2]: [PHP] dumping mysql database with php script

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

[PHP] dumping mysql database with php script

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: localhostDatabase: testdata1