List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:March 26 2009 3:36pm
Subject:RE: where is the stored functions STORED?
View as plain text  
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

Thread
where is the stored functions STORED?Cui Shijun26 Mar
  • Re: where is the stored functions STORED?Dan Nelson26 Mar
  • RE: where is the stored functions STORED?Rolando Edwards26 Mar
    • Re: where is the stored functions STORED?Cui Shijun27 Mar