dotkpay Posted March 22, 2013 Share Posted March 22, 2013 Hello, I accidentallly deleted several mysql records using a php script before backing up. Is it possible to a see a mysql log of what was deleted whether from php or sql or the local xampp server itself. Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/276014-deleted-mysql-records-using-php-script/ Share on other sites More sharing options...
Maq Posted March 22, 2013 Share Posted March 22, 2013 To my knowledge MySQL DOES NOT keep a log of deletions by default. If you don't have a backup then I'm afraid those records are gone. Link to comment https://forums.phpfreaks.com/topic/276014-deleted-mysql-records-using-php-script/#findComment-1420346 Share on other sites More sharing options...
fenway Posted March 23, 2013 Share Posted March 23, 2013 Well, if you have binary logging / query logging enabled, you'll have something useful -- but the records are gone. Link to comment https://forums.phpfreaks.com/topic/276014-deleted-mysql-records-using-php-script/#findComment-1420534 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.