问题描述:

I am trying to export mysql dump file with checked option 'Add CREATE PROCEDURE / FUNCTION' in export page using Phpmyadmin but neither function nor procedure is dumping ... please suggest me how i can dump with procedure and function

网友答案:
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql

In case you want to backup ONLY the stored procedures and triggers and not the mysql tables and data, it might be helpful like above... Hope it helps...

相关阅读:
Top