Hello.
mysql_fix_privileges usually modifies grant tables to make them compatible with new features of a new version. From my experience MySQL will perfectly run without this. > If I do a dump of mysql database will it be enough?meaning if there is > any problem during the execution of the script will it be enough to > reload the mysql database? Yes, if you want - make copy of the database with mysqlhotcopy. See: http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html > Last, one of the server on which I have no control (4.0.9-gamma) but > that I have to use would need the update of the privileges tables as > well: what are the consequences/risks in not running it? Check the 'Upgrading from Version 4.0 to 4.1' section of the manual: http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html Don't forget about old passwords. mel list_php wrote: > hi, > > i just inherited a mysql server 4.1 and need to run mysql_fix_privileges > on it. > However one of the databases hosted on it is production and I'd rather > avoid it to be down. > > I ran the script on an 4.0 server test that I had installed and which > was running when I ran the script. I had no problem with it, and the > server is still up without downtime. > > I hope everything will be fine as well for the production server, but in > case of how can I back up my data to revert if any problem? > > If I do a dump of mysql database will it be enough?meaning if there is > any problem during the execution of the script will it be enough to > reload the mysql database? > > I also had no problem with the old_passwords on my test db, shall I > expect any problem with the clients who would like to connect after I > run the script? > > Last, one of the server on which I have no control (4.0.9-gamma) but > that I have to use would need the update of the privileges tables as > well: what are the consequences/risks in not running it? > > Thanks for your help. > melanie > > _________________________________________________________________ > Be the first to hear what's new at MSN - sign up to our free > newsletters! http://www.msn.co.uk/newsletters > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
