[MySQL] Backing up Schema with Procedures but No Data in MySQL Workbench

I needed to backup just the schema and procedures (routines) for some schemas (databases) in MySQL. The command used:

C:\Program Files\MySQL\MySQL Workbench 8.0 CE> mysqldump -d --column-statistics=0 --routines -u USERNAME -h HOSTNAME -p SCHEMA > SCHEMA.sql

Replace the highlighted items as required.




Comments