Do JetBackup incremental backups succesfully back up MySQL databases?

I'm looking to change my backing-up process, mostly because the default cPanel system creates compressed files that are getting too big for my server's disk. If I understand correctly, incremental backups don't cause this issue because they don't compress everything into one file during the backup process. I was looking at JetBackup. How do the MySQL (technically I'm using MariaDB) backups work with it? I see that some backup systems have issues with database backups because there are ongoing processes happening while the backup is happening. How does JetBackup account for this? Also, would it be possible to restore a backed-up database to a new database on the server? For example, let's say one table in my database accidentally has all of its rows deleted. Could I restore a backup to a new database, copy the one table over as needed, and then delete that new database?

cPRex Jurassic Moderator

September 25, 2023 23:29

Hey there! Traditional MySQL databases in general, are not backed up well in an incremental fashion, and JetBackup is no exception to this. From their documentation here, they state that they are still dumped in entirety:

T1531

September 26, 2023 03:47

cPAdminsMichael

September 26, 2023 08:59

Correct - cPanel's backup is also based on mysqldumpts. In newest version of JetBackup 5.3 they have included new "semi-incremental" MySQL backup feature which compares tables and does only backup of changes tables. I don't have much experience with it though... For customers who NEEDED incremental backup, we have developed a backup script to utilize mariabackup, which only supports MariaDB, but does support incremental backups and then using cPanel backup or JetBackup to backup the incremental backups from mariabackup.

Do JetBackup incremental backups succesfully back up MySQL databases?

Comments

Didn't find what you were looking for?