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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
