[PHP] MySQL Table backup
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
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 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? 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 -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Table backup
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 getting? HTH Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Table backup
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, 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 news:[EMAIL PROTECTED] 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? 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 -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description: This is a digitally signed message part
Re: [PHP] MySQL Table backup
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, in which case you have too many parameters. Adam's reply implied removing both. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Table backup
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 '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, in which case you have too many parameters. Adam's reply implied removing both. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc signature.asc Description: This is a digitally signed message part