Skip navigation links

MySQL Forums :: Data Recovery :: physical restore from frm and ibdata1. How to connect StoredProcedures and Functions?


Advanced Search

physical restore from frm and ibdata1. How to connect StoredProcedures and Functions?
Posted by: Matthias Weller ()
Date: January 24, 2012 04:11AM

Hello,


I want to restore all my MySQL-DBs from a physical backup of all frm-files and ibdata1-file. I copied the whole data directory from a linux mysql server to a windows mysql server (I put all frm and ibdata1 into the mysql data folder.).
Now, in the windows mysql server I can see all schema. But in the schemas all stored procedures and functions are missing. I checked the proc-table in mysql-schema, all stored procedures and functions are listened there.

Could somebody help me what I have to do that the procedures and functions are in the corresponding shemas?

thanks,
Matthias



Edited 3 time(s). Last edit at 01/24/2012 04:28AM by Matthias Weller.

Options: ReplyQuote


Subject Views Written By Posted
physical restore from frm and ibdata1. How to connect StoredProcedures and Functions? 2296 Matthias Weller 01/24/2012 04:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.