Tkil writes:
>
> What's the easiest way to upgrade the mysql server while keeping the
> same privileges (along with all the other databases).
>
> Using 'mysqldump' on the normal databases works well, but trying to
> use it on the 'mysql' database causes problems, since the structure of
> those tables can change between versions, and the tables are generally
> created when installing a new version, thus causing errors when you
> try to make them again by blindly executing the dumped script.
>
> (This caused me a fair bit of trouble when I transitioned my redhat
> 5.1 system with hand-built 'mysql' configuration, to a RH 6.0
> distribution with the mysql RPMs.)
>
> Thanks for any input,
> t.
>
>
>
Hi!
As long as you do not change OS or CPU type, you can simply copy
tables, or leave them where they are and start new server.
You might however, use mysqldump, reload if you decide to move to
3.23.xx and use MyISAM tables.
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
