How in mysql to migrate a table from one database to another?

0 like 0 dislike
12 views
How in mysql to migrate a table from one database to another? Working with tables in wordpress. The posts are copied normally, but with the categories problem. In the admin panel meter displays the desired number of posts, but more than half didn't reflect that. The site also does not display those orders in the admin area.
by | 12 views

1 Answer

0 like 0 dislike
Hello!
Firstly, you will need phpmyadmin. Go into phpmyadmin, select export table, export to a file. Open another table, import the exported spreadsheet back....

Well, or unable to do so: to change the table prefix in wp-config. And instead of a separate 2nd table to export and import all there, but with a different prefix...

And even better to understand the problem. Start for example,
define('WP_ALLOW_REPAIR', true);
If you see a problem in the database.
\rwww.wpbeginner.com/wp-tutorials/how-to-fix-the-err...
by

Related questions

0 like 0 dislike
6 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
asked Apr 14, 2019 by Lyuba2018
110,608 questions
257,186 answers
0 comments
33,905 users