MySql Backing up working database w/o password
Posted on 2011-03-22
How do I backup MySQL and restore it on another machine with the situation detailed below?
Doctor's office brings me a dead server. They were running it with:
MySQL version 12.22 Distrib 4.0.17 (i32)
Windows Server 2003 R2 SP1
CrystalPM GUI version #2.1.6 library 2.1.1
Dell PowerEdge 830
I took their raid drives and controller out of their dead PE830 and stuck it in my Dell SC1420. It boots and all seems well.
What I need to do is backup the database and get them running on some different hardware. I figure a simple mysqldump and restore ought to be the route to go. This is where I run into problems. The password they think is their database password does not seem to work. But maybe I am just doing something wrong.
I have seen several explanations on how to change the password but I am not sure if I should because of the following:
Crystal PM seems to be able to pull up data. If I do a search for Smith I get data (phone numbers address etc..) So I think the database is running. However WinMySQLadmin says that there are no databases loaded. Yet, it shows the my.ini file with the username and password that the office had written down as their login info.
So I guess more specifically I am asking, do I want to change the password, or are there other steps I should take first that are less drastic and risky?
Concerning me is that the password reset instructions I have seen all start with the mysql command and their database is running mysqld-max-nt.
I do have Administrator access to the server, am using it locally only (for now).
Have tried mysqldump commands repeatedly and I get different errors based on my format. Mostly I get:
mysql -u Administrator
error 1045 Access denied for user Adminstrator@localhost
Have tried this with their username and password and get essentially the same error.
Please help, and thank you taking the time to get this far.