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]
