Windows10搭建本地mysql-yum源

以下操作可在wsl中进行

  1. 同步索引信息
  • mysql 8 
1
2
3
mkdir -p mysql8/repodata
cd mysql8/repodata
lftp "https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/repodata/" -e "mirror --verbose -P 5 --delete --only-missing; bye"
  • mysql 5.7
    1
    2
    3
    mkdir -p mysql57/repodata
    cd mysql57/repodata
    lftp "https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/repodata/" -e "mirror --verbose -P 5 --delete --only-missing; bye"
  1. 获取最新的版本号
  • mysql 8
1
mysql8_version=$(lftp https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/ -e "cls;bye" | grep -e "mysql-community-client.*.el7.x86_64.rpm" | sed -r 's/mysql-community-client-(.*).el7.x86_64.rpm/\1/g' | sort -rV |  xargs | awk -F ' ' '{print $1}')
  • mysql 5.7
1
mysql57_version=$(lftp https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/ -e "cls;bye" | grep -e "mysql-community-client.*.el7.x86_64.rpm" | sed -r 's/mysql-community-client-(.*).el7.x86_64.rpm/\1/g' | sort -rV |  xargs | awk -F ' ' '{print $1}')
  1. 在与repodata同级的目录下，下载各个依赖的rpm包
  • mysql 8
    1
    2
    3
    4
    5
    6
    7
    8
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-client-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-common-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-devel-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-embedded-compat-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-libs-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-libs-compat-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-server-${mysql8_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-test-${mysql8_version}.el7.x86_64.rpm
  • mysql 5.7
    1
    2
    3
    4
    5
    6
    7
    8
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-client-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-common-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-devel-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-embedded-compat-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-libs-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-libs-compat-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-server-${mysql57_version}.el7.x86_64.rpm
    curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-test-${mysql57_version}.el7.x86_64.rpm

  1. 在本地的windows上配置一个http服务器，将http路径指向刚刚操作的目录，

    我用的是Apache，参考配置：

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    Alias /mirrors/mysql8 "E:/linux/repo/mysql8"
    <Directory E:/linux/repo/mysql8>
        Options Indexes
    	IndexOptions NameWidth=25 Charset=UTF-8 
        AllowOverride All
        Require all granted
    </Directory>

    Alias /mirrors/mysql57 "E:/linux/repo/mysql57"
    <Directory E:/linux/repo/mysql57>
        Options Indexes
    	IndexOptions NameWidth=25 Charset=UTF-8 
        AllowOverride All
        Require all granted
    </Directory>

CentOS7虚拟机上yum源的配置

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
vim /etc/yum.repos.d/mysql-community.repo
# 粘贴如下内容
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-connectors-community-el7
enabled=1
gpgcheck=0

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-tools-community-el7
enabled=1
gpgcheck=0

[mysql57-community]
name=MySQL 5.7 Community Server
#baseurl=http://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7
baseurl=http://192.168.5.1/mirrors/mysql57/
enabled=0
gpgcheck=0

[mysql80-community]
name=MySQL 8.0 Community Server
#baseurl=http://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7
baseurl=http://192.168.5.1/mirrors/mysql8/
enabled=1
gpgcheck=0

自动同步脚本

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
#!/bin/bash
work_directory=$(pwd)

mysql_components=("client" "common" "devel" "embedded-compat" "libs" "libs-compat" "server" "test" )

# mysql8
mkdir -p ${work_directory}/mysql8/repodata
cd ${work_directory}/mysql8/repodata
lftp "https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/repodata/" -e "mirror --verbose -P 5 --delete --only-missing; bye"
cd ${work_directory}/mysql8
mysql8_version=$(lftp https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/ -e "cls;bye" | grep -e "mysql-community-client.*.el7.x86_64.rpm" | sed -r 's/mysql-community-client-(.*).el7.x86_64.rpm/\1/g' | sort -rV |  xargs | awk -F ' ' '{print $1}')

for mysql_component in ${mysql_components[@]};do

if [ -a "mysql-community-${mysql_component}-${mysql8_version}.el7.x86_64.rpm" ];then
echo "mysql-community-${mysql_component}-${mysql8_version}.el7.x86_64.rpm 已存在,跳过";
else
curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-${mysql_component}-${mysql8_version}.el7.x86_64.rpm
fi

done


# mysql5.7
mkdir -p ${work_directory}/mysql57/repodata
cd ${work_directory}/mysql57/repodata
lftp "https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/repodata/" -e "mirror --verbose -P 5 --delete --only-missing; bye"
cd ${work_directory}/mysql57
mysql57_version=$(lftp https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/ -e "cls;bye" | grep -e "mysql-community-client.*.el7.x86_64.rpm" | sed -r 's/mysql-community-client-(.*).el7.x86_64.rpm/\1/g' | sort -rV |  xargs | awk -F ' ' '{print $1}')


for mysql_component in ${mysql_components[@]};do

if [ -a "mysql-community-${mysql_component}-${mysql57_version}.el7.x86_64.rpm" ];then
echo "mysql-community-${mysql_component}-${mysql57_version}.el7.x86_64.rpm 已存在,跳过";
else
curl -O https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/mysql-community-${mysql_component}-${mysql57_version}.el7.x86_64.rpm
fi

done

扫一扫，分享到微信

微信分享二维码
本站总访问量:

tag:

animation:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true

很惭愧<br><br>只做了一点微小的工作<br>谢谢大家