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

Question

MySQL

How to transfer a table from one database to another in mysql? Working with wordpress tables Posts are copied normally, but there is a problem with categories. In the admin panel, the counter displays the required number of posts, but does not display more than half. The site also does not display those categories that are in the admin panel.

Answer 1

Hello!
First of all you will need phpmyadmin. Go to phpmyadmin, select the exported table, export to a file. Open another table, import the exported table back....
Well, or you can do this: change the table prefix in wp-config. And instead of a separate 2nd table, export and import everything in the same place, but with a different prefix ...
Better yet, figure out the problem. Start for example,
If you see the problem in the database.
www.wpbeginner.com/wp-tutorials/how-to-fix-the-err...