A
A
Alexey2018-03-27 09:10:11
MySQL
Alexey, 2018-03-27 09:10:11

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

2 answer(s)
L
Lazy @BojackHorseman MySQL, 2018-03-27
Tag

I think that you need to restore from backups.

P
Puma Thailand, 2018-03-27
@opium

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 question

Ask a Question

731 491 924 answers to any question