Answer the question
In order to leave comments, you need to log in
How to properly restore InnoDB?
Wordpress site.
After restarting the MySQL server, it went down.
Trying to start MySQL with innodb_force_recovery = 1 allowed MySQL to start.
tables of the MyISAM type (wp_posts, wp_postmeta) appeared in the MySQL database, although my.conf settings are only for using InnoDB.
With the command
ALTER TABLE wp_postmeta engine=InnoDB;
managed to return all records in wp_postmeta table to InnoDB format. This does not work with the wp_posts table.
while trying
wp-admin/maint/repair.php
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
didn't help.
The site works, but when you go to the post, it shows a 404 page has not been found error.
I think this is due to the fact that the data in the wp_posts and wp_postmeta tables are written in different formats, right? What do you think?
Help fix the situation with wp_posts and tell me what to prescribe so that by default tables are created only in InnoDB?
Answer the question
In order to leave comments, you need to log in
Restore a table from an Innodb backup
is much more difficult to restore after a crash than mayisam
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question