IIRC there may be a hidden field in each table row that mysql uses to mark that row as deleted.
I'm not sure if you can use some mysql utility program such as myisamchk to undelete the rows. This may be possible. Regards Keith In theory, theory and practice are the same; in practice they are not. On Mon, 3 Apr 2006 [EMAIL PROTECTED] wrote: > To: mysql@lists.mysql.com > From: [EMAIL PROTECTED] > Subject: Re: Undelete rows with .MYD-File? > > > I have downloaded the table files and this is what I get: > > mysql> use swissmade; > Database changed > mysql> show tables; > +---------------------+ > | Tables_in_swissmade | > +---------------------+ > | shop_item | > +---------------------+ > 1 row in set (0.00 sec) > > mysql> select * from shop_item \G > Empty set (0.00 sec) > > Do you have any copies of the table files that you have not > run the recovery program on? > > Keith > > In theory, theory and practice are the same; > in practice they are not. > > > On Mon, 3 Apr 2006, Nico Schefer wrote: > > > To: mysql@lists.mysql.com > > From: Nico Schefer <[EMAIL PROTECTED]> > > Subject: Undelete rows with .MYD-File? > > > > Hi! > > > > Today i've dropped a MySQL-table and realized seconds later that i've > > dropped the wrong one.. I've saved the .MYD-File and tried to recover it > > with a tool (MySQLRecovery 1.5), but it just recovered the structure and > > not the data (about 620 rows). > > I've searched now all the day and not found anything. Maybe someone knows > > how to bring the data back or has got any hint for me? > > > > Binary log is not enabled unfortunately... > > > > http: //www.swissmade.com/mysql/shop_item.MYD > > http: //www.swissmade.com/mysql/shop_item.MYI > > http: //www.swissmade.com/mysql/shop_item.frm > > > > Thanks a lot! > > > > Nico > > > > -- > > Nico Schefer > > [EMAIL PROTECTED] > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
