Want to upgrade to mysql 5.0. Not sure what I need to do to upgrade. I have looked at the mysql site and some postings on this site but not real clear. Should I backup my current databses? Do I need an rpm or CC compiler download? Once I download a version should I install through command line or YAST? If through the command line is mysql_install the correct command to use for installing and upgrading?

Running SUSE 10 and here is my mysql version:

mysql Ver 14.7 Distrib 4.1.13, for suse-linux (i686) using readline 5.0

I am a newbie, so ANY help would be appreciated.

I would absolutely backup the databases in any case with or without an upgrade. Look in YAST and see if it offers a version 5. If it does, you are all set, just upgrade it through YAST. If it isn't available through YAST and you still need to upgrade, you would have to go manual compilation way...which ain't pretty if you are a newbie. Check YAST first.

Tux,

I tried using Yast but there is no version 5 available. I would like to manually download but I am not sure which download is the most viable option with SUSE 10.