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:
    156
    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:
    42,734
    Likes Received:
    1,706
    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:
    156
    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:
    42,734
    Likes Received:
    1,706
    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. rhm.geerts

    SPF not replaced on transfer

    rhm.geerts, Apr 12, 2018, in forum: General Discussion
    Replies:
    7
    Views:
    69
    cPanelLauren
    Apr 13, 2018
  2. Brian Faught

    Transfer Domain from WIX

    Brian Faught, Apr 3, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    47
    cPanelMichael
    Apr 3, 2018
  3. speckados

    Wrong format in transfer license

    speckados, Apr 3, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    32
    cPanelMichael
    Apr 3, 2018
  4. carock

    SOLVED Transfer tool symlinks

    carock, Mar 30, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    86
    carock
    Mar 30, 2018
  5. Tagir Gumerov

    Unexpected return value of get_transfer_session_state

    Tagir Gumerov, Mar 28, 2018, in forum: cPanel Developers
    Replies:
    5
    Views:
    111
    cPanelMichael
    Apr 13, 2018

Share This Page