http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [
The Japanese government should apologize to Japanese Military Sexual Slavery victim.
/ ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª. ]
»ç¿ëÀÚ
ID:
PW:
INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [69]
02.File Book
File ÀÚ·á½Ç [95]
Site Link [18]
°³ÀÎÆú´õ [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
±âŸÁ¤º¸ [150]
¿î¿µÃ¼Á¦ [577]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]
±â³äÀÏ
Search
LINK
+
°¡Á· Hompy
+
DNS
Ever
IOTN :: Work Book :: MySQL
ȸ¿ø°¡ÀÔ
mysql_upgrade mariadb 10.1 to 10.2
ÃÖ±æÈ£
[LIST]
2019-07-24 22:33:51, Á¶È¸ :
417
https://phiz.kr/tip/7163
1. MariaDB repo ¸¦ 10.1 ¿¡¼ 10.2·Î º¯°æÇÑ´Ù.
ÂüÁ¶ :
http://downloads.mariadb.org/mariadb/repositories/
2. Set innodb_fast_shutdown to 0 ( MariaDB 10.2.5 ¶Ç´Â ±× ÀÌÈÄ ¹öÀüÀÏ ¶§¿¡´Â ÇÊ¿ä¾øÀ½.)
mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
3. Shutdown MariaDB 10.1,
systemctl stop mariadb.service
¶Ç´Â
mysqladmin -u root -p shutdown
4. µ¥ÀÌŸº£À̽º backup (¹é¾÷Àº ¸¸ÀÏÀÇ °æ¿ì¿¡ ´ëºñÇÏ´Â °ÍÀÌ´Ù. ¹Ýµå½Ã ¼öÇàÇÑ´Ù. ¾÷±×·¹À̵å°úÁ¤ÀÌ ¼øÁ¶·Ó°Ô ³¡³´Ù¸é ¹é¾÷ÆÄÀÏÀ» »ç¿ëÇÒ ÀÏÀº ¾ø´Ù.)
mysqldump -uroot -p -A > all.sql
5. Uninstall MariaDB 10.1
yum remove MariaDB-service MariaDB-client
ÇÊ¿äÇÑ °æ¿ì /etc/my.cnf ¸¦ ¹é¾÷ÇØ µÐ´Ù.
6. Install MariaDB 10.2
yum install MariaDB-service MariaDB-client
7. MariaDB ½ÇÇà
systemctl start mariadb.service
systemctl enable mariadb.service
8. mysql_upgrade ½ÇÇà
mysql_upgrade -uroot -p
shell> ./mysql_upgrade -uroot -p --datadir=/home/data
(MysqlÀÌ ½ÇÇàµÇ¾î ÀÖ´Â »óÅ¿¡¼ ½ÇÇà)
shell> ./mysqlcheck --check-upgrade --all-databases --auto-repair
9. À̶§
MariaDB-common
MariaDB-shared
´Â ¾ÆÁ÷µµ 10.1 ÀÌ´Ù.
yum update¸¦ Çϸé 10.2 ·Î ¾÷µ¥ÀÌÆ®µÇ°í Ãß°¡·Î
MariaDB-compat °¡ ¼³Ä¡µÈ´Ù.
LIST
Copyright 1999-2022
Zeroboard
/ skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2008/12/15
MySQLÀÌ ¾ÈÁÁÀº°Ç°¡? Àå¾Öµµ ½±°Ô ³ª°í,...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by ÃÖ±æÈ£
06/25
[ORACLE]
Replication may not be valid i....
by ÃÖ±æÈ£
06/22
[¿î¿µÃ¼Á¦]
CentOS7 ȨÆäÀÌÁö Migration ¸Þ¸ð.
by ÃÖ±æÈ£