MySQL to MariaDB.

Issues related to applications and software problems
Post Reply
hack3rcon
Posts: 757
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
Site Admin
Posts: 33202
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
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

hack3rcon
Posts: 757
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: 2019
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