I am using mysqldump to take backup of my database, but the command is not working..
the command i am using is mysqldump -u root dbname> 'c:\backupdatafolder\backup.sql'
i am running this command in MySQL cli but not running,..is there any thing wrong in the command?
views:
53answers:
1
+1
A:
You are supposed to run that on the command line of your operating system not on the MySQL CLI.
Bakkal
2010-06-05 06:53:41
hey! @Bakkal but then also not working, giving the error "mysqldump is not recognized ..."
Harish Kurup
2010-06-05 06:57:00
`cd` to the bin folder of MySQL first, something like `C:\mysql\bin` I think.
Bakkal
2010-06-05 06:59:50
hey thanks @Bakkal, just forgot to set the class path...it worked, previously i was just running the command in MySQL CLI...Thanks a lot..
Harish Kurup
2010-06-05 07:02:22
You're welcome :)
Bakkal
2010-06-05 07:08:08