How recover a deleted MySQL function

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gruevsotir
    New Member
    • Jul 2015
    • 1

    How recover a deleted MySQL function

    I have functions saved under proc.

    I am using MySQL Workbench. I just tried to alter a function which resulted in an error (something about it being unsafe and binary logging); however, when I clicked "Apply", it dropped my function... and then as I was searching for the relevant option setting, Workbench crashed!

    What's the easiest way to recover this function from a file-based backup?
  • computerfox
    Contributor
    • Mar 2010
    • 276

    #2
    Since you're using WorkBench, I would assume you have an easy way to import the dump file if you have that dump file.

    Comment

    • Luuk
      Recognized Expert Top Contributor
      • Mar 2012
      • 1043

      #3
      The 'easiest' way is, of course, to restore a backup.....

      Comment

      • computerfox
        Contributor
        • Mar 2010
        • 276

        #4
        Isn't that what I said?

        Comment

        Working...