This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
upgrade_using_ius [2019/02/26 18:32] k2patel |
upgrade_using_ius [2019/02/26 18:34] k2patel [Finalize Upgrade] |
||
---|---|---|---|
Line 16: | Line 16: | ||
</code> | </code> | ||
- | <code ini | /etc/systemd/system/mariadb.service.d/limit.conf> | + | <code ini /etc/systemd/system/mariadb.service.d/limit.conf> |
[Service] | [Service] | ||
LimitNOFILE=320000 | LimitNOFILE=320000 | ||
</code> | </code> | ||
+ | ==== Start mariadb ==== | ||
<code bash> | <code bash> | ||
- | |||
- | |||
systemctl start mariadb | systemctl start mariadb | ||
- | mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair --write-binlog | + | </code> |
- | mysqlcheck --no-defaults --all-databases --fix-db-names --fix-table-names --write-binlog -p | + | |
+ | ==== Finalize Upgrade ==== | ||
+ | <code bash> | ||
mysqlcheck --no-defaults --check-upgrade --auto-repair --databases mysql -p | mysqlcheck --no-defaults --check-upgrade --auto-repair --databases mysql -p | ||
+ | mysqlcheck --no-defaults --check-upgrade --all-databases --auto-repair --write-binlog -p | ||
+ | mysqlcheck --no-defaults --all-databases --fix-db-names --fix-table-names --write-binlog -p | ||
mysql_upgrade | mysql_upgrade | ||
</code> | </code> |