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.s...@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 <vegiv...@tuxera.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.s...@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=vegiv...@tuxera.be > >
