Db transfer question.

[sarah31]

Heya,

Recently I had my home computer/server crap out on me and I had to go out and purchase a new one. Unfortunately I had one small database set up that was being used for one of my image display galleries.

I pulled the hard drive out of that old computer and placed it in an external enclosure so I do have access to all of the data on the drive. So what I would like to be able to do is be able to grab the old MySQL database that held the gallery info onto my new drive and use it on the new computer.

I am not sure quite how to do this though and I was not able to glean enough info from the MySQL documentation. I was hoping someone here would be able to help me out so I will not have to set this gallery up again from scratch (it woud take about a full day)

[sde]

hi sarah,

usually mysql files are stored in /var/lib/mysql. the database will be a directory with the same name as the db. inside the directory you should see table names with extensions like MYD, MYI, and frm.

once you've located the db directory on the backup drive, copy it over to the mysql directory on your new drive.

once that is done, you should be able to login to mysql as root and grant permissions to that database for the user/pass specified in your gallery scripts.

[sarah31]

Cool! Sounds easy enough. Thanks very much!