Export specific tables from MySql database

In Magento, sometimes you may want to export specific tables for which you need to make use of command line. To export full database, we make use of: mysqldump –user=root –password= –host=localhost –compress –disable-keys –quick [db_name] > export.sql In case you need to export specific tables, use the following command: mysqldump –user=root –password= –host=localhost –compress –disable-keys …