Monday, October 31, 2011

Don't forget to mysql_upgrade

I recently upgraded MySQL to the DMR release of 5.6.3.  Available here :http://dev.mysql.com/downloads/mysql/5.6.html#downloads 
I was reminded of a some questions about mysql_upgrade I have gotten lately. While it is easy to skip, do not forget to run
/usr/bin/mysql_upgrade  after you upgrade.

Yes it is typical to see clean tables.

Simple example:
employees.departments                              OK
employees.dept_emp                                 OK
employees.dept_manager                             OK
employees.employees                                OK
employees.salaries                                 OK
employees.titles                                   OK

I do not want to repeat what others have said so more on mysql_upgrade can be found by these community posts if needed:
http://nilinfobin.com/2011/08/how-to-use-mysql_upgrade-script/
http://www.mysqlperformanceblog.com/2010/05/14/mysql_upgrade-and-innodb-tables/