List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 11 2007 12:58am
Subject:Re: View pocedures/backup procedures
View as plain text  
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
	dnelson@stripped
Thread
mysqldump/restoreB. Keith Murphy10 Jul
  • RE: mysqldump/restoreJohn Mancuso10 Jul
    • View pocedures/backup proceduresAndrey Dmitriev11 Jul
      • Re: View pocedures/backup proceduresDan Nelson11 Jul