Databse problems

**Derision** · #2 10-04-2008, 04:08 PM

On my Vista x64 box, MySQL databases are stored under:

Code:

C:\Program Files (x86)\MySQL\MySQL Server 5.0\data

E.g. I have a database called ykesha, and have various .frm/.MYD/.MYI files under

Code:

C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\ykesha

I don't know if this will work (you should really transfer databases using mysqldump to a .sql file), but you could try and find where the MySQL databases are stored on your system, then create a directory and drop the .frm/.MYD/.MYI files in there.

E.g. using the paths on my system, I would try creating a directory:

Code:

C:\Program Files (x86)\MySQL\MySQL Server 5.0\data\eqdb

and dropping the files you have been given in there. You could then check if they are accessible by going into the MySQL command prompt and doing:

Code:

use eqdb;
show tables;

Just a guess, no idea if this will work.