how to export .sql file of a table in mysql code example
Example 1: how to export db from mysql
mysqldump -u username -p dbname > dbexport.sql
Example 2: export mysql table to file
mysqldump db_name tbl_name;
mysqldump -u username -p dbname > dbexport.sql
mysqldump db_name tbl_name;