MySQL Forums
Forum List  »  General

Re: Error 1146: Table 'mysql.1' doesn't exist
Posted by: Sony George
Date: October 28, 2009 12:20PM

Artur Grigor Wrote:
-------------------------------------------------------
> Hello,
>
> I've experienced the same problem.
>
> I have uninstalled my XAMPP server and upgraded
> to another version BUT I have keeped my mysql data
> folder, and now I cannot access any of my InnoDB
> tables.
>
> What should I do?
>
> Thank you!

Hello,
i also have the same problem,
i kept my mysql installation in d drive and mysql gui in c drive,
formatted c drive, installed again the same mysql gui,
then configured the instance by selecting the same my.ini file ,
and now i can not access any of my tables.

i did a mysql_upgrade command but it says

Error : Table 'oscommerce.zones_to_geo_zones' doesn't exist
error : Corrupt
if i give a select the message is

Table 'oscommerce.zones_to_geo_zones' doesn't exist error:1146

i have the files in my data dir, and all have permission set correctly
can any one help me please .......

thanks and regards

Options: ReplyQuote


Subject
Written By
Posted
Re: Error 1146: Table 'mysql.1' doesn't exist
October 28, 2009 12:20PM


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.