[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / êꪤҳàõªòàõªÎÒ¿Ö˪˪·ª¿ð¨ÏÐñ«ëùìíÜâÏÚªÎ?ð¤àõªòÍëãÒªËìãªá¡¢Þóñªª·ªÊª±ªìªÐªÊªéªÊª¤. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [72]
02.File Book
File ÀÚ·á½Ç [96]
Site Link [14]
°³ÀÎÆú´õ [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3206]
PSQL [143]
CUBRID [5]
±âŸÁ¤º¸ [194]
¿î¿µÃ¼Á¦ [634]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]

±â³äÀÏ
Search
LINK
+ °¡Á· Hompy
+ DNSEver
IOTN :: Work Book :: MySQL

 È¸¿ø°¡ÀÔ

mysql_upgrade mariadb 10.1 to 10.2
ÃÖ±æÈ£ [LIST]   2019-07-24 22:33:51, Á¶È¸ : 507

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-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2008/12/15
MySQLÀÌ ¾ÈÁÁÀº°Ç°¡? Àå¾Öµµ ½±°Ô ³ª°í,...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
07/03
[ORACLE]
create type ORA-39083 ORA-0230....
by ÃÖ±æÈ£
07/03
[ORACLE]
sms recovery check ORA-00278 ....
by ÃÖ±æÈ£
07/02
[¿î¿µÃ¼Á¦]
rsync -auv.
by ÃÖ±æÈ£