OriginalSunny Posted February 26, 2006 Share Posted February 26, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3647-how-to-backup-database/ Share on other sites More sharing options...
fenway Posted February 27, 2006 Share Posted February 27, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3647-how-to-backup-database/#findComment-12680 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.