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
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. Yo
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.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I really don't know how to elaborate this problem because it is quite
> strange-
>
>
> I have dele
