Export and Import an Individual MySQL Table from command line

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.