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

000

Well-Known Member
Jun 3, 2008
229
6
68
Hi.

In server#1 I have a some tables of 4 GB and 7 GB.

How I can transfer all this using PUTTY from
server#1 to server#2? (both with cPanel)

Or...
Maybe WHM can do?

NOTE: only transfer the table MYSQL, no the [count/user] or BD complet.

Thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.