Page 1 of 1

Restoring from backup after converting to MariaDB

Posted: Tue Jun 27, 2023 11:43 pm
by ForrestGumpDDS
Hello,
I used to run OD on the MySQL and restoration/testing of backups was done by using MySQL Workbench.
Now, when I converted to MariaDB, I am not able to use Workbench any longer.
The reason I use my own backups is because I use an automated script that dumps the databases daily and organizes/rotates the backups.
What GUI tool is recommended for restoring from mariadb dumps?
Thank you

Re: Restoring from backup after converting to MariaDB

Posted: Tue Jul 18, 2023 10:37 am
by laitkor
Workbench works well. What error are you seeing?

Re: Restoring from backup after converting to MariaDB

Posted: Mon May 20, 2024 12:56 pm
by ForrestGumpDDS
The issue was that the Workbench was refusing to operate on the database giving me the error that the database version is not supported.
I spent hours trying to find a backup tool that supports the MariaDB and was wondering how is it at all possible that MariaDB wasn't supported by Workbench. Turned out that the solution was very simple. I needed to switch to a different driver to connect to Mariadb in the Workbench settings.
So, problem did not existed to begin with.
P.S. For some reason I'm not getting notifications and thus haven't checked replies in this topic since before you replied.