Page 1 of 1

Error Backup - Failed to prepare database

Posted: Wed 15. Oct 2025, 11:28
by kurgans
Good morning,

I am attaching the information you requested. I see that the other thread is closed and I cannot follow it.

The system is Debian 12, which has just been installed, and everything is default when we install the panel. Server version: 10.11.14-MariaDB-0+deb12u2 Debian 12

The panel version is the latest, as it has only been installed a few days ago.
Keyhelp - Version 25.2 (Build 3483)

@Alexander, regarding what you mentioned, I also checked the tables and there is no difference between them and other tables with the same views. I am attaching a fragment in a txt file so as not to make the thread too long.

And regarding the warnings, it does not indicate anything.

SHOW WARNINGS;
Empty set (0.000 sec)

A script I created via ssh performs the backups without any problems and without any modifiers.

echo $DB
mysqldump -u root -p$MYSQL_PASSWORD $DB > “$BACKUP_DIR/base-pre-$DATE.sql”

Thank you again for your interest.

Re: Error Backup - Failed to prepare database

Posted: Wed 15. Oct 2025, 14:38
by Alexander
Hello,

can you perform the mysqldump again, but this time use the following command (i added 3 additional parameters):

Code: Select all

mysqldump -u root  -p$MYSQL_PASSWORD --routines --skip-lock-tables --databases $DB > “$BACKUP_DIR/base-pre-$DATE.sql”

Re: Error Backup - Failed to prepare database

Posted: Wed 15. Oct 2025, 14:50
by kurgans
Good afternoon,

If those are the default modifiers I have in the SSH script and they work perfectly with the SQL dumps,

...

728330234 Oct 15 14:43 db-pre-15-10-2025.sql
...

I removed the modifiers to post them on the forum so that it would be a command without any parameters.

But they both work the same with or without modifier parameters.

...

728329930 Oct 15 14:47 basesin-pre-15-10-2025.sql

...

Thank you for your interest and help.

Re: Error Backup - Failed to prepare database

Posted: Wed 15. Oct 2025, 15:05
by Alexander
Is it possible that I can take a look on the server itself?
If so, please activate support access ("Configuration -> Support Access") and send me the server IP address (and your SSH port, if it is not 22)

Re: Error Backup - Failed to prepare database

Posted: Wed 15. Oct 2025, 15:35
by kurgans
Yes, there is no problem with you accessing the system.

You have the IP address in a private message.

Thank you for your interest.

Re: Error Backup - Failed to prepare database  [SOLVED]

Posted: Thu 16. Oct 2025, 11:11
by Alexander
Thank you!

The issue is now fixed on kurgans system and will be fixed for all of you with the upcoming update.

I was able to make two improvements from this issue - thank you very much for sharing it and letting me take a look at your server.

Re: Error Backup - Failed to prepare database

Posted: Thu 16. Oct 2025, 11:43
by kurgans
No... all my thanks to you (all of you) for your time and interest.

And even better... if it's something you can share with everyone in an improvement to the panel.

S2