How to import mysql dump to SQLyog

mysql sqlyog
Php Geek picture Php Geek · Mar 12, 2013 · Viewed 31.8k times · Source

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

Answer

Jan S picture Jan S · Mar 12, 2013

In SQLyog there is an option - Tools -> Execute SQL script. You can use this to run SQL scripts.

Related questions

How to change the default charset of a MySQL table?

There is a MySQL table which has this definition taken from SQLYog Enterprise : Table Create Table ----------------- --------------------------------------------------------- etape_prospection CREATE TABLE `etape_prospection` ( `etape_prosp_id` int(10) NOT NULL AUTO_INCREMENT, `type_prosp_id` int(10) NOT NULL DEFAULT '0…

Read More
Error No. 2003. Can't connect to mysql server

I has had two days searching and exploring solutions regarding the error 2003. Can't connect to mysql server on 'Server name'. The firewall is off and I had added the port 3306, the one that mysql uses. Any recommendation?

Read More
How to run script from within Mysql workbench?

I have a SQL script to distribute to others to run from a MySQL IDE, not from a MySQL command prompt. I want the user to load the script into a window of workbench (or another IDE like sqlyog) and …

Read More