Some serious problems with incremental backups

fenixer

Well-Known Member
Feb 23, 2007
92
0
156
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.
 

rotame

Member
Sep 20, 2006
19
2
153
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:
 

fenixer

Well-Known Member
Feb 23, 2007
92
0
156
........... 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????
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,481
35
208
cPanel Access Level
DataCenter Provider
........... 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????
Please open a ticket @ https://tickets.cpanel.net/submit/

The incremental backup should backup all the sql users
 

bman

Well-Known Member
Dec 28, 2003
119
0
166
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 ?
 

fenixer

Well-Known Member
Feb 23, 2007
92
0
156
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.
 
Last edited:

coderoyal

Well-Known Member
Mar 8, 2005
58
0
156
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
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
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
To clarify, these were cPanel/WHM accounts that you were restoring to a cPanel/WHM server? What is your full cPanel/WHM version information?