Hi, Dan Nelson & Rolando Edwards
It works, thank you. :-)
2009/3/26 Rolando Edwards <redwards@stripped>:
> The table mysql.proc always contains the hard code of stored procedures and
> 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
> -----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?
> 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