List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 26 2009 3:12pm
Subject:Re: where is the stored functions STORED?
View as plain text  
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
	dnelson@stripped
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