Physical Location of mysql data under linux.

[Gavin Coates]

I currently have a Fedora Core 5 virtual machine running mysql as part of an internal website, however the physical machine suffered a hardware failure, which resulted in the virtual image becoming corrupt and is no longer bootable.

I can access the virtual hard disk and browse the filesystem. Is there a physical file containing the data for the sql server, that could be copied over to another machine?

Within /var/lib/mysql I found a folder named after the database, whih contains a series of .frm files for each table, however the filesize is only about 8k, and copying these over to another server doesnt cause a change in data - I am assuming these just contain the structure of the table?

Where is the actual data stored, and can it just be copied over to the other machine?