List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:December 14 2009 3:04pm
Subject:Re: Delete table definition without .frm files.
View as plain text  
No, if you were to try a create statement, mysql would notice the
still-existing data in the InnoDB file. You just have to create a .frm file
on the filesystem level, and assign it the correct permissions (on unix,
ug=rw and owned by mysql:mysql or something similar).


On Mon, Dec 14, 2009 at 2:13 PM, Manasi Save <
manasi.save@stripped> wrote:

> Thanks Johan,
>
> I tried doing this. When I try to delete that empty table it is giving me
> an error saying Unknow table 'tblename'.
> I have created empty .frm file at folder level. can I create one from
> mysql.
> Thanks in advance.
>  --
> Regards,
> Manasi Save
>
>
>
> Quoting Johan De Meersman <vegivamp@stripped>:
>
>> Heh. You'll need to just create an empty .frm file, and then issue the
>> drop
>> table statement.
>> On Mon, Dec 14, 2009 at 6:11 AM, Manasi Save <
>> manasi.save@stripped> wrote:
>>
>> > Hi All,
>> >
>> >
>> > I really don't know how to elaborate this problem because it is quite
>> > strange-
>> >
>> >
>> > I have deleted .frm files but not by issuing Drop table command I
>> deleted
>> > the folder from backend at folder level as there was some problem. >
>> >
>> > Is there any way I can delete this definition from innodb datafile?
>> >
>> >
>> > Thanks in advance. >
>> > --
>> >
>> > Regards,
>> > Manasi Save
>> > Artificial Machines Private Limited
>> >
>> >
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Delete table definition without .frm files.Manasi Save14 Dec
  • Re: Delete table definition without .frm files.Johan De Meersman14 Dec
Re: Delete table definition without .frm files.Manasi Save14 Dec
  • Re: Delete table definition without .frm files.Johan De Meersman14 Dec