MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
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.