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.
