Ah, I forgot to dump the 'mysql' db. Thanks so much, Mikhail, for waking me up :).
Bing > 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]
