I'm trying to create a dump of a locally installed MySQL database on my laptop.
I am aware of the command:
%>mysqldump -u root -p --opt [database name]
but I am not able to execute it. I might be missing the obvious here.
- I open command line manager, which prompts the root password.
- Once I enter the password, I get straight into
- I am not able to exit the
mysql>to get back into the shell.
Above command entered:
mysql> mysqldump -u -root -p --opt [database]
gives me the following:
I have also tried the following:
C:\> cd c:\program files\mysql\...\bin C:\program files\mysql\...\bin> mysqldump -u root -p [database name] > dump.sql
Which only then reports back "Access denied".
I am not prompted the password. User is 'root'. I have full admin rights under Windows. I have tried this on two laptops with different DBs and passwords with the same result. I installed the MySQL database using the wizard.
I am lost. It seems I can only log straight into the database, but am not able to get into the shell (
shell> ). Am I wrong just using the command line manager? Do I need workbench or something else?