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. After Import: Insert “Use” Statement in Database
  33. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  34. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  35. How to use mysqli_query() in PHP?
  36. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  37. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  38. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  39. Column count doesn’t match value count at row 1
  40. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  41. MySQL string replace
  42. Cannot add or update a child row: a foreign key constraint fails
  43. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  44. String concatenation in MySQL
  45. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  46. Cannot add or update a child row: a foreign key constraint fails
  47. MySQL Error “Operand should contain 1 column”
  48. How to use MySQL DECIMAL?
  49. Access denied for user ‘root@localhost’ (using password:NO)
  50. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  51. How to make MySQL table primary key auto increment with some prefix
  52. Access denied for user ‘root@localhost’ (using password:NO)
  53. MySQL ERROR 1290 (HY000) –secure-file-priv option
  54. MySQL error 2006: mysql server has gone away
  55. Which MySQL data type to use for storing boolean values
  56. sql query with multiple where statements
  57. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  58. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  59. Cannot delete or update a parent row: a foreign key constraint fails
  60. Cannot delete or update a parent row: a foreign key constraint fails
  61. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  62. MySQL server startup error ‘The server quit without updating PID file’
  63. Rename a column in MySQL
  64. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  65. Cannot delete or update a parent row: a foreign key constraint fails
  66. MySQL server startup error ‘The server quit without updating PID file’
  67. How do I restore a dump file from mysqldump?
  68. Syntax error due to using a reserved word as a table or column name in MySQL
  69. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  70. MySQL root password change
  71. Installation of MySQL for Visual Studio 1.2.8 failed
  72. Not unique table/alias
  73. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  74. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  75. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  76. Your password does not satisfy the current policy requirements
  77. What does SQL Select symbol || mean?
  78. How do I import an SQL file using the command line in MySQL?
  79. Install mysql-python (Windows)
  80. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  81. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  82. SQL – Update multiple records in one query
  83. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  84. What is the definition of cardinality in SQL
  85. How to restart remote MySQL server running on Ubuntu linux?
  86. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  87. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  88. When to use SELECT … FOR UPDATE?
  89. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  90. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  91. Setting up foreign keys in phpMyAdmin?
  92. Select from multiple tables without a join?
  93. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  94. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  95. SQL Query Where Field DOES NOT Contain $x
  96. Create a new database with MySQL Workbench
  97. Duplicating a MySQL table, indices, and data
  98. Disable ONLY_FULL_GROUP_BY
  99. what does “/index.php?admin/admin_dashboard” in my url mean
  100. Column ‘user_id’ in field list is ambiguous
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)