Re: botched data post-upgrade

[Peter Brawley]

You're learning painfully what the manual says, that file copy is an unsound method of moving data between versions. The sound method is to mysqldump the data, install the next major version, import the dump, regression-test till all issues are resolved, then repeat the sequence for the next version---till you arrive at the desired version. In your case, that'd be two moves: 5.1->5.5, then 5.5->5.6.

So I think what you need to do now to recreate functioning databases depends on whether you have a full backup of the 5.1.59 data, and if so, whether it's just a file copy backup, or a proper mysqldump.