kylin4.0.2和ubuntu 16.04 下的数据库移植到硬盘过程
-
环境描述
操作系统:Linux Node3 4.4.58-20190329.kylin.x86-generic
数据库版本:mysql Ver 14.14 Distrib 5.7.29, for Linux (x86_64) using EditLine wrapper
硬盘:Disk /dev/nvme0n1: 3.7 TiB, 4000787030016 bytes, 7814037168 sectors -
准备
安装数据库:运行脚本
install.sh
进行安装mysql,安装成功后执行命令mysql -V
查看版本;执行命令mysql -u root -p
然后输入mysql密码,进入数据库;然后执行mysql命令查看数据存放位置:mysql>show variables like '%dir%'
;执行结果如图:
硬盘分区:执行linux命令fdisk -l
查看磁盘挂载情况,我关心的部分如下:
Disk /dev/nvme0n1: 3.7 TiB, 4000787030016 bytes, 7814037168 sectors
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
明显看出,这有一块4TiB的硬盘,将硬盘分区,然后挂载。执行命令fdisk /dev/nvme0n1
,
root@Node3:~# fdisk /dev/nvme0n1
Welcome to fdisk (util-linux 2.27.1).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write</