how to extract whole schema with create query mysql code example Example: get only structure database mysql mysqldump -u root -p --no-data dbname > schema.sql