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 --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 > redwa...@logicworks.net > > -----Original Message----- > From: Cui Shijun [mailto:rancp...@gmail.com] > Sent: Thursday, March 26, 2009 7:44 AM > To: mysql@lists.mysql.com > 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=redwa...@logicworks.net > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
