MilesWeb Hosting Forum

Web Hosting Technical Support => How To's => Topic started by: Dipak Bhoi on May 01, 2015, 05:18:51 PM

Title: How to restore single table in MySQL database via command line?
Post by: Dipak Bhoi on May 01, 2015, 05:18:51 PM
Hello folks,

It is very simple to restore mysql table in database.

Syntax :

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

Example :

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

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

Enjoy !!!  :) :)