MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Error 1146: Table 'mysql.1' doesn't exist
Posted by: Amol Shirke
Date: November 19, 2009 11:53PM

Hi everyone,

Another reason for this problem is when, if you have a base engine of db as myisam and you create any of the table with innodb in it.

solution from front UI is difficult as table can't be viewed, repair or drop. You have to go to datadir delete the table and restor from backup. This table have only one file with extension ".frm".



Edited 1 time(s). Last edit at 11/22/2009 10:39PM by Amol Shirke.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Error 1146: Table 'mysql.1' doesn't exist
Luke Smith
January 06, 2005 05:55PM
Re: Error 1146: Table 'mysql.1' doesn't exist
Han Chyuan Tan
January 02, 2006 12:49AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Michael Screatchbear
July 07, 2008 02:27AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Han Chyuan Tan
January 02, 2006 12:55AM
Re: Error 1146: Table 'mysql.1' doesn't exist
ste MAR
July 24, 2008 10:21AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Siddhartha Singh
October 14, 2009 01:15AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Lance Shaw
May 16, 2006 09:53AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Bill Karwin
May 16, 2006 12:13PM
Re: Error 1146: Table 'mysql.1' doesn't exist
First Last
May 05, 2009 09:02AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Edward Mansfield
May 26, 2006 08:48AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Bill Karwin
May 26, 2006 10:12AM
Re: Error 1146: Table 'mysql.1' doesn't exist
sudarshana chavan
April 23, 2008 12:47AM
Error No. 1146 Table 'mysql.servers' doesn't exist
sudarshana chavan
April 23, 2008 12:49AM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist
Keerthi S
May 06, 2008 01:53PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist
Predrag Stolic
June 01, 2008 12:01PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist
Peter Brawley
June 01, 2008 03:11PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist
Jairo Maldonado
June 07, 2008 11:37AM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist
Ron Ford
February 13, 2009 11:20AM
Re: Error 1146: Table 'mysql.1' doesn't exist
KS Chan
August 23, 2008 07:54PM
Re: Error 1146: Table 'mysql.1' doesn't exist
Fil Sand
November 04, 2008 07:17PM
Re: Error 1146: Table 'mysql.1' doesn't exist
Amir Malik Imran
December 31, 2008 05:50PM
Re: Error 1146: Table 'mysql.1' doesn't exist
Janardhan koduri
July 03, 2009 02:07AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Artur Grigor
July 25, 2009 06:24AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Sony George
October 28, 2009 12:20PM
Re: Error 1146: Table 'mysql.1' doesn't exist
jitin nandwani
November 06, 2009 05:12AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Sumit Sharma
November 06, 2009 05:56AM
Re: Error 1146: Table 'mysql.1' doesn't exist
Amol Shirke
November 19, 2009 11:53PM
Re: Error 1146: Table 'mysql.1' doesn't exist
Rick James
November 22, 2009 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.