Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Regular Coder
    Join Date
    May 2010
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    can't see the tables

    I recently encountered this problem. My website is down because it can't locate database tables(DB Error: Table table1 does not exist). Under cpanel/phpmyadmin,I tried the mysql> show tables, it shows the tables list that my website used. But on the main interface of phpmyadmin these tables does not appear(left side). Now using data dictionary in phpmyadmin, it display table names that my website used,but does not show data fields of that table.

    Additional info, I am not the one who create these missing tables. There are still tables that appear on the database, but these tables are the one that I created. But previously I can see these tables that I did not create at phpmyadmin. I tried SELECT * FROM `missingtable` , and it says table does not exist. These tables are innodb tables. Myisam tables are not affected.

    Can anybody clarify this issue? And what should I do. Thanks.
    Last edited by Anishgiri; 06-18-2014 at 08:22 AM.


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •