At 17:06 -0700 8/27/04, Keith Brownmiller wrote:
Greetings,
I have a couple of questions that were not covered in the upgrade
documentation.
1) The documentation discusses creating the new mysql database with
the new privledges incorporated. Not a problem with that concept.
You don't need to create a *new* mysql database for an upgrade. You
use your old one. After installing the upgrade, run the
mysql_fix_privilege_tables script to modify your existing grant tables
to add the new privileges to them.
http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
2) I can move my other database directories to the new data
directory - Not a problem with that move.
3) My problem is how does one get the information that is contained
in the old mysql database into the the new mysql database other than
having to manually enter all of the information again, such as
create database, grant user etc. Is there some script or something
that I seem to be missing.
Have spent a tremendous amount of time digging thru the scripts and
documentation but to no avail.
Please advise
Keith
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
