DROP DATABASE [IF EXISTS] When restoring Databases
We encounter a very strange MariaDB innodb failure and almost all databases where empty.
Jetbackup couldn't restore only Databases and queue was "partially completed" because of this.
Databased exists but only their names. With zero data. Just DB names.
A trigger to "DROP if DB exists" should be nice.
We had to select DBs and check which were empty, like that:
SELECT S.SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA S
LEFT OUTER JOIN INFORMATION_SCHEMA.TABLES T ON S.SCHEMA_NAME = T.TABLE_SCHEMA
WHERE T.TABLE_SCHEMA IS NULL;
and then DROP them. And after dropping them only then jetbackup could restore it.
There are already triggers like:
"terminate account before restore"
"merge backup data"
"suspend account after restore"
But nothing for Databases.
A "Drop if exists" should do the trick.
Hello Christos Panagiotakis,
Thank you for leaving your feedback and opening a feature request. We will be reviewing your request and provide updates accordingly. In the meantime, you can achieve this effect by downloading the preferred backup item and subsequently extracting the file into the account where you intend to store the files.
Best Regards,
The JetApps Team
Hello Christos Panagiotakis,
Thank you for leaving your feedback and opening a feature request. We will be reviewing your request and provide updates accordingly. In the meantime, you can achieve this effect by downloading the preferred backup item and subsequently extracting the file into the account where you intend to store the files.
Best Regards,
The JetApps Team
Hello there. For one or two accounts that's not an issue. But when I had to restore 300 accounts, 422 databases and ONLY databases -because of the InnoDB failure- , it was a pain... A big one.
P.S: So a "DROP if DB exists" or / and DROP if DB is empty (or both) would be nice addition.
Hello there. For one or two accounts that's not an issue. But when I had to restore 300 accounts, 422 databases and ONLY databases -because of the InnoDB failure- , it was a pain... A big one.
P.S: So a "DROP if DB exists" or / and DROP if DB is empty (or both) would be nice addition.
Replies have been locked on this page!