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,277
    Likes Received:
    9
    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. Remotech

    Removing a user from a database doesn't appear to work.

    Remotech, Nov 12, 2015, in forum: Database Discussions
    Replies:
    3
    Views:
    427
    cPanelMichael
    Nov 12, 2015
  2. Matthew Wakeford

    Moving Hosting to cPanel DNS Question

    Matthew Wakeford, Aug 7, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    107
    cPanelMichael
    Aug 8, 2017
  3. Mauritz

    Removing home2 partition

    Mauritz, Jul 11, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    128
    cPanelMichael
    Jul 11, 2017
  4. WorkinOnIt

    Moving server - DNS and TTL

    WorkinOnIt, Jun 15, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    128
    kssuhesh
    Jun 22, 2017
  5. ctrenks

    Moving .htaccess to httpd.conf Issue

    ctrenks, May 19, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    236
    cPanelMichael
    May 24, 2017

Share This Page