Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to export only procedures mysql

# specific database
mysqldump -h the_host -u the_user -p -n -d -t --routines --triggers the_database_name > the_routines.sql
# all databases
mysqldump -h the_host -u the_user -p -n -d -t --routines --triggers --all-databases > the_routines.sql
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #export #procedures #mysql
ADD COMMENT
Topic
Name
4+7 =