dbsake icon indicating copy to clipboard operation
dbsake copied to clipboard

mysql_upgrade command

Open abg opened this issue 10 years ago • 0 comments

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.

abg avatar Mar 14 '14 18:03 abg