Page 1 of 1

MYSQL to MariaDB conversion

Posted: Mon Aug 30, 2021 4:33 am
by Tom Zaccaria
Anyone out there made the conversion from MYSQL to MariaDB that was not a new installation?
I did it over the weekend on a backup machine. Uses the file on the installation page. Fairly straight forward. One minor glitch overall. Took about an hour. Unless they can somehow speedup the process or I am missing something, it will take a lot of time to convert each workstation at the office.
Again, anyone out there tried this yet?

drtmz

Re: MYSQL to MariaDB conversion

Posted: Fri Sep 03, 2021 2:59 pm
by SriramChellappan
Are you using Middle tier? I am assuming with Middle tier the workstation upgrade shouldn't be that much.

Re: MYSQL to MariaDB conversion

Posted: Fri Sep 03, 2021 8:24 pm
by teethdood
I just ran the ODDbmsUpgrade tool on Windows server 2019 running MySQL 5.5. I got the following error:

09/03/21 20:21:33:801 #GetAllMySQL Error Code:201
Requested registry access is not allowed.
09/03/21 20:21:33:810 #DBMSProgram list is empty. Error Code:203
Services:
Programs:MySQL Server 5.5
09/03/21 20:21:33:811 #No DBMS services of type 'MariaDB' detected.
Please run this tool on the computer that has the DBMS service installed or contact support for assistance.

Re: MYSQL to MariaDB conversion

Posted: Sat Sep 04, 2021 3:50 am
by dqadri
Tom Zaccaria wrote: Mon Aug 30, 2021 4:33 am Anyone out there made the conversion from MYSQL to MariaDB that was not a new installation?
I did it over the weekend on a backup machine. Uses the file on the installation page. Fairly straight forward. One minor glitch overall. Took about an hour. Unless they can somehow speedup the process or I am missing something, it will take a lot of time to convert each workstation at the office.
Again, anyone out there tried this yet?

drtmz

Unless I'm not understanding what you are doing, you should only be doing this on your main server where the database is being hosted. Not on each workstation. The workstations should still be able to connect without any hiccups.

I did a conversion about two years ago.