linuxstory/mariadb repository overview

$ mkdir DBdata
$ sudo docker run -dt --rm --name wp_mariadb \
 -v $PWD/DBdata:/var/lib/mysql \
 -v $PWD/Files:/Files linuxstory/mariadb:myrocks entrypoint.sh --init

$ mysqldump --default-character-set=utf8 -u <user_name> -p <db_name> > ~/backup.sql

$ sed -i 's/ENGINE=InnoDB/ENGINE=RocksDB/g' ~/backup.sql
$ sed -i 's/ENGINE=MyISAM/ENGINE=RocksDB/g' ~/backup.sql

$ mkdir DBdata Files
$ rsync -r -a -v -e ssh --delete [email protected]:/home/remoteuser/backup.sql $PWD/Files/backup.sql
$ sudo docker run -dt --rm --name wp_mariadb \
 -v $PWD/DBdata:/var/lib/mysql \
 -v $PWD/Files:/Files linuxstory/mariadb:myrocks entrypoint.sh --init

$ sudo docker exec -it `sudo docker ps | awk '/wp_mariadb/{print $1}'` /bin/bash
# mysql
mysql> CREATE DATABASE db_name;
mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'user_name'@'%' IDENTIFIED BY 'user_password';
mysql> FLUSH PRIVILEGES;
mysql> USE db_name;
mysql> SOURCE /Files/backup.sql;