Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to import mysql dump to SQLyog

Tags:

mysql

sqlyog

I have few sql dump files like the tables taken from other db. Now i want to update the tables into my server using the sqlyog. So can anyone help me out in importing .sql files into the SQLyog ??? Thank u in advance

like image 499
Php Geek Avatar asked Mar 12 '13 05:03

Php Geek


2 Answers

In SQLyog there is an option - Tools -> Execute SQL script. If there are some Errors it will give you a pop up, then click on the "Open Error File button", it will give you error in the sql file.

like image 95
Pinkesh Sharma Avatar answered Oct 02 '22 16:10

Pinkesh Sharma


In order to make it clear please refer the screenshot:

enter image description here

like image 43
Sathish D Avatar answered Oct 02 '22 14:10

Sathish D