[thelist] They emptied the MySQL DB

[Nan Harbison]

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 !