Tables doesn't exist (disappeared)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vdanvoye
    New Member
    • Nov 2007
    • 1

    #1

    Tables doesn't exist (disappeared)

    Some tables in my database cannot be opened anymore (in design or view mode). Those tables do exist though: they are listed when I run the query 'show tables' but when I try to open them, I get "1146 table XXX doesn't exist". Did this happen to anyone else? If so, is there a way to recover those tables?

    Mysql v5.0.27
    Server: Apache/2.2.3 running on Sun

    Thanks for any tips!

    Vincent
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Welcome to TSDN!

    Originally posted by vdanvoye
    Some tables in my database cannot be opened anymore (in design or view mode).
    We you able to open these before? Did you change the datadir location?

    Originally posted by vdanvoye
    but when I try to open them, I get "1146 table XXX doesn't exist".
    How are you opening these? Are you using the correct table name/case?

    Comment

    • Atli
      Recognized Expert Expert
      • Nov 2006
      • 5062

      #3
      Hi Vincent. Welcome to TSDN!

      Have you tried prefixing the table names with the database in which they are?
      For example:
      [code=mysql]
      SELECT * FROM myDb.myTbl
      [/code]

      Comment

      Working...