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 username -p password databasename > filename.sql;
mysqldump.exe databasename > 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.
How to backup database??
1 reply to this topic
Posted 27 February 2006 - 06:59 AM
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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users