It appears that httpd has a lot of running processes and when I try to kill them I am unable to. THis is causing the server to sloooow way down. There are also error messages from mysqld with a corrupt table:
1 131103 12:18:30 [ERROR] /usr/libexec/mysqld: Table './wordpress_2/wp_comments' is marked as crashed and should be repaired
1 [root@u15893654 ~]# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A > dumpall.sql
But that gave me the same error:
1 mysqldump: Got error: 145: Table './wordpress_2/wp_comments' is marked as crashed and should be repaired when using LOCK TABLES
A quick Google search and I found the “fix” for this is to run a repair on the tables: http://www.
That fixed the issue, and I was able to create the “dumpall.sql”.
Once I had ALL of the tables fixed, I simply rebuilt the server and migrated it into a new database as described in the Parallels KB article mentioned above (a lot more steps to make sure the backup was good, but once it was the newly imaged server was able to run without incident).