Re: Physical Location of mysql data under linux.
Posted by:
Rick James
Date: December 22, 2008 10:02PM
1. Stop mysql (do not "kill" it).
2. Copy all files under .../mysql/
3. Create a similar my.cnf (my.ini) file on target machine. Several values there must be identical.
4. start mysql on target machine.
Look at the mysqld.err file on both machines to find other messages.
If you are using Windows, be sure you don't do some kind of copy that turns LF into CRLF.
.frm files contain meta information about tables. Since you did not mention other files, the you are probably running InnoDB. As Gavin mentioned, the data for InnoDB tables in ibdata (ibdata1, etc). After a clean shutdown, the iblog files are not critical.
Subject
Written By
Posted
December 21, 2008 12:23PM
December 21, 2008 03:10PM
December 22, 2008 04:48AM
Re: Physical Location of mysql data under linux.
December 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.