[email]bcr07548creighton.edu[/email] wrote:It would be easier, if you said which from which to which version you> Apparently my Linux distro came with a fairly old version of MySQL and
> I need to upgrade before I can continue what I am working on. But if I
> upgrade MySQL by installing the latest RPM package, will I lose my old
> data? Or will the new MySQL software "automatically" find the old
> files and let me use them?
Reading <1137090247.715494.50730f14g2000cwb.googlegroups. com> I guess
you will upgrade from 3.23 and since you want to use subquerys you may
want to upgrade to 4.1 (or even 5.0).
MySQL should have no problems reading the files from your datadir and
use/upgrade them. Although it is wise to upgrade only over one release
series at a time (3.23->4.0->4.1->5.0). Have a look at:
Have a close look at the "Incompatible change" for every upgrade and
check which affectes your application(s).
The main problem you might have is when upgrading from MySQL 4.0 to 4.1.
4.1 introduced charactersets and collations. You should read the manual
about the implications and new options.
I myself dumped my data after upgrading to MySQL 4.1 and converted the
characterset and collation statements within the dump as well as the
dump itself to utf8/utf8_general_ci. But you might choose a different way.
Be carefull with setting a default caracter set for server or clients,
that might damage your character data if you for example stored utf8
data in (latin1) (VAR)CHAR columns.
HTH and greetings
This signature is left as an exercise for the reader.