mysql dump only data code example
Example 1: backup mysql data only
mysqldump -u testuser -p --no-create-info testdb > /tmp/backup_data_only.sql
Example 2: mysql dump structure only
mysqldump -d -u someuser -p mydatabase products categories users