List:General Discussion« Previous MessageNext Message »
From:Sara Woglom Date:March 28 2006 2:24pm
Subject:RE: Table doesn't exist?
View as plain text  
Thank you Dilipkumar... boy did I learn my lesson.  The one good thing about
this is that the database was at the end of the testing stage, so I didn't
lose critical customer data.  I could have gotten a backup copy of the data
files from our server backups, but at this point that would have been more
trouble than just rebuilding the table.  Next time I might not be so lucky,
so this morning I did go ahead and create my own backup copies of
everything!

Thanks everybody for your help!



  -----Original Message-----
From: Dilipkumar [mailto:dilipkumar_parikh@stripped]
Sent: Tuesday, March 28, 2006 4:24 AM
To: Sara Woglom
Cc: mysql@stripped
Subject: Re: Table doesn't exist?


  Hi,

  Better suggestion is you would have backed your ibdata1 and alo the log
file because that is the data files which contains your
  precouse data.

  If you have your backup try to import the lost tables.
  Restart your mysql with your new ibdata1 files  and import.

  This might help to solve your problem.

  Sara Woglom wrote:
I had to shut down my MySQL server (5.0.18) because of an error while
editing a table ("Table is full").  I restarted it fine, but in order to do
so I had to delete all my ibdata and ib_logfile files.  Now, I am getting
ERROR 1146: Table 'dbname.tablename' doesn't exist.  Obviously it does
exist, because when I request "SHOW TABLES;" it lists them all correctly.

What on earth is going on?  I followed the directions for restarting the
server and deleting the log files!  I also ran mysqladmin flush-privileges,
flush-hosts, and refresh.  Please help!

  --------------------------------------------------------------------------
--




--
Thanks & Regards,
Dilipkumar
DBA Support

Thread
Table doesn't exist?Sara Woglom27 Mar
  • RE: Table doesn't exist?Ing. Edwin Cruz27 Mar
RE: Table doesn't exist?Sara Woglom27 Mar
RE: Table doesn't exist?Sara Woglom28 Mar