my OS died today, so I have to copy the data onto working machine. I've set up the new environment including MySQL, then copied contents of
/var/lib/mysql from an old machine to the new one. Unfortunately, while looking at the results I have noticed that some (yes, only some) databases are completely empty - while the others survived untouched.
The only thing connecting those databases with "lost" tables and records, is the fact they were all created recently, comparing to the survived ones. [by recently I mean half a year or so]
My question is quite obvious now - how should I restore the data correctly?
Thanks in advance