How can I copy a table from one database to another table?

Question

MySQL

Hello! tell me how to copy a table from one database from a table to another database?
INSERT INTO `Project_database`.`nex_autentification`
SELECT *
FROM `Project_database_old`.`auth_item`;
i used this approach it didn't work

Answer 1

1. Use database/table import/export in some tool like phpmyadmin.
or
2. Write a script with two connections. For the first connection, you make a portioned selection, for the second, you insert the result of the selection from the first connection.