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

000

Well-Known Member
Jun 3, 2008
549
30
78
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,880
2,267
463
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.
 

000

Well-Known Member
Jun 3, 2008
549
30
78
You can use the "mysqldump"
Thanks master.

Then no exist some command to transfer DIRECTLY and in format REMOTE
from S1 to S2 ??? (S-erver)

Some as:

ssh root@S1
mysql "SELECT * FROM table X and INSERT INTO SERVER2"...

This option/command no exist?

Regards
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.