Some serious problems with incremental backups

[fenixer]

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]

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

 

[fenixer]

........... 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????

 

[Zion Ahead]

Same problem here. Its been YEARS with this problem and cpanel has yet to fix this.

 

[cPanelNick]

........... 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]

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]

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.

 

[britsenigma]

R1Soft....cP are not gonna tread on their partners tows.

 

[sneader]

Gino, you promised to update this thread, but never did. What ever came of this?

- Scott

 

[coderoyal]

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

 

[bman]

i don't think they will ever fix this problem

 

[cPanelDavidG]

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?