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

[Hendrik Runte <cobalt@xxxxxxxxxx>]

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
>