Linux安装MySQL&数据迁移

	# 下载通用版本
   54  2022-05-29 20:04:17 root wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

	# 0. 准备操作 [创建用户组\用户\分配权限\安装依赖]
   11  2022-05-29 20:28:27 root tar zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz 
   12  2022-05-29 20:31:17 root mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql
   13  2022-05-29 20:31:39 root cd /usr/local/mysql/
   15  2022-05-29 20:31:47 root mkdir data
   16  2022-05-29 20:31:54 root groupadd mysql
   18  2022-05-29 20:32:18 root useradd -r -g mysql mysql
   19  2022-05-29 20:32:21 root ls
   20  2022-05-29 20:32:29 root chown -R mysql:mysql /usr/local/mysql
   21  2022-05-29 20:32:32 root chmod -R 755 /usr/local/mysql
   24  2022-05-29 20:33:17 root yum install -y libaio


	# 1. 初始化数据库
   22  2022-05-29 20:32:36 root cd /usr/local/mysql/bin
   23  2022-05-29 20:32:42 root ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

   26  2022-05-29 20:33:47 root cd ../
   28  2022-05-29 20:33:59 root support-files/mysql.server start
   29  2022-05-29 20:34:12 root cat /etc/my.cnf
   # 1.0 把没用的配置信息注释掉, 见附录 1. 
   30  2022-05-29 20:34:18 root vim /etc/my.cnf

   31  2022-05-29 20:34:46 root support-files/mysql.server start
   # 启动
   42  2022-05-29 20:35:23 root service mysql restart
   43  2022-05-29 20:35:37 root ps -ef|grep mysqld

   ## 8、添加软连接，并重启mysql服务 [参考原文 1. ]
   45  2022-05-29 20:35:49 root ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql 
   46  2022-05-29 20:35:50 root ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
   47  2022-05-29 20:35:54 root service mysql restart

   55  2022-05-29 20:38:50 root mysql -uroot -p
   56  2022-05-29 20:39:17 root service status mysql

   
  ## 11、设置开机自启 [参考原文 1. ]
   59  2022-05-29 20:39:45 root cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
   60  2022-05-29 20:39:50 root chmod +x /etc/init.d/mysqld
   61  2022-05-29 20:39:53 root chkconfig --add mysqld
   62  2022-05-29 20:39:55 root reboot


   63  2022-05-29 20:40:30 root service mysql start 
   64  2022-05-29 20:40:38 root service mysql status
   65  2022-05-29 20:40:46 root mysql -uroot -p



	## 数据迁移 [停止数据库\创建新文件路径\拷贝数据文件\修改配置文件\启动...排查错误]
   67  2022-05-29 20:51:45 root service mysql stop;
   68  2022-05-29 20:52:14 root mkdir /home/mysql/data
   69  2022-05-29 20:52:19 root mkdir -p /home/mysql/data
   70  2022-05-29 20:52:31 root chown -R mysql:mysql /home/mysql/data
   71  2022-05-29 20:52:59 root cp -R /usr/local/mysql/data /home/mysql/data


	## 排错过程
   72  2022-05-29 20:53:13 root vim /etc/my.cnf
   73  2022-05-29 20:54:02 root service mysql start
   74  2022-05-29 20:54:13 root cat /home/mysql/data/hecs-341880.err

  109  2022-05-29 21:00:06 root service mysql start
  110  2022-05-29 21:00:40 root cat /home/mysql/data/hecs-341880.err


  ## 配置文件见 附录2 
  122  2022-05-29 21:03:30 root vim /etc/my.cnf
  129  2022-05-29 21:05:53 root service mysql start
  130  2022-05-29 21:05:59 root cat /home/mysql/data/data/hecs-341880.err
  133  2022-05-29 21:06:17 root mysql -uroot -p

  135  2022-05-29 21:07:13 root vim /etc/my.cnf
  136  2022-05-29 21:07:21 root service mysql start
  138  2022-05-29 21:07:34 root service mysql restart
  139  2022-05-29 21:07:54 root pwd
  140  2022-05-29 21:08:00 root ps -ef | grep mysql
  141  2022-05-29 21:08:06 root vim /etc/my.cnf

  143  2022-05-29 21:08:25 root service mysql stop
  144  2022-05-29 21:08:35 root vim /etc/my.cnf
  145  2022-05-29 21:08:43 root service mysql start
  146  2022-05-29 21:08:49 root mysql -uroot -p

参考内容

1. Linux下安装mysql

附录

1. 初始化数据

[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

#socket=/home/mysql/data/mysql.sock
#datadir=/home/mysql/data/data

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
#!includedir /etc/my.cnf.d

2. 配置文件

[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock

socket=/home/mysql/data/mysql.sock
datadir=/home/mysql/data/data

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
#!includedir /etc/my.cnf.d