MySQL to MariaDB.
Posted: 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:
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.
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 |
+-----------+
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.