Hey all, by mistake I have deleted the database. I didn't have any record for this, I need that deleted database. If its not too much trouble to get it back, please provide best insights. It would be grateful if you give a best suggestion... Thanks
How was it deleted (SQL command within the DBMS, deleting files/directories via OS commands, or something else)?
Did you have any backup procedure in place beforehand?
mysql> create database DO_NOT_DELETE_THIS_DATABASE_OR_I_WILL_KILL_YOU ( characteristics );
NogDog wrote:Did you have any backup procedure in place beforehand?
This , yes ... this 🙂
It's good practice with a database to make sure that it gets backed up periodically -- typically using the mysqldump CLI utility that comes with it. Maybe there's a backup file somewhere?
sneakyimp;11048939 wrote:It's good practice with a database to make sure that it gets backed up periodically -- typically using the mysqldump CLI utility that comes with it. Maybe there's a backup file somewhere?
Yeah of course but I didn't remember any backup file...
lilysmith22;11050911 wrote:Yeah of course but I didn't remember any backup file...
If you had looked into the mysqldump utility and made a backup, you would 😉