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:
    35,630
    Likes Received:
    1,136
    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:
    35,630
    Likes Received:
    1,136
    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. epaslv

    New Thread AutoSSL produces invalid certificate after transfer

    epaslv, Jun 23, 2017 at 9:41 PM, in forum: General Discussion
    Replies:
    3
    Views:
    19
    24x7serversecurity
    Jun 24, 2017 at 9:43 AM
  2. roddy

    'Low Priority' transfer

    roddy, Jun 20, 2017 at 7:24 PM, in forum: General Discussion
    Replies:
    1
    Views:
    31
    cPanelMichael
    Jun 21, 2017 at 11:02 AM
  3. harilip

    Transfering cPanel account question

    harilip, Jun 15, 2017, in forum: Data Protection
    Replies:
    3
    Views:
    95
    cPanelMichael
    Jun 16, 2017
  4. Alex H

    Transfer single account between servers

    Alex H, Jun 13, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    48
    Alex H
    Jun 13, 2017
  5. Havri

    Erase unused transfer sessions

    Havri, Jun 7, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    40
    cPanelMichael
    Jun 7, 2017

Share This Page