Hello.
Sounds very strange. May be there is a bug, and it would be great if someone corrects me, but I haven't found anything related in bugs database. You said that you issued "show tables" statement on your database? Maybe it would be helpful to try not only "show tables from your_database", but also: use your_database; show tables; or show table status; show table status from your_db; What output the command line utility mysqlshow produced? mysqlshow your_database mysqlshow --status your_database When you were making selects did you use db_name.tbl_name syntax to refer to a table? Send us your config file (however I don't know if it would be helpful, but this is a good practice). "Jason St. Louis" <[EMAIL PROTECTED]> wrote: > Hi Folks, > > I've been running a website on php/mysql database for about a year now. > I typically enter data using the phpmyadmin package. The other day I > attempted to add some data but it appeared to phpmyadmin that there were > no tables in my database. I connected to mysql using the commandline > client and issued a "show tables" statement on my database, which came > back with an empty set. However, if I run a select statement against > tables I know should be there, I get results. So the data is still > there, I just can't see the tables. Does anyone have any idea what > might be causing this? I am the only one who has access to the database > so the priveleges for the user should not have changed. I created an > additional user with > "Grant all privileges on *.* to 'user'@'host' identified by 'password' > with grant option;" > and attempted to view the tables with that user, with the same results. > > Any ideas? > > mysql version is: Ver 11.18 Distrib 3.23.55, for pc-linux (i686) > > Thanks. > Jason > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
