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.

Moving a database from one server to another

Discussion in 'General Discussion' started by gvard, Oct 30, 2007.

  1. gvard

    gvard Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2003
    Messages:
    195
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Athens/GREECE
    cPanel Access Level:
    DataCenter Provider
    Greetings from Greece,

    We have 1 dedicated server at Alabanza which is used for 1 free-email website. The server is quite old and has only an 18GB hard disk. The database of the website is about 11GB and the partition to which it exists (/home) is 90% full (has about 1GB of free webspace). We're stopping our contract with Alabanza and have managed to move all sites from the Alabanza servers to some cPanel servers we have.... all except this site!

    This site is going to be moved to its own non-cpanel dedicated server, however I can't find a decent solution for me to do this. The MySQL database has about 6500+ tables and there isn't enough free disk space for me to zip the database and transfer it over FTP.

    Any ideas on how to transfer it will be appreciated!
     
    #1 gvard, Oct 30, 2007
  2. rustelekom

    rustelekom Well-Known Member
    PartnerNOC

    Joined:
    Nov 13, 2003
    Messages:
    290
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    moscow
    you can just stop mysql server on alabanza and new server and then use rsync or scp for moving mysql database files from old server to new server over the net. it is not too hard.

    PS. do not forgot check ownership and chmod for mysql files.
     
    #2 rustelekom, Oct 30, 2007
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,216
    Likes Received:
    10
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    #3 cPanelDavidG, Oct 31, 2007
    Last edited: Oct 31, 2007
  4. gvard

    gvard Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2003
    Messages:
    195
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    Athens/GREECE
    cPanel Access Level:
    DataCenter Provider
    Hello,

    Thank you very much for your answer! I've never worked with rsync before, do you have any examples on how I can copy /var/lib/mysql/database_name/ to another server? Do I need to have some agent installed in either of the servers? Any help would be appreciated!
     
    #4 gvard, Oct 31, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - Moving database server
  1. Robin Ball

    SOLVED Moving a wordpress site issue

    Robin Ball, Apr 22, 2018 at 6:19 AM, in forum: General Discussion
    Replies:
    5
    Views:
    75
    Robin Ball
    Apr 22, 2018 at 5:05 PM
  2. stephanw

    SOLVED Remove Account Without Removing DNS?

    stephanw, Apr 13, 2018, in forum: Bind / DNS / Nameserver Issues
    Replies:
    6
    Views:
    88
    cPanelMichael
    Apr 16, 2018
  3. ibokahveci

    Removing Plugin From WebHost Manager Problem

    ibokahveci, Apr 12, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    313
    cPanelLauren
    Apr 12, 2018
  4. Legin76

    Remote Images not showing after moving server

    Legin76, Apr 5, 2018, in forum: General Discussion
    Replies:
    15
    Views:
    98
    cPanelLauren
    Apr 9, 2018
  5. cosjames

    Moving from Ensim to cPanel Issues

    cosjames, Mar 30, 2018, in forum: Migrate to cPanel
    Replies:
    4
    Views:
    201
    cPanelKyle
    Apr 2, 2018

Share This Page