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

000

• October 28, 2013 10:18

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

  • October 28, 2013 17:29

  Hello :) You can use the "mysqldump" utility to backup specific tables with a command such as: 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: mysql database_name < /path/to/database_name.sql
  Note: The above commands assume you are logged in as "root" to both machines. Thank you.

  0
• 

  000

  • October 28, 2013 22:25

  [quote="cPanelMichael, post: 1492401">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

  0
• 

  cPanelMichael

  • October 29, 2013 14:52

  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.

  0

Please sign in to leave a comment.