While moving databases from development to production and vice versa it is sometimes necessary to export individual tables so that they can be imported into another database.
So in this post i will show you how to export and import individual MySQL Table
Export a single MySQL table
mysqldump -u username root -p dbname tablename > d:\tablename.sql
Import a previously dumped MySQL table
mysql -u username -p PASSWORD_HERE -D dbname < d:\dump.sql
That's it.