What could have happened?

You or someone else DROPed or RENAMEd the table? You USEd the wrong database?

Have you encountered this sort of things before?

No and to be realistic it is unlikely that you have uncovered a bug in MySQL. The spontanteous loss of tables is the kind of thing people notice. You can see if what is really there by looking at the raw data dir. A database is a directory. A table is 3 files within that directory. For example: 

[root@devel3 mysql]# locate mysql/test
/var/lib/mysql/test
/var/lib/mysql/test/testac.frm
/var/lib/mysql/test/testac.MYI
/var/lib/mysql/test/testac.MYD
/var/lib/mysql/test/base.frm
/var/lib/mysql/test/base.MYI
/var/lib/mysql/test/base.MYD

[download]

My mysql data dir is /var/lib/mysql. The test database has two tables called 'testac' and 'base'. If by chance you can see the .frm, MYI and .MYD tables that correspond to your table check their perms. You could just do 'locate -u; locate missing_table.MYD

cheers

tachyon

In reply to Re: OT: complete loss of a new table by tachyon
in thread OT: complete loss of a new table by kiat

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.