Telegram - ?

MySQL

, !

3

MySQL MariaDB . , Linux , . !

MySQL Migration

, , MySQL . :

mysql -V

, (, df).


MySQL

! data .

mysql mariadb, systemctl:

# systemctl stop mariadb

# systemctl stop mysql

MySQL mysqldump:

# mysqldump -u 
[user] -p --all-databases > all_databases.sql

, :

# mysqldump -u root -p --opt [database name] > database_name.sql

MySQL

scp, . .

# scp all_databases.sql user@merionet.ru:~/      	 [ ]
# scp database_name.sql user@merionet.ru:~/      	 [ ]

MySQL

, MySQL.

# mysql -u [user] -p --all-databases < all_databases.sql   [All Databases]
# mysql -u [user] -p newdatabase < database_name.sql      [Singe Database]

:

# mysql -u user -p
# show databases;

MySQL

MySQL, , , rsync. mysql mariadb .

# rsync -avz /var/lib/mysql/* user@merionet.ru:/var/lib/mysql/

, mysql mariadb mysql. , .

# chown mysql:mysql -R /var/lib/mysql/
# ls  -l /var/lib/mysql/

! .


?


: