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 mysql.proc table. If you're only copying one
database, it might be easier to use "mysqldump --no-create-info --no-data
--routines mydb" , which will give you the commands to recreate the stored
procedures for the mydb database.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
