[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

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 see

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 you

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: 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 intentional,

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