Dave

Gah! I've accidentally deleted a whole MySQL database. I was all careless in CPanel because I expected it to ask me before doing anything.

Why does it ask the user before deleting an e-mail address, put files in a trash can, but doesn't ask when deleting a WHOLE DATABASE?!

Luckily, I can restore most of the data by going through the server logs. Geeze, that delete button that doesn't prompt is easier to accidentaly hit than typing DELETE from database;.

Ancyru

Yeah I've had that problem too =\

__________________
When I get sad, I stop being sad, and be AWESOME instead. True story.

Dave

*whew* I just spent an hour writing a PHP script to parse the log file and re-add it to the database. All is good except for a minor glitch that can be fixed tomorrow. :grrr:

Ancyru

I don't know how to do that I just deleted the script and installed it again =\

__________________
When I get sad, I stop being sad, and be AWESOME instead. True story.

Beldin

I did it once too. I now take weekly backups of my databases.

Carrie

HAHAH Cool I am not alone!

__________________

sam

accidents do happen. sorry to hear about that one. ive wiped stuff before too.

for future reference...

with 2 click its possible to generate a mysqldump of the entire contents of a db - translated into CREATE TABLE and INSERT INTO statements that PHPmyadmin can execute, or that the cPanel restore feature can load.

Cpanel > backup > Backup db name.

Dave

I was only able to recreate the database since it only inserted data in the query string. I'm guessing you weren't that lucky and had some forum or blog accidentally deleted.

Yeah, I know about backup features. I found a backup from 5 days before the accident happened and built onto it from there. I'm thinking about writing some cron script that uses mysqldump on my workstation to make backups.