I am trying to get Mysqldump to work on a Mysql database for a new customer I have inherited. I am not too familiar with MySQL, but I do know their whole organization hinges on this one database and it is not gettting backed up. It is running in a Windows 2000 Server environment.
From the c:\mysql\bin fold I ran the following command:
When I was prompted for the password I entered the password from the Navicat 'Manage Users' where the access for all the users is defined.
I get returned the following error:
mysqldump: Got error: 1045: Access denied for user: '2005golfit@localhost@localhost' (Using password: YES) when trying to connect
Would the configuration file have the right user / password for this command and where would I find the config file?
Can I use Mysqldump while the mysql-max-nt service is still running?
One other question that might me related to this error, can I get mysqldump to work in I come in remotely to Windows 2000 Server using Terminal Server? It just occured to me that when I start a second session on Windows 2000 Server, that does not mean another instance of mysql-max-nt starts, correct?