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!

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:
    159
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Oct 28, 2013
  3. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    159
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Oct 29, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - transfer TABLES MySQL
  1. JesusSuarz

    Problem with DNS and Addon Domains after transferring accounts

    JesusSuarz, Oct 8, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    190
    cPanelLauren
    Oct 9, 2018
  2. Jeff P.

    SOLVED Transfer Password Issue

    Jeff P., Oct 6, 2018, in forum: Data Protection
    Replies:
    4
    Views:
    81
    cPanelLauren
    Oct 8, 2018
  3. vacancy

    Account transfer .htaccess file cannot moved

    vacancy, Oct 4, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    77
    cPanelLauren
    Oct 10, 2018
  4. cPanelResources

    Tutorial How To: Manual Account Transfer With Rsync

    cPanelResources, Sep 25, 2018, in forum: Data Protection
    Replies:
    0
    Views:
    67
    cPanelResources
    Sep 25, 2018
  5. PeteS

    Transfer fails via: Copy an Account From Another Server With an Account Password

    PeteS, Sep 23, 2018, in forum: Data Protection
    Replies:
    11
    Views:
    151
    PeteS
    Oct 12, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice