Export DB to SQL query using mysqldump

Export DB to SQL query using mysqldump

1. Data only

2. Table Schema and data

3. Table Schema only

mysqldump --no-data --skip-comments --skip-add-drop-table --default-character-set=utf8mb4 -uUSER -p -hHOST DBNAME | sed 's/ AUTO_INCREMENT=[0-9]*//g' > output.sql

4. Procedure only

mysqldump --routines --no-create-info --no-data --skip-comments --no-create-db --skip-opt --add-drop-table --default-character-set=utf8mb4 -uUSER -p -hHOST DBNAME | sed -e 's/DEFINER=`[a-zA-Z]*`@`[0-9.%]*`//g' > output_sp.sql