Who hosts this website? If it is not you or your company, some webhosts back up the db regularly, so if you spoke to them, they might be able to get it back for you. Otherwise, definitely one of those lessons he will never forget! Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Fred Jones Sent: Sunday, March 22, 2009 8:58 AM To: thelist at lists.evolt.org Subject: [thelist] They emptied the MySQL DB I have a client who accidentally emptied his MySQL DB. A few hundred thousand records are gone--the system continues to run so 50 new records (new orders) have been inserted since then. He copied the ibdata1 fie and saved it on the Windows Server 2003 server, but that was right *after* he nixed the data. He isn't even sure what he did exactly--his 'friend' who 'knows MySQL' was helping him to copy the DB and somehow they emptied the live one. I told him that I am 99.9% certain that there is no way to retrieve that lost data, but I thought I would check... Nothing like stupid clients. :) lol -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !