Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by 000, Oct 28, 2013.

  1. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    154
    Likes Received:
    0
    Trophy Points:
    66
    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
     
    #1 000, Oct 28, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 cPanelMichael, Oct 28, 2013
  3. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    154
    Likes Received:
    0
    Trophy Points:
    66
    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
     
    #3 000, Oct 28, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #4 cPanelMichael, Oct 29, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - transfer TABLES MySQL
  1. janipewter

    Manually starting the backup transfer

    janipewter, Oct 12, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    65
    Infopro
    Oct 12, 2017
  2. spaceman

    Why does the restore get stuck during a transfer tool process?

    spaceman, Oct 5, 2017, in forum: Data Protection
    Replies:
    4
    Views:
    101
    spaceman
    Oct 7, 2017
  3. abaumeryam

    Problem:: Transfer Tool

    abaumeryam, Oct 4, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    81
    cPanelMichael
    Oct 4, 2017
  4. kabatak

    When does cPanel delete finished backup transfers?

    kabatak, Oct 3, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    66
    cPanelMichael
    Oct 3, 2017
  5. ladydi711

    cPanel server migration - need to transfer zones without cPanel accounts

    ladydi711, Sep 29, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    118
    cPanelMichael
    Oct 2, 2017

Share This Page