Skip navigation links

MySQL Forums :: Newbie :: Physical Location of mysql data under linux.


Advanced Search

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?

Options: ReplyQuote


Subject Written By Posted
Physical Location of mysql data under linux. Gavin Coates 12/21/2008 12:23PM
Re: Physical Location of mysql data under linux. Hakan Kuecuekyilmaz 12/21/2008 03:10PM
Re: Physical Location of mysql data under linux. Gavin Coates 12/22/2008 04:48AM
Re: Physical Location of mysql data under linux. Rick James 12/22/2008 10:02PM


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.