当前位置: 动力学知识库 > 问答 > 编程问答 >

How to dump mysql with all procedure and function using phpmyadmin

问题描述:

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...

分享给朋友:
您可能感兴趣的文章:
随机阅读: