MySQL Forums :: Newbie :: Physical Location of mysql data under linux.
Physical Location of mysql data under linux.
Posted by: Gavin Coates
Date: December 21, 2008 12:23PM
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?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.