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:
    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:
    43,672
    Likes Received:
    1,788
    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.
     
    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:
    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:
    43,672
    Likes Received:
    1,788
    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.
     
    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. peter naijac

    error for all subdomains after transfer

    peter naijac, Jun 13, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    43
    cPanelLauren
    Jun 14, 2018
  2. magj

    Restore from transfer failed backup cpmove file

    magj, Jun 9, 2018, in forum: Data Protection
    Replies:
    4
    Views:
    99
    cPanelMichael
    Jun 12, 2018
  3. Skin

    SOLVED Forbidden error for all subdomains after transfer

    Skin, Jun 9, 2018, in forum: General Discussion
    Replies:
    4
    Views:
    82
    cPanelLauren
    Jun 11, 2018
  4. srjonet

    Where are backup files placed after transfer?

    srjonet, Jun 5, 2018, in forum: Data Protection
    Replies:
    7
    Views:
    97
    cPanelMichael
    Jun 13, 2018
  5. ecodinom

    Modify reporting mail transfer agent

    ecodinom, May 22, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    50
    cPanelMichael
    May 22, 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