Jump to content


Photo

How to backup database??


  • Please log in to reply
1 reply to this topic

#1 OriginalSunny

OriginalSunny
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 26 February 2006 - 10:42 PM

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 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.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

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