2.11.1 Mysql 升级 Upgrade Methods

1.升级方法

2.升级路径

Upgrade within a
release series is supported

3.开始之前

In-Place Upgrade

To perform an in-place
upgrade:

mysql -u root -p
–execute=”SET GLOBAL innodb_fast_shutdown=0“

With
a slow shutdown, InnoDB performs a full purge and change buffer merge before
shutting down, which ensures that data files are fully prepared in case of file
format differences between releases.

Run mysql_upgrade. For example:

mysql_upgrade -u root -p

Note
mysql_upgrade does not upgrade the contents
of the help tables. For upgrade instructions, see Section5.1.11,
“Server-Side Help”.

mysqladmin -u root -p
shutdown
mysqld_safe –user=mysql –datadir=/path/to/existing-datadir

Logical Upgrade

Note
Use the –routines and –events options with mysqldump (as
shown above) if your databases include stored programs. The –all-databases option includes all
databases in the dump, including the mysql database that holds the system tables.
Important
If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. The mysqldump utility provided in earlier releases uses incorrect syntax for generated column
definitions (Bug #20769542). You can use the INFORMATION_SCHEMA.COLUMNS table to
identify tables with generated columns.

Copy the temporary ‘root’@’localhost’ password displayed to your screen or written to your error log for
later use.

shell> mysql
-u root -p
Enter password: ****

mysql> ALTER
USER USER() IDENTIFIED BY ‘your new password‘;

mysql -u root -p –force

Note
It is not recommended to load a dump file when GTIDs are enabled on the server
(gtid_mode=ON), if your dump file
includes system tables. mysqldump issues DML instructions for the system tables which use the non-transactional
MyISAM storage engine, and this combination is not permitted when GTIDs are
enabled. Also be aware that loading a dump file from a server with GTIDs
enabled, into another server with GTIDs enabled, causes different transaction
identifiers to be generated.

mysql_upgrade examines all tables in all databases for incompatibilities with the current
version of MySQL. mysql_upgrade also upgrades the mysql system
database so that you can take advantage of new privileges or capabilities.
Note
mysql_upgrade does not upgrade the contents of the help tables. For upgrade instructions, see Section5.1.11, “Server-Side Help”.

mysqladmin -u
root -p shutdown
mysqld_safe –user=mysql –datadir=/path/to/5.7-datadir

Upgra开发云主机域名de Troubleshooting

相关推荐: 一次差异备份拿shell过程

扫描器扫到了某个网站存在目录浏览，于是便有了本文。。。知识点科普：目录浏览在我个人看来是危害较大的一个漏洞，该漏洞是指“在没有默认文档的目录下，列出该目录下所有文件名及文件信息”，如果站点存在这种错误配置，***者如果知道其中目录名，则可以查看到这些目录下的文…