Export table/ tables from database in MySQL

To export we have "mysqldump" command in MySQL.

we will use this command to export single or multiple tables in database.

To export single table:

mysqldump -u dbusername -p database name tablename > table.sql

It will prompt you to enter password. 

To export multiple tables:

mysqldump -u dbusername -p database name tablename1 tablename2 > export.sql

It will prompt you to enter password. 

You can view your file or save it as back.