Bug 156185

Summary:	Please add MySQL 5.0 upgrade release notes
Product:	[openSUSE] SUSE Linux 10.1	Reporter:	Lenz Grimmer <lgrimmer>
Component:	Release Notes	Assignee:	Karl Eichwalder <ke>
Status:	RESOLVED FIXED	QA Contact:	Andreas Jaeger <aj>
Severity:	Normal
Priority:	P5 - None	CC:	suse-beta
Version:	Beta 5
Target Milestone:	RC 1
Hardware:	Other
OS:	Other
Whiteboard:
Found By:	Other	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description Lenz Grimmer 2006-03-08 18:08:26 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!

Comment 1 Karl Eichwalder 2006-03-09 09:11:48 UTC

Thanks Lenz, sounds reasonable.  For PostgreSQL, we have some such alert even in the manual.

Setting to needinfo for approval.

Comment 2 Andreas Jaeger 2006-03-09 13:36:59 UTC

Ok.

Comment 3 Karl Eichwalder 2006-03-13 09:15:01 UTC

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>

Comment 4 Lenz Grimmer 2006-03-13 09:40:48 UTC

Looks good to me, Karl. Thanks a lot!

Comment 5 Karl Eichwalder 2006-03-13 12:17:14 UTC

With Rebeccas help :-)
Now submitted to /work

Comment 6 Karl Eichwalder 2006-03-13 12:18:06 UTC

fixed

Comment 7 Christian Boltz 2006-03-13 23:59:43 UTC

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")

Comment 8 Karl Eichwalder 2006-03-14 06:45:50 UTC

Lenz, please comment on the first part.

Yes, it is "an SQL dump" - my bad, I applied Rebecca's corrections only partially.

Comment 9 Lenz Grimmer 2006-03-16 14:31:27 UTC

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!

Comment 10 Lenz Grimmer 2006-03-21 08:28:10 UTC

Sorry, forgot to change the bug status...

Comment 11 Karl Eichwalder 2006-03-21 16:10:49 UTC

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>

Comment 12 Karl Eichwalder 2006-03-24 16:08:37 UTC

->/work