Re: Delete table definition without .frm files.
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 : > >> 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 > >
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.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=arch...@jab.org
Re: Delete table definition without .frm files.
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 > >
Delete table definition without .frm files.
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