Page 1 of 1

export database and repository from mysql 5.7 to mariadb 10.1 with openkm 6.3.0 version

Posted: Mon Jan 04, 2021 4:17 am
by jagritip
i am using openkm version 6.3.0 with mysql 5.7 in a server (lets say X).
Now i have to install openkm 6.3.0 on some other server (lets say Y) with mariadb 10.1.

How can i export all data and repository from server X with mysql 5.7 to server Y with mariadb 10.1.

pls differentiate database schema in mariadb 10.1 vs database schema in mysql5.7 for
openkm 6.3.0

Re: export database and repository from mysql 5.7 to mariadb 10.1 with openkm 6.3.0 version

Posted: Tue Jan 05, 2021 11:21 am
by jllort
Maybe this kind of questions should set in mariadb forum either here. I think database dump and standard SQL import execution should be enought.

Code: Select all

mysqldump -h localhost -u root okmdb > okmdb.sql
mysql -h localhost -u root okmdb < okmdb.sql