|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: View pocedures/backup procedures
From: Dan Nelson (dnelson
allantgroup.com)
Date: Tue Jul 10 2007 - 19:58:56 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In the last episode (Jul 10), Andrey Dmitriev said:
> How do I view and backup my procedural code?
>
> In oracle it would be something like
> Select text from user_source where name='MY_PROCEDURE' order by line;
>
> I did mysqldump, and didn't see any of the functions or procedures
> created.
>
> In Oracle they'd be backed up either via RMAN or EXP.
You need to add the --routines flag to mysqldump.
--
Dan Nelson
dnelsonallantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]