Re: [cobalt-developers] HELP can not see data or tables in database

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Richard Kurth" <rkurth@xxxxxxxxxxxx> wrote:
> I have a major problem could somebody take a seeress look at this

I have read your email...on a few mailing lists in fact.  My gut reaction is
that it's either related to bad privileges in the mysql grant tables (the
mysql db) or bad permissions/ownership of mysql table files.

>  mysql running on cobalt raq4
>  I have looked through the archives and looked at the manual
>  can not find anything to explain this
>  nothing in the mysql log file
>  I can not access the databases from the web browser I get empty
>  databases

What do you mean by "I get empty databases"?  What error messages do your
PHP web scripts give (I assume they're in PHP as you posted to the PHP list
too).

>  Went in at telnet erased all the databases including mysql

This is not the best course of action.  Did you run myisamchk against the
tables first to see if they were corrupted?  What version of MySQL is it,
where did you get it and how was it installed (RPM or source)?

>  ran mysql_install_db
>  logged back in with the web browser and the tables were there

What do you mean by "web browser"?  Do you mean phpMyAdmin?  Your web
scripts?

>  stopped mysql
>  restarted mysql
>  logged back in with the web browser databases were there but no tables

If you're using phpMyAdmin, what user are you accessing it with?  Post to
the list the contents of the user and db tables in the mysql database.
Block out the encrypted password field if you're worried about posting it.

>  I can see the tables if I telnet in and use mysql Command

Has your hostname or IP changed?  Has *anything* been installed, upgraded or
reconfigured on the server since these problems first appeared, no matter
how unrelated it may seem to you?  Was MySQL working fine for some period of
time or did you just start using MySQL?  Has the ownership or permissions
changed on the MySQL data directory, the db directories or the table files?
What user are you running MySQL as?  Have you changed the user it runs as
recently?  Please post the output of your mysql data directory (could be the
following, depends where you have it setup):

ls -aRl /home/mysql/data/

>  What is going on have done this about 6 times
>  I really need to fix this
>  Should I reinstall mysql?

It might be a quicker solution than trying to find out what's wrong, but I
can almost guarantee it's not necessary.  If you're running MySQL that's not
3.23.x you might as well though, since the latest stable version is 3.23.37
and there are advantages to running 3.23 over 3.22.

>  Should I shoot my server?

That won't fix MySQL, but it will cure the problem of having no tables
appear when using the web scripts.