MariaDB升级到10.1.22，mariadb升级10.1.22

MariaDB升级到10.1.22，mariadb升级10.1.22

yum -y install cmake 安装 cmake 工具 执行 cmake 命令进行编译 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DMYSQL_DATADIR=/var/data/mariadb -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_EXTRA_CHARSETS=1 -DWITH_SSL=bundled -DWITH_ZLIB=bundled 报错信息： cc: internal compiler error: Killed (program cc1) 或者 g++: internal compiler error: Killed (program cc1plus) Please submit a full bug report,   主要原因大体上是因为内存不足,有点坑 临时使用交换分区来解决吧 创建 swap 交换分区 dd if=/dev/zero of=/swapfile bs=64M count=16 mkswap /swapfile swapon /swapfile 下面是执行 make 命令过程中内存使用情况 结束后可以关闭交换分区 swapoff /swapfile rm /swapfile 初始化数据库（进入到scripts目录下） ./mysql_install_db --user=mysql --basedir=/usr/local/mariadb --datadir=/var/data/mariadb 下面是初始化完成后提示的信息： To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands:
'/usr/local/mariadb/bin/mysqladmin' -u root password 'new-password' '/usr/local/mariadb/bin/mysqladmin' -u root -h iZ287rk6ob4Z password 'new-password'
Alternatively you can run: '/usr/local/mariadb/bin/mysql_secure_installation'
which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions.
You can start the MariaDB daemon with: cd '/usr/local/mariadb' ; /usr/local/mariadb/bin/mysqld_safe --datadir='/var/data/mariadb'
You can test the MariaDB daemon with mysql-test-run.pl cd '/usr/local/mariadb/mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/
启动数据库 将 support-files 下的 my.small.cnf 复制到 /etc/ 下改名为 my.cnf，并修改相应的配置信息 ./bin/mysqld --user=mysql 修改 root 密码 ./bin/mysqladmin -u root password 'new-password' 恢复备份，下面两步需要登录 MySQL 导入备份数据 source back.sql; 刷新权限 flush privileges;