Stored procedure versioning/backup/restoring has always been a pain in the butt for all dbs that support them. What is done 9/10 times is the sql script that creates them is stored, versioned, and used for backup...
now a 'show create stored procedure blah_blah' function would be nice... ;) > -----Original Message----- > From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 21, 2004 10:49 AM > To: Bing Du; [EMAIL PROTECTED] > Subject: Re: does mysqldump take care of stored procedures? > > > Hi, > > since MySQL stores stored procs in "mysql" db you need to > make backup of > "mysql" db. > But it would be nice to have a possibility to make backup of > stored procs in > readable format. > > Best regards, > Mikhail. > > > ----- Original Message ----- > From: "Bing Du" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 21, 2004 4:42 PM > Subject: does mysqldump take care of stored procedures? > > > > I'm testing backup and restore on MySQL 5.0. I did > mysqldump first and > > then dropped a table and a stored procedure on purpose. After doing > > 'mysql -h host -u user -p database < dump-file', the > dropped table could > > be restored back in the database. But the dropped procedure stayed > > missing. > > > > How should I do to get the stored procedures backed up as well? > > > > Any suggestions/ideas appreciated. > > > > Bing > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
