Restoring from backup after converting to MariaDB

For users or potential users.
Post Reply
ForrestGumpDDS
Posts: 179
Joined: Fri Oct 14, 2011 3:31 pm

Restoring from backup after converting to MariaDB

Post by ForrestGumpDDS » Tue Jun 27, 2023 11:43 pm

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

laitkor
Posts: 2
Joined: Tue Jul 18, 2023 10:35 am

Re: Restoring from backup after converting to MariaDB

Post by laitkor » Tue Jul 18, 2023 10:37 am

Workbench works well. What error are you seeing?

ForrestGumpDDS
Posts: 179
Joined: Fri Oct 14, 2011 3:31 pm

Re: Restoring from backup after converting to MariaDB

Post by ForrestGumpDDS » Mon May 20, 2024 12:56 pm

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.

Post Reply