1

mysqldump -h [hostname] -u [username] -p --port=[port] [databasename] --no-data > init.sql

1

mysqldump -h [hostname] -u [username] -p --port=[port] --no-data --all-databases > init.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

-- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
--
-- Host: 192.168.10.116    Database: test
-- ------------------------------------------------------
-- Server version	8.0.38
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `foobar_info`
--
CREATE DATABASE IF NOT EXISTS test;
USE test;
DROP TABLE IF EXISTS `foobar_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `foobar_info` (
  `id` char(32) NOT NULL,
  `model` varchar(128) NOT NULL,
  `desc` varchar(256) DEFAULT NULL,
  `lat` decimal(16,12) NOT NULL,
  `lon` decimal(16,12) NOT NULL,
  `alt` decimal(16,12) NOT NULL,
  `project_id` int NOT NULL,
  `time` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT 'VARCHAR(256)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

1
2

CREATE USER 'username'@'%' IDENTIFIED BY 'passwd';
GRANT ALL PRIVILEGES ON test.* TO 'username'@'%';

1
2
3
4
5
6
7
8

# 使用官方 MySQL 8.0.38 版本作为基础镜像
FROM mysql:8.0.38
# 设置时区
ENV TZ=Asia/Shanghai
# 将初始化脚本复制到容器中
COPY init.sql /docker-entrypoint-initdb.d/

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

services:
  mongodb:
    build:
      dockerfile: Dockerfile
    container_name: mysql8
    ports:
      - "33306:3306"
    restart: always
    environment:
      - TZ=Asia/Shanghai
      - SET_CONTAINER_TIMEZONE=true
      - CONTAINER_TIMEZONE=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - /data/mysql/data:/var/lib/mysql
      - /data/mysql/conf:/etc/mysql/conf.d
      - /data/mysql/log:/var/log
      - /data/mysql/share:/share

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46

#!/bin/bash

# 检查当前用户是否是root
if [ "$(id -u)" -ne 0 ]; then
   echo "此脚本需要以root用户运行，请使用sudo运行此脚本。"
   exit 1
fi

# 定义一个函数 create_dir_if_not_exists
create_dir_if_not_exists() {
  local dir_path="$1"
  # 检查目录是否存在
  if [ ! -d "$dir_path" ]; then
    # 如果不存在，则创建目录
    mkdir -p "$dir_path"
    echo "目录 '$dir_path' 已创建。"
  else
    # 如果存在，则打印消息并跳过创建
    echo "目录 '$dir_path' 已存在，无需创建。"
  fi
}
make_mysql_dirs(){
   local root_dir="$1"
   local data_dir=$root_dir"/data"
   create_dir_if_not_exists $data_dir
   local conf_dir=$root_dir"/conf"
   create_dir_if_not_exists $conf_dir
   local share_dir=$root_dir"/share"
   create_dir_if_not_exists $share_dir
   local log_dir=$root_dir"/log"
   create_dir_if_not_exists $log_dir
}

# 使用函数创建目录
make_mysql_dirs /data/mysql
echo "Shanghai 时区同步"
sudo ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
echo "同步时钟"
sudo hwclock --systohc

# 启动容器
docker-compose -f docker-compose.yml up -d

1

sudo ./mysql_deploy.sh