I migrated my wordpress sites to another host. I am running CentOS 6.4 Linux on the new site and Fedora 17 on the original site. I have migrated using this sequence before and it has worked fine.
I copied the contents of the /var/lib/mysql directory to the new host and the httpd.conf file. I created the new password on the new host and logged in. I can see the databases and tables. I have a combination of sites using one database and some sites each using separate databases. The two that use the common database ,"wordpress", are not working. I get a failure to connect to database. The other sites are working fine.
I went to the wp-admin page for one web site and it showed that the database needed repaired. I pressed the "Repair" button and got a number of errors. I did the Database rebuild commands in the MySQL database. Now I get a blank page when going to the content, but I go to the dashboard when going to wp-admin.
I have restored from multiple backups and get the same results. The primary unresolved problems seems to be that some database tables had multiple users and that they were closed (crashed) while in use.
Please can you help!!
Fortunately, I can redirect the incoming requests back to my original server using DNAT in my firewall and all of my web sites work fine.