In my database I have some tables and views. How can I export all the tables (and not the views) from my database from command line?
You can use mysqldump with the option --ignore-table to exclude the views individually. Or use mysqldump and remove the views with an application/manually. grep might be an option:
grep -v "CREATE VIEW" db.dump > db-without-views.dump