How to restore single table in MySQL database via command line?

[Dipak Bhoi]

Hello folks,

It is very simple to restore mysql table in database.

Syntax :

#mysql -u username -p -D database_name < tableName.sql

Example :

#mysql -u username -p -D dipak_data1 < table1.sql

That's all. And data will be inserted in table.

Enjoy !!!