Re: where is the stored functions STORED?

2009-03-27 Thread Cui Shijun
Hi, Dan Nelson Rolando Edwards It works, thank you. :-) 2009/3/26 Rolando Edwards redwa...@logicworks.net: 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

Re: where is the stored functions STORED?

2009-03-26 Thread Dan Nelson
In the last episode (Mar 26), Cui Shijun said: 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? They're stored in the

RE: where is the stored functions STORED?

2009-03-26 Thread Rolando Edwards
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