Latest developments:
I tried to do a full cpanel backup, but I got this error:
Code:
Then I re-enabled InnoDB and did the backup again. The result was successful:
But the successful backup crashed the mysql server and then corrupted the database:
So I had to repair it.
I'm thinking the best thing to do is return to a stock mysql database from Percona. What would this involve?
I tried to do a full cpanel backup, but I got this error:
Code:
Code:
Determining mysql dbs...DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 200.
DBD::mysql::db selectall_arrayref failed: Unknown storage engine 'InnoDB' at /usr/local/cpanel/bin/cpmysqladmin line 200.
...mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
Quote:Quote:
Determining mysql dbs...Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
...mysql version: 5.5......mysqldump version: 5.5...Saving mysql privs...Done
But the successful backup crashed the mysql server and then corrupted the database:
Quote:Quote:
130921 5:54:36 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130921 5:54:36 InnoDB: Database was not shut down normally!
So I had to repair it.
I'm thinking the best thing to do is return to a stock mysql database from Percona. What would this involve?
Roosh
http://www.rooshv.com