List:General Discussion« Previous MessageNext Message »
From:Cui Shijun Date:March 27 2009 7:08am
Subject:Re: where is the stored functions STORED?
View as plain text  
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
> 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