[RESOLVED] MySQL Data files

[durahman]

Currently I developed a PHP/MySQL/Apache application using Windows based PC. Everything works fine.

I wanted to transfer the said application to a Linux server. I was told to copy my database's xxxx.frm, xxxx.MYD and xxxx.MYI files.

Problem is when I check my database folder (windows):

C:\Program Files\MySQL\MySQL Server 5.0\data\dbmydatabase

I can only see the xxxx.frm files.

Can anyone tell me where are the xxxx.MYD and xxxx/MYI files?

[MarkR]

This is not the right way to transfer the database. Use mysqldump to dump it into a backup file, then restore it with the mysql tool.

Maybe you used a table handler other than MyISAM, in which case the data will be somewhere else (e.g. InnoDB and BDB store their stuff elsewhere).

In any case, this is not the right way to do it.

Mark

[durahman]

I am just wondering where the files are.

I had searched the files using windows explorer but the files just do not exist.

BTW I had use phpMyAdmin to backup and restore the database also to transfer to the database to my laptop. It works fine. I hope this is the correct way other than mysqldump.

Thaks.

[tsinka]

Hi,

looks like you're using InnoDB tables. In that case only the .frm file gets written to the directory. The other data gets written to a common data file named ibdata1 (default setup) in the data directory.

Thomas