Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]

Commenting out the line 

innodb_force_recovery = 1

in /etc/my.cnf thus:

# innodb_force_recovery = 1

made the mysql innodb tables in the database accessible. Apparently this setting causes innodb to become read-only. I hope this helps someone in the future. If you don’t have access to /etc/my.cnf on shared hosting, ask your host to fix it for you. When it’s commented out or non-existent in /etc/my.cnf, the it reverts to a default setting of 0.

For future reference, I hope this will help someone else who is using wordpress plugins that require innodb flavored tables. I know there was some concern that this may not have been the appropriate place for this question, but I suspect as more plugins and perhaps even WP starts using InnoDB, others may be glad for the crossover knowledge posted here.

Related Posts:

  1. How do I import an SQL file using the command line in MySQL?
  2. How do I quickly rename a MySQL database (change schema name)?
  3. MySQL DROP all tables, ignoring foreign keys
  4. How can I rebuild indexes and update stats in MySQL innoDB?
  5. How to replace the domain name in a WordPress database?
  6. How to log mysql errors from wordpress core?
  7. #1115 – Unknown character set: ‘utf8mb4’
  8. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  9. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  10. How can I make wordpress suppress mysql errors?
  11. Error while importing database
  12. Unknown collation when I import a dump from an existing site into a development database?
  13. Migrating from Existing MySQL Setup to WordPress
  14. #1115 – Unknown character set: ‘utf8mb4’
  15. Trouble Migrating all data blog from WordPress.com to WordPress.org
  16. Regarding “Insert query error” in wordpress
  17. Create a form with custom autocomplete address field and CSV import values
  18. Error missing MySQL extension
  19. Exporting completed webiste for another server
  20. Export SQL query based on custom field?
  21. latency problems with wordpress install (from SQL import)
  22. Changes not being reflected on new server
  23. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  24. Weird characters displayed when importing WordPress MySQL db
  25. #1115 – Unknown character set: ‘utf8mb4’
  26. Datatabase error: Commands out of sync
  27. How should I troubleshoot a database serialization issue with a WordPress migration
  28. Importing Concrete5 content to WordPress
  29. Getting invalid user ID error when creating a new user with wp_insert_user
  30. How do I load a sql.gz file to my database? (importing)
  31. InnoDB: Error: log file ./ib_logfile0 is of different size
  32. MySQL error 2006: mysql server has gone away
  33. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  34. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  35. what does “/index.php?admin/admin_dashboard” in my url mean
  36. How to join two tables by multiple columns in SQL?
  37. How to get size of mysql database?
  38. SQL – Update multiple records in one query
  39. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  40. mysqladmin: connect to server at ‘localhost’ failed
  41. mysql update multiple columns with same now()
  42. Usage of MySQL’s “IF EXISTS”
  43. Generating a random & unique 8 character string using MySQL
  44. MySQL > Table doesn’t exist. But it does (or it should)
  45. SQL select only rows with max value on a column
  46. Trying to perform MINUS operation in MySQL
  47. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  48. How to create a foreign key in phpmyadmin
  49. Can’t create test file lower test start server mysql
  50. MySQL delete multiple rows in one query conditions unique to each row
  51. Create boolean column in MySQL with false as default value?
  52. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  53. CAST to DECIMAL in MySQL
  54. Failed to Connect to MySQL at localhost:3306 with user root
  55. How do you properly prepare a %LIKE% SQL statement?
  56. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  57. Migrating WP site to another URL
  58. SQL query to update post_date (one post = one single date & time)
  59. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  60. My WordPress site always displays a cached version of its homepage
  61. How to copy post titles to post slug in phpmyadmin
  62. Large database causes slow load
  63. Database: Custom table: sprintf value for DateTime column
  64. What is the most secure way to set up the MySQL user in WPMU?
  65. Importing New Posts from Live Site into Local Dev Site
  66. ‘Invalid post type’ error when importing from one site to another
  67. WP_USE_EXT_MYSQL
  68. Distinction on meta value on pre_get_posts
  69. How can I migrate (export and import) wordpress users without loosing their password?
  70. MySQL Rank & $wpdb
  71. WordPress post_status is future, manually added
  72. How are multiple WordPress WPDB queries handled?
  73. How do I transfer user passwords from one WordPress site to another?
  74. WordPress plugin overloading with tmp tables
  75. Site not responding error – taking long to load [closed]
  76. What do these phpMyAdmin errors mean on my WordPress databaes?
  77. WordPress(wpdb class) and mysql stored procedures
  78. WordPress plugins for database queries
  79. WordPress doesn’t display accents after migration
  80. Replace a character in all post titles and slugs
  81. Understanding custom php that reads from WP MYSQL
  82. require_once() error after moving WordPressto another server
  83. WordPress $wpdb no result
  84. how can we migrate wordpress 5.9 website from aws ec2 to new installed wp 5.9 oci compute
  85. Import from Windows to Linux
  86. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  87. edit_user_created_user hook – using to update Groups
  88. Mysql Error in querying form entries in Gravity Form plugin
  89. Trouble migrating custom post types from non-wordpress cms
  90. Improving performance of SQL sub-queries in WordPress
  91. WordPress Dashboard visible but site is not after migration
  92. Saving custom term value to the database in new table
  93. MySQL errors after a WordPress clone
  94. Restoring .sql backup results in “Error establishing a database connection”
  95. MYSQL Join on meta key value?
  96. Complicated MySQL Query
  97. problem with quotes on new post
  98. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  99. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  100. Batch Replace URLs in WordPress Database