[mySQL5.5] 03장. Upgrading from 5.1 to 5.5

n  Upgading MySQL from 5.1 to 5.5(Windows)

1. current version의 데이터베이스를 backup합니다.

C:\temp\work>mysqldump -uroot -proot --all-databases > backup.sql

 

2. Stop the Server

C:\temp\work>net stop MySQL

MySQL 서비스를 잘 멈추었습니다.

3. 최신 MySQL 을 Download합니다. http://dev.mysql.com/downloads/.
4. Uninstall MySQL Server
   -  MySQL Instance Configuration Wizard( MySQLInstanceConfig.exe)를 사용하여 Uninstall하는게 안전하다

(Instance를 stop하고 MySQL를 삭제합니다.)

-       프로그램 추가/제어에서 Binary도 Uninstall해야 합니다.

5. 5.5를 Install합니다.기존 설치디렉토리에 overwrite하는 것을 권장합니다.

6. MySQL Server를 시작합니다.

C:\temp\work>net start MySQL

 

7. mysql_upgrade를 실행합니다.

C:\>mysql_upgrade -uroot -proot --port=3306

현재 버전의 데이터베이스와 incompatibility를 점검한 후, system table을 upgrade합니다.

mysql_upgrade는 다음을 실행합니다.

mysqlcheck --check-upgrade --all-databases --auto-repair

mysql_fix_privilege_tables   // mysql 테이블에 대한 새로운 권한이나 feature를 추가한다.

 

Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe

Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlcheck.exe

Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306"

Running 'mysqlcheck' with connection arguments: "--port=3306" "--port=3306"

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.event                                        OK

mysql.func                                         OK

mysql.general_log                                  OK

mysql.help_category                                OK

mysql.help_keyword                                 OK

mysql.help_relation                                OK

mysql.help_topic                                   OK

mysql.host                                         OK

mysql.ndb_binlog_index                             OK

mysql.plugin                                       OK

mysql.proc                                         OK

mysql.procs_priv                                   OK

mysql.proxies_priv                                 OK

mysql.servers                                      OK

mysql.slow_log                                     OK

mysql.tables_priv                                  OK

mysql.time_zone                                    OK

mysql.time_zone_leap_second                        OK

mysql.time_zone_name                               OK

mysql.time_zone_transition                         OK

mysql.time_zone_transition_type                    OK

mysql.user                                         OK

Running 'mysql_fix_privilege_tables'...

OK

 

8. Restoring backup

C:\temp\work>mysql -uroot -proot < backup.sql