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.

Some serious problems with incremental backups

Discussion in 'General Discussion' started by fenixer, Feb 25, 2009.

  1. fenixer

    fenixer Well-Known Member

    Joined:
    Feb 23, 2007
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    Hello.....

    Currently using cPanel 11.24.4-R32603 - WHM 11.24.2 with incremental backups enabled.... few days ago, I restored my first account (previously deleted) from incremental backups.... then...

    Can somebody confirm this???

    - rsync, or cpanel incremental backup script, does not take care of permissions over files..... by example, if client did "chmod" to 777 a folder or file, but no file or data is added/removed/modified inside, the modified date is the same, so incremental backup does not stored this new information (permissións)........ sometimes you will have to fix manually permissións over files or folders for the websites to run...

    - mysql.sql............... Wow!!!! the mysql.sql is not being updated!!!!!!!!!!!!! So new mysql-users are not being stored into package backup the incremental way!?!?!?!?! This king of incremental backup can hurt your head when restoring a user with 8-9-10 mysql-users......

    - The mysql folder of an account will have always new databases stored as sql files, but old ones (also deleted ones) may be there forever...... it seems...... it is a bit sad, as they may be restored althought client remove them time ago...

    Also for my restore of yesterday, a recent addon domain configured by my client was not "imported" when restoring...... had to do it manually.

    It seems incremental backups is such a pain! It is a great sollution when you want to not overload your server when backing-up, as it is quick and not heavy, but cpanels scripts have too many "holes".

    Anybody can confirm?

    I think I am returning complete backups, but need to modify the cpbackup script to not gzipping the tars..........

    Thanks.
     
  2. rotame

    rotame Member

    Joined:
    Sep 20, 2006
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens,Greece
    cPanel Access Level:
    Root Administrator
    I faced a problem with restore an account , mysql didnt have backuped well and some files also were missing , I performed restore direct from the server.
    It was very bizzare case and I had many problems , I never faced problem with full backups:confused:
     
  3. fenixer

    fenixer Well-Known Member

    Joined:
    Feb 23, 2007
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    ........... for me is becoming neccessary something like incremental backup, since, althought modifying cpbackup to nocompress tars to gz, storing at tars Gb and Gb of the same files each night is overloading my server and the backups are still live working at 10.00am in the morning, so clients may face to 18-24 loads....

    It is a pity incremental backup is INCOMPLETE, because it seems to be just it....... i think it is incredible it is a "production" feature which, by example, does not take care of update mysql.sql file with mysql users data.......................... no one tested neither programmers thought of it????
     
  4. Zion Ahead

    Zion Ahead Well-Known Member

    Joined:
    Nov 10, 2006
    Messages:
    347
    Likes Received:
    0
    Trophy Points:
    16
    Same problem here. Its been YEARS with this problem and cpanel has yet to fix this.
     
  5. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Please open a ticket @ https://tickets.cpanel.net/submit/

    The incremental backup should backup all the sql users
     
  6. bman

    bman Well-Known Member

    Joined:
    Dec 28, 2003
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    when will this be fixed ?
    my problem is restored accounts are missing the mysql users
    i had to add the mysql users back again Manuel to the account
    is this problem related to Release version only ? is stable suffering from the same problem ?
     
  7. fenixer

    fenixer Well-Known Member

    Joined:
    Feb 23, 2007
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    Still the same at:
    cPanel 11.24.4-R35075 - WHM 11.24.2 - X 3.9 RELEASE

    - No update of "mysql.sql" (old users remain and new users of mysql are not backed up)
    - No update of "addons" (the same, but for addon domains... no update at all, so new will be lost and old remain)
    - No removal of old sqls at mysql folder........ the old databases, although they are removed, are not deleted from this folder, so it will be restored if backup restored.......
    - No update of "nobodyfiles" (......)
    - No removal of old zones at "userdata" folder... old subdomains and addon domains remain there..
    - The same for "vf", "va" and "vad" folders
    - No update for "sds" and "sds2" files......... old subdomains and addon domains remain there..

    At least, "cp" folder seems updated.... ;)

    IMHO, I think it is long time enough for Cpanel to update their pkgacct scripts or cpbackup scripts so incremental backups just run OK..........

    Running this way, I think incremental backup is better for Beta versions or EDGE, because if you are using it, if you need to restore something you'll get:

    1) old mysql databases, removed months ago, are restored!!!?!?!?
    2) CORRECTED - Exactly the same with mysql users... old mysql databases, removed months ago, are restored, BUT since the file is not updated, new mysql users configured during this months are not included and not restored!!!!
    3) old and removed months ago addon domains are there!!!!!!
    4) also the old subdomains client had removed months ago are there!!!
    5) HUGH!!! The new addon domains, are created only at DNS level, but Apache misses the subdomain/addon domain so it is not created!!!!!!

    Do you think, Cpanel guys, this is RELEASE for more than a year?? This scripts from you may do many hostmasters to face serious problems with some clients.....

    Cpanel programmers should update correctly the cp files and later, do incremental over homedir....... I think it is easy easy........

    ---

    Have just opened a ticket with exactly this content..... will update this.
     
    #7 fenixer, May 11, 2009
    Last edited: May 11, 2009
  8. britsenigma

    britsenigma Well-Known Member

    Joined:
    Dec 14, 2008
    Messages:
    85
    Likes Received:
    0
    Trophy Points:
    6
    R1Soft....cP are not gonna tread on their partners tows.
     
  9. sneader

    sneader Well-Known Member

    Joined:
    Aug 21, 2003
    Messages:
    1,126
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    La Crosse, WI
    cPanel Access Level:
    Root Administrator
    Gino, you promised to update this thread, but never did. What ever came of this?

    - Scott
     
  10. coderoyal

    coderoyal Well-Known Member

    Joined:
    Mar 8, 2005
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    6
    Recently, I restored about 4 or 5 accounts in cPanel, with the latest version cPanel 11.24.5 on RHEL 64x and I discovered that the MYSQL user accounts are not being created during the restore phase.

    Some mysql user accounts are created, but not all of them. I had to manually create the mysql user accounts again and configure the scripts to authenticate with the new account.

    Fortunately, all of the databases restored OK so I don't have any other issues.

    I'm not sure if this works, but after restoring the accounts, I later deleted the backups of them, so that the cPanel script would generate new backups for the accounts. I'm hoping that a fresh backup folder would generate a working backup for future use.

    I just wanted to share that I have some issues as well.

    Take care,
    Alan
    Hermon Schools
     
  11. bman

    bman Well-Known Member

    Joined:
    Dec 28, 2003
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    i don't think they will ever fix this problem
     
  12. 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
    To clarify, these were cPanel/WHM accounts that you were restoring to a cPanel/WHM server? What is your full cPanel/WHM version information?
     
Loading...

Share This Page