I wrote a PHP tool a while back that allows us to automatically setup free MySQL Databases for our customers in an internal standalone installation. It works fine but we recently were forced to migrate the databases due to hardware failure.
After doing so, the existing MySQL databases seem to have some type of ghost data in them. We cannot see these tables in PHPMyAdmin but it is detected by our customer's plugins and some of our own tools.
I have never heard of MySQL Ghost Data like this before and was wondering if anyone has any idea where this comes from or how to fix it?
Ghost Data.. interesting! I am not sure, but I think you are talking about INFORMATION_SCHEMA, which provide access to database metadata. Check This
And, wherever you migrate to, most of the databases have these metadata-tables. Ex: SQL SERVER has sysobjects or sysusers tables and many more...