create dump file from database in mysql

mysqldump can skip tables, you need the --ignore-table parameter. Check out the manual of mysqldump.

mysqldump -u user -p some_database > some_database_dump.sql