On Thu, 5 Apr 2001, Gerald Clark wrote:
> Another thought.
> These are isam tables, not myisam tables.
> Unless the two machines are the same hardware type and operating system,
> you
> can't just copy the files over. Use msqldump.
>
Actually I was under the impression that the way the files were stored, they were
archtecture independent and you can infact copy them from anywhere to just about
anywhere :-/ (correct if wrong). So h/w architecture and OS should not matter (do
they?)
.ISM is for ISAM index files, which is the old format. The MyISAM files which is the
new format, have a .MYI ending.
host.ISM is the ISAM version of the index file of the 'host' table of the 'mysql'
database, which is used for user authorization (too many 'of's in a sentence 8-).
Actually it should be looking for host.MYI
What version was the last one and what is the new you moved to?
regards,
thalis
>
> "Kevin J. MacDonald" wrote:
> >
> > In my mysql/data/mysq directory all the permissions are set to 660.
> > Any ideas on what host.ISM file that it is looking for. I never seen it
> > before and when I check the old server I can't find it.
> >
> > thanks
> >
> > kevin
> >
> > ----------
> > >From: "Brian Warn" <[EMAIL PROTECTED]>
> > >To: "Kevin J. MacDonald" <[EMAIL PROTECTED]>
> > >Subject: Re: [mysql] cant start mysqld process
> > >Date: Thu, Apr 5, 2001, 12:53 PM
> > >
> >
> > > Kevin,
> > >
> > > Make sure that the permissions on your mysql database are at least 660. I
> > > had the same problem. After fixing, the problems went away.
> > > ----- Original Message -----
> > > From: "Kevin J. MacDonald" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, April 05, 2001 8:43 AM
> > > Subject: [mysql] cant start mysqld process
> > >
> > >
> > >> Hello,
> > >>
> > >> I just finished moving my database to another machine. It was running fine
> > >> and after I rebooted I now get an error when I try to run safe_mysqld &.
> > >>
> > >> When I look in mysql/data/comproom.err file, I get a message about '...
> > > cant
> > >> find file: './mysql/host.ISM' (errno: 13)
> > >>
> > >>
> > >> thanks for any help
> > >>
> > >>
> > >> kevin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
