How to backup database??

[OriginalSunny]

Hi,

i have tried everything to backup my database in mysql and nothing seems to work. I keep getting the error message "error 1064 (42000)".

here are some of the commands i have tried:

mysqldump -u [i]username[/i] -p [i]password[/i] [i]databasename [/i]> filename.sql;

mysqldump.exe [i]databasename[/i] > filename.txt;

Just where am i going wrong and how do i back up my database?? Some1 please help as i need to have it backed up urgently.

[fenway]

The first line should work just fine; but try adding the --quote-names command-line parameter to ensure that everything "important" (e.g. field names) are backticks just in case.