Delete table definition without .frm files.

--=_7nc21frd3ag
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


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


--=_7nc21frd3ag
Content-Type: multipart/related;
boundary="=_9gdorxxhxig";
start="9h8vql1elew@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_9gdorxxhxig
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 9h8vql1elew@mail.artificialmachines.com

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,

Re: Delete table definition without .frm files.

--0016369205f68d2bc0047aadeaf1
Content-Type: text/plain; charset=ISO-8859-1

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@artificialmachines.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
>
>

--0016369205f68d2bc0047aadeaf1--

Re: Delete table definition without .frm files.

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 :
> 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@artificialmachines.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=gcdmg-mysql-2@m.gmane.org

Re: Delete table definition without .frm files.

--0016e644cd96d40392047ab196a7
Content-Type: text/plain; charset=ISO-8859-1

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@artificialmachines.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 :
>
>> 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@artificialmachines.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=vegivamp@tuxera.be
>
>

--0016e644cd96d40392047ab196a7--