From: Johan De Meersman (vegivamptuxera.be)
Date: Mon Dec 14 2009 - 09:04:25 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.saveartificialmachines.com> 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 <vegivamptuxera.be>:
>
>> 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.saveartificialmachines.com> 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=vegivamptuxera.be
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]