dbsake
dbsake copied to clipboard
mysql_upgrade command
I would like a mysql_upgrade command that can automate reimporting views and triggers as utf8 (possibly parameterized $charset).
Additionally it would be nice if I could specify rebuilding tables to force them into the current major version format. (i.e. tables whose .frm's mysql_version is particularly old). I recently ran into a few 5.6 bugs where simply rebuilding a 5.0 based table resolved the issue. mysql_upgrade otherwise skipped these tables as they weren't using an offending character set.