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:
    152
    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:
    36,995
    Likes Received:
    1,275
    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:
    152
    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:
    36,995
    Likes Received:
    1,275
    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. esspbee

    Transfer tool - load/size/dB

    esspbee, Aug 16, 2017 at 3:29 PM, in forum: Data Protection
    Replies:
    1
    Views:
    21
    cPanelMichael
    Aug 16, 2017 at 3:43 PM
  2. dccsi

    limit rate while transfer backup into amazon S3

    dccsi, Aug 10, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    56
    cPanelMichael
    Aug 10, 2017
  3. webmastersmind

    Remote user account Transfer

    webmastersmind, Aug 8, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    49
    cPanelMichael
    Aug 8, 2017
  4. amin alnasra

    IPv6 Addresses in DNS zones after transfer

    amin alnasra, Aug 5, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    1
    Views:
    98
    cPanelMichael
    Aug 8, 2017
  5. kostianev

    Transfer All Accounts and Settings to New Server?

    kostianev, Aug 3, 2017, in forum: Data Protection
    Replies:
    4
    Views:
    99
    kostianev
    Aug 3, 2017

Share This Page