1

MySQL had an error updating and caused my database to stop working correctly. I had to reinstall mysql during this process I was looking up how to restore my database after reinstalling. I was able to restore the database with all the tables and data inside them using the instructions in the following post:

Restoring database from physical files

But I noticed the functions weren't restored with the rest of the database. Anyhow I was wondering if someone could give me a hand with this?

I am running mysql on an nginx server. All help is appreciated. Thanks!

Community
  • 1
  • 1
Orlando
  • 935
  • 2
  • 20
  • 42

1 Answers1

2

The stored functions and stored procedures for all databases are stored in the proc table inside the mysql schema.

You'd need to restore the proc.FRM, proc.MYD, etc. files, inside the mysql directory, preferrably with the server stopped, since your reinstalled server already has those -- presumably empty.

Michael - sqlbot
  • 169,571
  • 25
  • 353
  • 427