General Question related to SQL an issue i faced.
A few days back I did cross-join and forgot to apply any filter to it which multiply lakhs of records with a couple of hundred records.
Everyone knew what will be the result system crash but that's not point
Issue is whatever database in MySql console everything lost (all Table data of each database on which I'm working)
I tried to rollback even that doesn't work(autocommit off then too). Obviously all data are just for practice so doesn't matter me a lot I added them back from raw Db file but whatever changes or tables I worked upon lost
could you pls tell me how to stop this or recover from this kind of mishap(only if it doesn't include high level software) any YT video or any other link not an issue just need a mindset how to overcome from condition like this
Thanx for understanding all this