Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

How to backup database??

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.