Comments - Migrating MySQL 5.5 Windows to MariaDB 10.x on new Windows server

9 years, 2 months ago David Gonsalves

Thanks for the help, I was able to pretty easily do a test install on one of our dev machines. A couple of minor hiccups that were easily worked around (since I only migrated a single database, I had to put "use [databasename] in the top of .5gb file, but I've since found workarounds for that too). The install of both MySQL & the subsequent upgrade to MariaDB went very well. I've pointed my application toward the new database (in debug), and there are definite improvements in query speed. Our IT guy seems satisfied that even if something goes wrong we can easily get MySQL back up and running. I'm going to write a script to back up our entire MySQL database so we can do the migration to MariaDB for our production server with a fallback should something go wrong. Based on my experience this morning, I don't expect that to be a problem.

Thanks again.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.