Those are the ones. What about host.FRM ?
Normally
*.FRM are the ones that contain table definitions.
*.MYD are the ones that contain Table Data
*.MYI are the ones that contain Index information
I think for every table, the above files should be there.
How did you install MySQL? From an installer? Or you just unzipped the
files?
Both methods should work on Windows.
Try to reinstall and see if the problem will be solved
Thanks
Emery
----- Original Message -----
From: "Larry Wasserman" <[EMAIL PROTECTED]>
To: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 18:31
Subject: RE: Starting the mySQL Server
What if it isn't there. How do I create it? I have some files such as
host.MYD, and host.MYI; are these related?
_________________________________________________________________
Larry Wasserman Two Prudential Plaza
Enterprise Marketing Automation 180 North Stetson, Suite 5200
SAS Institute Inc. Chicago, IL 60601
<<mailto:[EMAIL PROTECTED]>> Phone: 312-819-6800 x8826
Pager Phone: 888-446-6597 Fax: 312-240-0342
SAS ... The Power to Know
-----Original Message-----
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 10:50 AM
To: Larry Wasserman; [EMAIL PROTECTED]
Subject: Re: Starting the mySQL Server
That is one of the tables in MySQL database (for privileges and other server
stuffs).
It is located in
MySQL DATA --->mysql --->
MySQL data is the directory containing all data.
On windows systems that is normally c:\mysql\data
So the table file should be in c:\mysql\data\mysql
Thanks
Emery
----- Original Message -----
From: "Larry Wasserman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 17:29
Subject: Starting the mySQL Server
I cannot start the MySQl Server. I am running Windows XP. I checked the
error file and get the following message.
031020 10:11:56 InnoDB: Started
031020 10:11:56 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist 031020 10:11:56 Aborting
What do I need to do for my mysql.hosts file? Where should it be located?
_________________________________________________________________
Larry Wasserman Two Prudential Plaza
Enterprise Marketing Automation 180 North Stetson, Suite 5200
SAS Institute Inc. Chicago, IL 60601
<<mailto:[EMAIL PROTECTED]>> Phone: 312-819-6800 x8826 Pager Phone:
888-446-6597 Fax: 312-240-0342
SAS ... The Power to Know
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
