The table mysql.proc always contains the hard code of stored procedures and functions.
Triggers in 5.0 are stored in a .TRG file
Make sure, if you used mysqldump, to include --triggers as a dump option
Rolando A. Edwards
MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor
New York, NY 10013
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
From: Cui Shijun [mailto:rancpine@stripped]
Sent: Thursday, March 26, 2009 7:44 AM
Subject: where is the stored functions STORED?
It seems that the stored functions isn't stored in a seperated file
like trigger does.
Where are them?
If I copy the database directory from a server to another, can I get
the same functions on the both servers?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1