CODEWITHSUNDEEP
mysqlnavicat
refresh
refresh

Reputation: 1329

Restore a .sql file

I have a MySQL dump (.sql file) which I want to restore. I am trying to restore it using Navicat, but somehow I just can't do this. Maybe I am missing some info here. I have tried following the steps in this link http://www.navicat.com/manual/online_manual/en/navicat/win_manual/DumpExecuteSQL.html But the Execute SQL File is grayed out. Any idea of how to proceed? I am at lost here.

Upvotes: 0

Views: 1936

Answers (2)

user8025557
user8025557

Reputation: 1

Make sure the database is created first. After creating the database, right click on the database and select Execute sql file. After selecting this, you will get a popup window where you can select your sql file and click on start. Now all the data from the backup will be loaded in your database.

Upvotes: 0

Osoian Marcel
Osoian Marcel

Reputation: 379

Try to uncheck "Run multiple queries in each execution".

enter image description here

Hope this helps.

Upvotes: 0

Related Questions