Re: [cobalt-users] MySQLd problem. [Ver 3.22.30 for pc-linux-gnu on i586]

[shimi <shimi@xxxxxxxxxxxxxxxx>]

This list is so darn slow. I've found out the solution myself eventaully,
around 12 hours ago :-)
(i used mysql_install_db)

  Best regards,
     shimi [mailto:shimi@xxxxxxxxxxxxxxxx]


----

There are two major products that come out of Berkeley: LSD and BSD.
We don't believe this to be a coincidence.
   -- Jeremy S. Anderson

 Windows: "Where do you want to go today?"
   Linux: "Where do you want to go tomorrow?"
     BSD: "Are you guys coming or what?"

On Thu, 8 Mar 2001, Hendrik Runte wrote:

> Hi Shimi,
> 
> seems that you killed your host table. Have you removed all your previous
> MySQL files before installing the tar ball. Normally MySQL will not
> overwrite existing mysql.tables on reinstall.
> 
> Apart from erasing or just moving your whole MySQL files there is another
> possibility you should check first:
> 
> search for the /scripts directory
> 
> execute /scripts/mysql_install_db
> CAUTION former data will be lost!
> 
> if this fails you have to remove the whole databases:
> check where is your database directory [DATADIR]
> rm -rf DATADIR/mysql
> 
> shutdown your mysql server
> /bin/mysqladmin --user=root shutdown
> 
> or simply with 
> mysqld stop
> 
> now try to run the mysql_install_db again
> 
> if that all fails, you have to remove the whole mysql thingy...
> 
> good luck!
> 
> Hendrik
> > 
> > Hi. 
> > 
> > My colo has booted my machine, and after it came back up, i found out that
> > MySQL didn't load.
> > 
> > This question actually is more about mysql than on cobalt, I guess, but
> > maybe someone will know...
> > 
> > [root@www admin]# mysqld
> > 010308 13:39:57  mysqld: Table 'mysql.host' doesn't exist
> > 
> > if I run it with:
> > -Sg, --skip-grant-tables
> >                       Start without grant tables. This gives all users
> >                       FULL ACCESS to all tables!
> > 
> > it laucnhes, and the php that uses mysql performs well.
> > so I guess it's the access table or something
> > 
> > appears it's gone. anyway to recreate a fresh one?
> > i loaded the latest tarball from mysql.com and installed it. now it's the
> > newer version and the problem persists.
> > 
> > ideas?
> > 
> > Best regards,
> >    shimi [mailto:shimi@xxxxxxxxxxxxxxxx]
> > 
> > 
> > ----
> > 
> > There are two major products that come out of Berkeley: LSD and BSD.
> > We don't believe this to be a coincidence.
> >  -- Jeremy S. Anderson
> > 
> > Windows: "Where do you want to go today?"
> >  Linux: "Where do you want to go tomorrow?"
> >    BSD: "Are you guys coming or what?"
> > 
> > 
> > _______________________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To Subscribe or Unsubscribe, please go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt-users
> > 
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users
>