MySQL to MariaDB.

Issues related to applications and software problems
Post Reply
hack3rcon
Posts: 362
Joined: 2014/11/24 11:04:37

MySQL to MariaDB.

Post by hack3rcon » 2019/05/18 11:03:06

Hello.
On an old CentOS server, I have a MySQL and on a new CentOS server, I installed MariaDB. On old server my DB are:

Code: Select all

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| livezilla          |
| mysql              |
| performance_schema |
| store              |
| temp               |
| test               |
+--------------------+


mysql> select user from mysql.user;
+-----------+
| user      |
+-----------+
| jason   |
| root      |
| jason   |
| jason   |
| root      |
| livezilla |
| magento   |
| root      |
+-----------+
It is a web server with "Magento" CMS. I want to migration my old CentOS to a new one. How can I create a backup from my DB and is it possible to export MySQL to MariaDB?
On old CentOS, the username is "jason" and on new CentOS, the username is "john", Can it cause any problem? In "mysql.user", the "jason" username created automatically or by system administrator?

Thank you.

User avatar
TrevorH
Forum Moderator
Posts: 25553
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: MySQL to MariaDB.

Post by TrevorH » 2019/05/18 11:39:50

man mysqldump
CentOS 5 died in March 2017 - migrate NOW!
Full time Geek, part time moderator. Use the FAQ Luke

hack3rcon
Posts: 362
Joined: 2014/11/24 11:04:37

Re: MySQL to MariaDB.

Post by hack3rcon » 2019/05/18 19:58:40

TrevorH wrote:
2019/05/18 11:39:50
man mysqldump
Thanks, but how about usernames?

hunter86_bg
Posts: 1740
Joined: 2015/02/17 15:14:33
Location: Bulgaria
Contact:

Re: MySQL to MariaDB.

Post by hunter86_bg » 2019/05/19 10:40:50

Just try with full dump & restore.

Post Reply