Omicscloud配置

数据库导入

mariadb数据库

安装：

sudo apt update

sudo apt install mariadb-server mariadb-client -y

安装后启动：

sudo systemctl start mariadb

sudo systemctl status mariadb

数据库导入

记得改cd文件夹名称或数据库名称。

cd /stor2/db_bk_20260324 && \
sudo mariadb -e "CREATE DATABASE IF NOT EXISTS fasta_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE DATABASE IF NOT EXISTS idmapping CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE DATABASE IF NOT EXISTS kegg_mtable CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE DATABASE IF NOT EXISTS omicscloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE DATABASE IF NOT EXISTS speciesdb_info CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE DATABASE IF NOT EXISTS userdb CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;" && \
sudo mariadb fasta_db < fasta_db_dump_20260324.sql && \
sudo mariadb idmapping < idmapping_dump_20260324.sql && \
sudo mariadb kegg_mtable < kegg_mtable_dump_20260324.sql && \
sudo mariadb omicscloud < omicscloud_db_dump_20260324.sql && \
sudo mariadb speciesdb_info < speciesdb_info_dump_20260324.sql && \
sudo mariadb userdb < userdb_dump_20260324.sql

导完后检查一下：

sudo mariadb -e "SHOW DATABASES;"