how transfer TABLES MySQL from server 1 to server 2? (both with cPanel)

Hello

You can use the "mysqldump" utility to backup specific tables with a command such as:

Code:

mysqldump database_name table_name table2_name table3_name > /path/to/database_name.sql

You can then upload the SQL file to the destination server and restore it via:

Code:

mysql database_name < /path/to/database_name.sql

Note: The above commands assume you are logged in as "root" to both machines.

Thank you.

 

There are two separate MySQL servers running, so that would not work. I recommend using SCP or SFTP to upload the database dump to the destination server.

Thank you.