mysql数据库表恢复数据库表,将MySQL表还原回数据库

I have a trouble in restoring MySQL table back to the database from command line. Taking backup of a table is working with mysqldump.Taking backup and restoring of a database is also working properly. I have used:

mysql -uroot -p DatabaseName TableName < path\TableName.sql

Thanks in advance

解决方案

Ah, I think I see the problem here.

Your backup script looks fine. tbl_name works correctly as the optional 2nd argument.

To restore, you should simply run

mysql -uroot -p DatabaseName < path\TableName.sql

Running man mysql would have shown you the correct arguments and options

mysql [options] db_name

As your backup script only contains one table, only that table will be restored into your database.