Questions about MySQL Database migration

A few days ago because of the installation of lamp problem, and then want to reinstall Lamp, the results do not know why, but appeared/usr/bin/dpkg return an errror (100), so I put the kpkg to unload, and the result this unloading is very, The original dpkg is all the installation of Linux to go through a step, it is a foundation,, not all of its installation can not be installed, unless you install the source package. Anyway, I was not done, and then the result is the re-installation system ...

Reinstall the system, after the problem came,, lamp because of the problem, and then reinstall the system, and then do not want to install lamp,, and then find the same, and I think he is more useful than lamp, that is xampp ... After installation, it is to transfer the website source code and database ...

But after the transfer some data tables do not exist, this can really scare me, because the data is very important, so like all kinds of methods, and then understand ... The original tables when the engine is selected InnoDB, so it will not generate myi and myd table, will only generate the frm suffix file,, so in the transfer of the database only the frm file transfer past is far from enough ... Also need to transfer (Ibdata) (IB_LOGFILE0) (ib_logfile1) These three files to the database directory, which you will find these tables are still not used,, so the last step is to restart MySQL ....

Ha ha... Finally ended, and this is what you will find all the data intact, isn't it great AH!!!

Questions about MySQL Database migration