From: Johan De Meersman Date: December 14 2009 3:04pm Subject: Re: Delete table definition without .frm files. List-Archive: http://lists.mysql.com/mysql/219725 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e644cd96d40392047ab196a7 --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@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 : > >> 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=vegivamp@stripped > > --0016e644cd96d40392047ab196a7--