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
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
redwards@stripped
-----Original Message-----
From: Cui Shijun [mailto:rancpine@stripped]
Sent: Thursday, March 26, 2009 7:44 AM
To: mysql@stripped
Subject: where is the stored functions STORED?
hi,
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?
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
