sql statement not working

[stasJohn]

I have a php script. I'm trying to set it up so it backs up a database table to the server.

in the php, I call...

SELECT * INTO OUTFILE '".$bck_dir."/mdb-backup.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' FROM members

I get the following error...
1064: You have an error in your SQL syntax near '' FROM members' at line 2


If I run the sql statement in MySQL CC on my linux box it works fine! Help anyone.

mysql and php are on a linux box. Regular Select statements work fine.

 

[stasJohn]

I don't know if this means anything, but I noticed the

LINES TERMINATED BY '\r\n'

was not escaped properly.
So modified the statement to...

SELECT * INTO OUTFILE '".$bck_dir."/mdb-backup.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\\r\\n' FROM members

which know yields the error...
1064: You have an error in your SQL syntax near '\r\n' FROM members' at line 1


please help!

 

[netcomander]

hi,

I wonder why you don't use mysqldump

http://www.mysql.de/doc/en/mysqldump.html

 

[stasJohn]

mysqldump is a system command. How do I invoke it within a php script??

 

[TonyGroves]

Try:
[tt]
$sql=
"SELECT * ".
"INTO OUTFILE '".$bck_dir."/mdb-backup.csv'".
" FIELDS TERMINATED BY ','".
" OPTIONALLY ENCLOSED BY '\"'".
" ESCAPED BY '\\\\'".
" LINES TERMINATED BY '\\r\\n' ".
"FROM members";
[/tt]

-----
ALTER world DROP injustice, ADD peace;