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.

Backup technical question

Discussion in 'General Discussion' started by beshoo, Jul 30, 2007.

  1. beshoo

    beshoo Member

    Joined:
    Apr 12, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Dear flock ,

    I have question

    If I have up to 2500 Account on my server , let assume server name as "A"

    A specification :
    WHM 11.1.0 cPanel 11.2.12-C12178
    FEDORA 1 i686 - WHM X v3.1.0

    I want to transfer all account to Other Server , let assume server name as "B".
    B specification:
    WHM 11.2.0 cPanel 11.8.0-C15689
    CENTOS Enterprise 4.4 i686 - WHM X v3.1.0


    Well , if I want to use cpanel function :
    Copy multiple accounts/packages from another server

    This well work but not for 2500 account, because Time Out will of the browser !

    Ok , there is an idea com up .
    Can I copy
    ./home
    ./var/lib/mysql/

    And transfer these directory form A to B , and make Cpanel Regenerate all system files /DNS files/ Vallies / …. Etc .

    If not !

    Can I copy
    ./home
    ./use
    ./var

    From A to B , restart the server ! would this work !

    If not , what I have to do !

    Please advice !
     
  2. nyjimbo

    nyjimbo Well-Known Member

    Joined:
    Jan 25, 2003
    Messages:
    1,125
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    New York
    DO NOT copy all of "/usr" and "/var" or directories like that, you will kill your server since you are running mixing centos and fedora.

    Look at some of the threads on cloning, migrating, etc.... here is a good one that might get you started.

    http://forums.cpanel.net/showthread.php?t=35046
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    There's a lot more to manual migration than copying those 3 directories. If you want to do a full server backup and the web browser times out on you, use the command-line equivalent:

    /scripts/cpbackup
     
  4. bin_asc

    bin_asc Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    280
    Likes Received:
    0
    Trophy Points:
    16
    Do full home backups with the following command :

    Then scp cpmove-* from /home in a new server`s /home, make a text files on the new server with all the users from /var/cpanel/users, say users.txt, and in the new server issue :

     
  5. beshoo

    beshoo Member

    Joined:
    Apr 12, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Dear support , bin_asc and nyjimbo

    Thank you for your kindly reply !

    Well the problem with using pkgacct , restorepkg and cpbackup is Mysql
    with these commands , pkgacct cpanel command well try to generate SQL Text file , for each database , 1st of all this will take long time and server load to extract database to text file .

    Now , restorepkg weill try to execute MySql Text file and preform Insert commands , this will take LONG time if you know that the smallest data base i have is 800 Mb.

    Now , can I pkgacct , restorepkg But i dont want to embed Mysql as extracted text files but as *.frm *.MYI *.Myd ..etc fromat ! this will save times while backup and restor.

    Ps : what about resellers account can we backup all accounts !


    thank you for your valuable information
     
    #5 beshoo, Jul 31, 2007
    Last edited: Jul 31, 2007
  6. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Keep in mind, most users consider the information in their databases critical to their web infrastructure. I know if I was a user, I wouldn't want my sysAdmin deleting my databases to cut corners on backups.

    If the data in the databases is truly unnecessary, why not prune the databases keeping only the data you actually need instead of trying to avoid backing up that data?

    As for resellers having a "backup all accounts" feature, there is currently a feature request in for that at: http://bugzilla.cpanel.net/show_bug.cgi?id=5425

    Feel free to CC yourself and/or vote for the feature.
     
  7. beshoo

    beshoo Member

    Joined:
    Apr 12, 2005
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Dear cPanelDavidG , thank you for your gently reply !

    Well the database is the MOST important thing in this post !

    and as i told the main problem is how pkgacct , restorepkg and cpbackup work with MYSQL !

    these commands extract / execute mysql Text files , and performing huge load on the server side !
    but if pkgacct copy the database as it in the /var/lib/mysql/[USER_NAME] ..
    instead of extracting Data as Mysql TEXT file , this will save a Lot of time and load as well !

    thats the hall point of view !
     
  8. bin_asc

    bin_asc Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    280
    Likes Received:
    0
    Trophy Points:
    16
    You could try exporting the databases using SSH, mysqldump, then deleting the databases, pkgacct and restorepkgacct, then just import the databases with SSH. Importing them with SSH is alot let stressfull for the server, and you can import large quantities too.
     
Loading...

Share This Page