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]
