Hi there 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