How to transfer mariadb to another server?

Question

MySQL

Hello.
How can I move the database to another server?
There are only data files from /var/lib/mysql
When replacing this folder on the new server with the old one, mariadb refuses to start. There is nothing in the logs.

Answer 1

1) Check file permissions chown -R mysql:mysql /var/lib/mysql
2) Transferring files is not the best idea

Answer 2

Did you feed the same configuration as on the old server? If not, then do it if possible. I won’t say for mariadb, but mysql didn’t start, for example, if innodb_log_file_size in the config did not match the actual size.

Answer 3

The log should always be there, look where it goes in the config, check all the rights to it.