2

I had some databases on a server and MySQL server on this server has been uninstalled accidentally by someone.

I had some backups on this server and could recover all tables and their data successfully, but the problem is that the events and procedures are lost.

How can I recover the lost events and procedures? I searched a lot to know if it is possible or not.

0

2 Answers 2

1

If you are lucky, you won't need the backups. (Oops, you have already gone beyond this step.)

If MySQL's data directory was left behind by the uninstall, then simply reinstall.

Was the backup taken using mysqldump (either explicitly, or under-the hood)? If so, perhaps it failed to have the arguments asking to save "stored routines", etc.

I fear you are out of luck.

0

Community Wiki answer generated from a comment on the question by Michael - sqlbot

In the future, you will want to add the --events and --routines options to your backups... and take away the access "someone" has to your database server. Unless the files are still there in spite of the "uninstall," the data is, for all practical purposes, lost... with the possible exception of low, low, low level forensic-style recovery of the delete file contents.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.