[SOLVED] MYSQL Database on external USB drive - needs to be dumped/res

[mcflied]

Hello Everyone,

I have a hard drive from a server that had a severe hardware failure. I have it attached via usb to the new server. I need to dump the database from the hard drive to a .sql file and then import the dump into the new server.

/mnt/external_drive/var/lib/mysql/

mysqldump -u root -p database name > backupdatabase.sql

My problem is, I enter in the root password, and it gives me an access denied error. I know this is the root password because that is how I am logged into the server.

How can I test the credentials of the database that is located on the external hard drive? And, I've used all the credentials that could open this database (database user and root user) and still no go.

If I can never get the password for the database on the external hard drive, what are my options?

Thanks for your help in advance!

-mcflied

[mcflied]

I found the solution. I did not need to do a dump. All I needed to do was to copy the files from the external hard drive and THEN I needed to run this command on the DB dir:

chmod -R 775 database_dir/

Once I did that, the tables did show up in PHPmyadmin.

Before running chmod, I could see all the tables in the database copied over, but could not view them in PHPmyadmin.

Hope this helps someone else besides me.

-mcflied