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
Post a Comment