The .err file contains these messages:

100605 14:27:02 [Note] Plugin 'FEDERATED' is disabled.
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Table
'mysql.plugin' doesn't exist
100605 14:27:02 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
100605 14:27:02  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the
doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
100605 14:27:03  InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100605 14:27:03  InnoDB: Started; log sequence number 0 44233
100605 14:27:03 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
-------------------------------------------------------------

Does anyone have any suggestions for getting around this problem?    A
number of posts that I read suggest that the Data path in my.ini file
may be incorrect, but it is correct and that folder contains these
files: ib_logfile0,  ib_logfile1, ibdata1, inndb_status.1092

Are these the correct files for this folder?   Is any file missing
that should be there?

When I attempt to run mySql_Upgrade, it gives me an error that the
server is not running, which is sort of a Catch-22 situation.

Help!

J

Joe <delphi562@cox.net> wrote:
> The .err file contains these messages:

<cut>

> 100605 14:27:03 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist

The `mysql` system database is missing.

> Does anyone have any suggestions for getting around this problem?  A
> number of posts that I read suggest that the Data path in my.ini file
> may be incorrect, but it is correct and that folder contains these
> files: ib_logfile0,  ib_logfile1, ibdata1, inndb_status.1092
>
> Are these the correct files for this folder?   Is any file missing
> that should be there?

There should be a subdirectory 'mysql' and in it several files like
'host.frm', 'host.MYD', 'host.MYI' (those are for the mentioned
'mysql.host' table) and several more.

Also the messages about InnoDB recovery suggest that there is actually
data in the InnoDB tablespace (the ibdata1 file). But then there should
also be some subdirectories for databases, containing the .frm files
for the InnoDB tables.

Has this server ever run? If yes, then there should be a valid datadir
somewhere and the 'datadir' variable in my.ini should point to it.
The InnoDB files are by default located in the datadir, but can be
relocated quite freely. Seeing the ibdata1 file in some dir is not a
valid proof that this is the datadir. The default datadir on Windoze
is $installdir/data

If you cannot find an old (and usable) datadir, then mysql_install_db
can be used to populate an empty datadir with defaults. All user data
will be gone after that.


XL

On Sat, 05 Jun 2010 14:34:50 -0700, Joe wrote:

> When I attempt to run mySql_Upgrade, it gives me an error that the
> server is not running, which is sort of a Catch-22 situation.
> 
> Help!
> 
Certainly.

www.ubuntu.org
www.linuxmint.com

Thank you for the response.

To answer your question, no - the MySQL server has never run before on
this machine.   I am installing it and attempting to run it for the
first time.    I downloaded the Windows installation package and ran
it, but apparently that does not create the MySQL system database, as
I would have expected.

I will search for the mysql_install_db program that you mentioned and
see if that creates the necessary files.

Can you recommend any good books on MySQL?   because I obviously need
help.....

J

Joe <delphi562@cox.net> wrote:
> Thank you for the response.

I guess you meant to reply to me...

> To answer your question, no - the MySQL server has never run before on
> this machine. I am installing it and attempting to run it for the
> first time.  I downloaded the Windows installation package and ran
> it, but apparently that does not create the MySQL system database, as
> I would have expected.

It does so when you run the "Instance Configuration Wizard". Maybe you
downloaded the no-install package? The .msi package suggests to run
that wizard right after the installation.

> I will search for the mysql_install_db program that you mentioned and
> see if that creates the necessary files.

I just checked my Windoze testbed. This program does not exist in the
Windoze port (but all UN*X ports). I guess this functionality is all
bundled in the mentioned wizard (MySQLInstanceConfig.exe)

> Can you recommend any good books on MySQL?

The manual? http://dev.mysql.com/doc/
There is also a tutorial included...


XL