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. 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. Link to comment https://forums.phpfreaks.com/topic/3647-how-to-backup-database/#findComment-12680 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.