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. Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.