Mike Blezien <[EMAIL PROTECTED]> wrote: > Hello, > > we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18 > via the RPM's on a RH/Linux system,... can we retain all the user privileges and > databases without loosing any data and our user privileges after the upgrade... > we do have backups of all the databases. > > Is there any major changes we need to consider after upgrading ??
In 4.0.2 were added new privilges. So you should run mysql_fix_privilege_tables script to upgrade privilege tables. Read also the following section of the manual. You can find there other changes in 4.0 and some tips about upgrade from 3.23 to 4.0: http://www.mysql.com/doc/en/Upgrading-from-3.23.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]