Re: [PHP] MySQL Table backup

2002-12-09 Thread Adam Voigt
Quote: It sounds like you are not running it from the command prompt but from within mysql. Reponse: I suspect as much. On Mon, 2002-12-09 at 11:15, Chris Hewitt wrote: Shaun wrote: >ERROR 1064: You have an error in your SQL syntax near

Re: [PHP] MySQL Table backup

2002-12-09 Thread Chris Hewitt
Shaun wrote: ERROR 1064: You have an error in your SQL syntax near 'mysqldump -h localhost -u xxx -p xxx backup.sql' at line 1 It sounds like you are not running it from the command prompt but from within mysql. Unless the omission of the redirection sign ">" but not "backup.sql" was intentio

Re: [PHP] MySQL Table backup

2002-12-09 Thread Adam Voigt
Your not trying to run that from within MySQL are you? You do know that mysqldump is an entirely seperate command then the mysql console (where you would for instance type, USE DB; SELECT blah FROM table) right? On Mon, 2002-12-09 at 10:26, Shaun wrote: thanks for the reply,

Re: [PHP] MySQL Table backup

2002-12-09 Thread Chris Hewitt
Shaun wrote: I am trying to backup my database can someone please tell me why the following commande wont work? mysqldump -h localhost -u username -p databasename > backup.sql Changing "username" and "databasename" to valid values on my database, I get this line to work here. What error are y

Re: [PHP] MySQL Table backup

2002-12-09 Thread Shaun
thanks for the reply, but that didn't help ERROR 1064: You have an error in your SQL syntax near 'mysqldump -h localhost -u xxx -p xxx backup.sql' at line 1 any ideas? "Adam Voigt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Take off the " > backup.sql" and

Re: [PHP] MySQL Table backup

2002-12-09 Thread Adam Voigt
Take off the " > backup.sql" and see if you get any error's that might explain it. On Mon, 2002-12-09 at 10:07, Shaun wrote: Hi, I am trying to backup my database can someone please tell me why the following commande wont work?

[PHP] MySQL Table backup

2002-12-09 Thread Shaun
Hi, I am trying to backup my database can someone please tell me why the following commande wont work? mysqldump -h localhost -u username -p databasename > backup.sql thanks for your help -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php