0

I did mysqldump for --all-databases and after some software updation on my machine the one database has deleted. so, How to restore that particular database form .sql file?

.sql file contain mysqump for all database.

pleased suggest something

Pranay
  • 45
  • 1
  • 5
  • possible duplicate of [Can I restore a single table from a full mysql mysqldump file?](http://stackoverflow.com/questions/1013852/can-i-restore-a-single-table-from-a-full-mysql-mysqldump-file) – gmo Jun 11 '15 at 13:15

1 Answers1

0

When I've done this in the past I've used Workbench.

enter image description here

The SQL should contain the code to re-create the schemas and tables, along with the data.

John Moore
  • 511
  • 1
  • 9
  • 23