If you don’t want this problem to happen again, you make sure when backing up your schema’s that to check the wp_usermeta is included as it may not, or else you will eb forced to do a cleared install each time you want to redo the project.
What the problem is that WordPress sets up _base_ structure when first installing. Without doing a install.php you wont create these base files.
So empty you database in mysql, then create a black one of the same name and install.php. Then write back you main data base so it goes over the top then recove your admin password if different.
Thanks Solerunner. I had same problems. I should say if it ain’t broke, don’t fix it but I can’t help upgrading to latest versions of software.
It looks like wordpress needs a new release to get around this new MySQL5 problem.
http://druidictus.homeip.net/blog/
