I'm transferring a bunch of domains a new host. The site names remain the same, and for the sites I've already migrated, no manipulation was necessary in the database. It just works once name-servers are pointed at the new box. That's great.
For some sites, however, during import, mysql throws this error:
Operation not allowed when innodb_forced_recovery > 0
This is true whether I'm importing the sql from commandline, phpMyAdmin or cpanel import. (Well, cpanel import isn't really that communicative about errors.)
I've got a lot of sites to transfer. It doesn't happen with all databases.
This is my set up on the existing host: Apache 2.2.29 - PHP: 5.3.16 - MySQL: 5.6.23
This is my setup on the new host: Apache 2.2.29 - PHP: 5.3.29 - MySQL: 5.6.23
The data work fine in their current hosts. They don't always import well into the new host. I've tried optimizing and repairing tables, but some tables won't repair or optimize. It's usually these databases with these kinds of tables that cause problems.
I can export a database easily. And nothing looks odd in the sql. It's only when I get to the import side that I start seeing the above error.
What is causing this, and what is a best practice for transferring data that doesn't want to import because of this error?