Earleir I had XAMPP 1.7.x installed and working properly and whenever I had to migrate the mysql data for user created tables, I just had to copy respective database folder and it used to work fine. Later I installed v 1.8.1 on that system and copied user created table from mysql/data/folder of 1.7.x to 1.8.1 installation, some databases has few or all tables missing from them. I then re-created those missing tables and continued working.
Then after few days, I needed to migrate data from above XAMPP 1.8.1 installation from that old system to a new system having same XAMPP 1.8.1 version.
After installing XAMPP 1.8.1 on new system, I copied only user created tables from /xampp/mysql/data folder from old system to the new installation. When I opened phpMyAdmin, I saw those user created databases but I noticed that some databases have all or few tables missing from them. This was not supposed to happen as mysql data tables were copied from functional 1.8.1 to the same 1.8.1 version. Again, these missing tables were those which were created on old system using XAMPP 1.8.1 and all those tables were showing properly when created using XAMPP 1.7.x
Further digging revealed that when we were working on 1.7.x , all the tables created also had .MYD and .MYI files also along with .frm and copying mysql data folder for user created databases used to work just fine but since XAMPP 1.8.1 tables are created but no associated .MYD & .MYI are created - only .frm
When a table is created using phpMyAdmin in XAMPP 1.8.1, this also does not create any .MYD or .MYI files, just .frm
So what does this means? That,
- in XAMPP 1.8.1, only .frm file is created for the table and no .MYD or .MYI files are created ?
- copying user created databases (.frm) between two different 1.8.1 versions will not work at all ?
Please help me on the above to show up user created tables in database in 1.8.1 copied from another 1.8.1 installation.