Bugzilla – Bug 156185
Please add MySQL 5.0 upgrade release notes
Last modified: 2006-03-24 16:08:37 UTC
Could you please add a note to the release notes about upgrading from previous versions of MySQL to MySQL 5.0? As with every major release upgrade it is strongly recommended to perform a backup of the MySQL table files and creating an SQL dump beforehand. After the update, mysql_fix_privilege_tables should be executed. Please see and refer to http://dev.mysql.com/doc/refman/5.0/en/upgrade.html for further info and instructions. Let me know, if you have any questions or need additional input. Thanks!
Thanks Lenz, sounds reasonable. For PostgreSQL, we have some such alert even in the manual. Setting to needinfo for approval.
Ok.
I'll add this section: <!-- Bug 156185 --> <sect3 status="2006-03-10" id="mysql-update"> <title>Updating to MySQL 5.0</title> <para>&suselinux; comes with MySQL 5.0. As with every major release update, it is strongly recommended to perform a backup of the MySQL table files and create an SQL dump beforehand. After the update, execute <command>mysql_fix_privilege_tables</command>. Refer to http://dev.mysql.com/doc/refman/5.0/en/upgrade.html for more information and detailed instructions. </para> </sect3>
Looks good to me, Karl. Thanks a lot!
With Rebeccas help :-) Now submitted to /work
fixed
for the records: if you just keep your MySQL databases, /etc/init.d/mysql will take care of running mysql_fix_privilege_tables. This won't work if you restore the mysql table from a dump, of course. One little thing on wording: "create _a_ SQL dump" (not: "_an_ SQL dump")
Lenz, please comment on the first part. Yes, it is "an SQL dump" - my bad, I applied Rebecca's corrections only partially.
I've looked at the proposed init script that was attached to BUG#146739 - looks good to me. So it seems as if an update should perform just fine. However, I'd still would like to recomment to take an SQL dump of the databases before updating - just in case. So please keep the note, but modify the last sentence that talks about running mysql_fix_privilege_tables manually (point out that is being run automatically instead). Thanks!
Sorry, forgot to change the bug status...
Thanks, good explanation. I'll submit the following version: <!-- Bug 156185 --> <sect3 status="2006-03-21" id="mysql-update"> <title>Updating to MySQL 5.0</title> <para>&suselinux; comes with MySQL 5.0. As with every major release update, it is strongly recommended to perform a backup of the MySQL table files and create an SQL dump beforehand. After the update, <filename>/etc/init.d/mysql</filename> automatically executes <command>mysql_fix_privilege_tables</command>. Refer to http://dev.mysql.com/doc/refman/5.0/en/upgrade.html for more information and detailed instructions. </para> </sect3>
->/work