Migrating mysql to Mariadb

1s440 · 10-23-2018, 02:20 AM

hello all,

I am using old Debian version(4) and MySQL version(5). Is it possible to Migrate from Mysql to Maria DB? I guess in the latest Debian versions it comes with Maria DB as default installation. Do I have to first do Patch upgradation? Please suggest

pan64 · 10-23-2018, 04:02 AM

that highly depends on the database you have. Without information there is no way to tell you anything. But if you wish I can guess: yes, it works.

What you can do is: check how to dump the old mysql database and how to import that into the new mariadb. Also you can look for general solutions on the net.

1s440 · 10-23-2018, 06:49 AM

Quote:

Originally Posted by pan64

that highly depends on the database you have. Without information there is no way to tell you anything. But if you wish I can guess: yes, it works.

What you can do is: check how to dump the old mysql database and how to import that into the new mariadb. Also you can look for general solutions on the net.

Thanks for your reply.

I am confused whether If I have to do patch upgradation first because from the latest versions of debian the default is MARIADB.

I would think if I can just a take a dump backup and then do patch upgradation and then import the database.

michaelk · 10-23-2018, 07:12 AM

You should not have to patch anything. mysqldump creates SQL statements of your old database that you can use to create and import your data into a new database. I don't use mysql so there could be some limitations or restrictions.

When upgrading to the latest debian from version 4 your going to have to install from scratch. Are you upgrading on the same or newer computer?

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

1s440 · 10-23-2018, 08:31 AM

Quote:

Originally Posted by michaelk

You should not have to patch anything. mysqldump creates SQL statements of your old database that you can use to create and import your data into a new database. I don't use mysql so there could be some limitations or restrictions.

When upgrading to the latest debian from version 4 your going to have to install from scratch. Are you upgrading on the same or newer computer?

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

Thanks for the reply.

I am upgrading on the same machine where the old version runs. so will there not be a problem if I do both the things at a time?

michaelk · 10-23-2018, 08:42 AM

debian 4 was released back in 2007, if your computer is that old it may struggle with running newer versions. Posting the hardware specifications would help. Being able to test your backup on mariadb before you delete your debian 4 would provide some confidence that everything works as expected.

1s440 · 10-24-2018, 02:41 AM

Quote:

Originally Posted by michaelk

debian 4 was released back in 2007, if your computer is that old it may struggle with running newer versions. Posting the hardware specifications would help. Being able to test your backup on mariadb before you delete your debian 4 would provide some confidence that everything works as expected.

Thanks for the reply. But I am afraid that I am using Vmware for all the OS installations

pan64 · 10-24-2018, 04:49 AM

Quote:

Originally Posted by 1s440

Thanks for the reply. But I am afraid that I am using Vmware for all the OS installations

I don't think it is really important. Or how is it related to the original question? But anyway you can create a new VM (or save the old one) before proceeding. If everything works as expected you can drop the old, saved VM, otherwise you can start over again.