Hi Guys,
We are a happy user of JetBackup on several of our shared hosting servers.
However, we have an issue.
On every server we constantly have 5-8 clients who do not get a complete backup, because they have a faulty database.
Right now we are manually contacting these customers to get them to fix their database, so their backup can run fully, but this is not a scaleable solution. Many of the customers do not know how to fix their db, so they dont have a database-backup at all.
Therefore i have these questions:
1 - Is there anyway to automatically notifying clients if their backup do not complete fully?
2 - OR can we setup Jetbackup so it backup the database eventhough the database has corrupt tables?
Thanks!
Backups partially completed due to errors in client databses
-
- Staff Member
- Posts: 54
- Joined: March 2nd, 2019, 2:40 am
Re: Backups partially completed due to errors in client databses
Hi MrIver,
Glad to hear of your positive experience using JetBackup and sorry to hear about your issue.
For Item #1, JetBackup currently does not have a built-in feature to send notifications to
for each corresponding accounts regarding their backups.
With that said, I will be reaching out to our devs to further discuss this feature and consider for a future release of JetBackup. May I also suggest opening up a request for this feature at our request
site: request.jetapps.com
For Item #2, You can achieve this by enabling the "force" flag on Settings > Performance and this should let jetbackup proceed with the mysqldump regardless of the corrupted tables/database.
https://docs.jetbackup.com/manual/whm/S ... force-flag
For more information about the mysqldump force flag, please visit the official documentation here:
https://dev.mysql.com/doc/refman/8.0/en ... dump_force
Best Regards,
Anton, JetApps Team.
Glad to hear of your positive experience using JetBackup and sorry to hear about your issue.
For Item #1, JetBackup currently does not have a built-in feature to send notifications to
for each corresponding accounts regarding their backups.
With that said, I will be reaching out to our devs to further discuss this feature and consider for a future release of JetBackup. May I also suggest opening up a request for this feature at our request
site: request.jetapps.com
For Item #2, You can achieve this by enabling the "force" flag on Settings > Performance and this should let jetbackup proceed with the mysqldump regardless of the corrupted tables/database.
https://docs.jetbackup.com/manual/whm/S ... force-flag
For more information about the mysqldump force flag, please visit the official documentation here:
https://dev.mysql.com/doc/refman/8.0/en ... dump_force
Best Regards,
Anton, JetApps Team.
Anton, JetApps Team
Re: Backups partially completed due to errors in client databses
Hi Anton,
Thank you very much for your reply.
We already got "Force" set to yes:
https://imgur.com/a/FQnaYFw
However we still got errors like the one below, making the database backup fail:
Something we are missing in the setup?
Thank you very much for your reply.
We already got "Force" set to yes:
https://imgur.com/a/FQnaYFw
However we still got errors like the one below, making the database backup fail:
Code: Select all
[31 March 2020 12:02:09 AM +0200] Databases
[31 March 2020 12:02:09 AM +0200] Grabbing...
[31 March 2020 12:02:09 AM +0200] Dumping Database 'cust_wp2' (Engine: MySQL)...FAILED
[31 March 2020 12:02:09 AM +0200] [ERROR] mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should
Code: Select all
[28 March 2020 12:03:39 AM +0100] Databases
[28 March 2020 12:03:39 AM +0100] Grabbing...
[28 March 2020 12:03:39 AM +0100] Dumping Database 'cust2_wp2' (Engine: MySQL)...FAILED
[28 March 2020 12:03:39 AM +0100] [ERROR] mysqldump: Error 1194: Table 'wp_wfhits' is marked as crashed and should be repaired when dumping table `wp_wfhits` at row: 865
mysqldump: Error 1194: Table 'wp_wflogins' is marked as crashed and should be repaired when dumping table `wp_wflogins` at row: 800
Re: Backups partially completed due to errors in client databses
Hi Anton,
Any idea of what we are missing in our setup in order to make it work?
Thanks!
Any idea of what we are missing in our setup in order to make it work?
Thanks!
-
- Staff Member
- Posts: 54
- Joined: March 2nd, 2019, 2:40 am
Re: Backups partially completed due to errors in client databses
Hi MrIver,
Apologies for the delay getting back to you. Could you please verify if the following databases are missing or incomplete from your backups after setting the force flag?
Just to clarify,
For example, when creating a dump without the force flag, MySQL will stop generating the dump file at the point of receiving an error:
while with the --force flag, it will still print out an error but continues to execute and dump the rest of the database.
Ultimately, you would want to have theses tables/databases repaired for a reliable backup.
If you still encounter issue, please don't hesitate to reach out and open a ticket to our helpdesk at support@jetapps.com.
Best Regards,
Anton, JetApps Team.
Apologies for the delay getting back to you. Could you please verify if the following databases are missing or incomplete from your backups after setting the force flag?
Just to clarify,
You will still receive an error message for the broken tables as mysqldump will still return an error over to JetBackup. The main benefit with the --force flag is that mysqldump will continue to create a dumpfile of your database after encountering an error.With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing.
For example, when creating a dump without the force flag, MySQL will stop generating the dump file at the point of receiving an error:
Code: Select all
mysqldump broken_test_database > test.sql
-rw-r--r--. 1 root root 1277 Apr 2 19:30 test.sql
Code: Select all
mysqldump --force broken_test_database > test2.sql
-rw-r--r--. 1 root root 1748 Apr 2 19:31 test2.sql
If you still encounter issue, please don't hesitate to reach out and open a ticket to our helpdesk at support@jetapps.com.
Best Regards,
Anton, JetApps Team.
Anton, JetApps Team
Re: Backups partially completed due to errors in client databses
Hi Anton,
Thanks for getting back.
Yes I can confirm that the databases are not beeing backed up for customers with errors.
Example: CustomerA
When i log into cPanel as this customer and look under JetBackup -> Database Backup i get "No Backups Found"
https://imgur.com/a/hrtKUMk
When running backups for that table commandline i get the same error:
We are using JetBackup version Version 4.0.18
Thanks for getting back.
Yes I can confirm that the databases are not beeing backed up for customers with errors.
Example: CustomerA
Code: Select all
[03 April 2020 12:02:54 AM +0200] Databases
[03 April 2020 12:02:54 AM +0200] Grabbing...
[03 April 2020 12:02:54 AM +0200] Dumping Database 'CustomerA' (Engine: MySQL)...FAILED
[03 April 2020 12:02:54 AM +0200] [ERROR] mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should be repaired when dumping table `wp_woocommerce_sessions` at row: 0
https://imgur.com/a/hrtKUMk
When running backups for that table commandline i get the same error:
Code: Select all
[root@XX ~]# mysqldump --force CustomerA_DB > test2.sql
mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should be repaired when dumping table `wp_woocommerce_sessions` at row: 0
-
- Staff Member
- Posts: 54
- Joined: March 2nd, 2019, 2:40 am
Re: Backups partially completed due to errors in client databses
Hi MrIver,
Thank you for the additional information, may I suggest opening a ticket with us at support@jetapps.com so that our support technicians could have a further look into your issue and provide better assistance.
Thank You,
Anton, JetApps Team.
Thank you for the additional information, may I suggest opening a ticket with us at support@jetapps.com so that our support technicians could have a further look into your issue and provide better assistance.
Thank You,
Anton, JetApps Team.
Anton, JetApps Team
Re: Backups partially completed due to errors in client databses
Thanks - we have opened a ticket with you.