How to import mysql dump to SQLyog

Question

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

Why use SQLYog, mysqldump is already an available command with server. e.g. mysqldump --opt --user=username --password database > dumbfile.sql — Himanshu Bhardwaj, Mar 12 '13 at 05:23
Refer this http://stackoverflow.com/questions/7390203/how-can-i-import-a-mysql-dump — Dhinakar, Mar 12 '13 at 05:24

score 8 · Answer 1 · answered Mar 12 '13 at 10:09

8

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

answered Mar 12 '13 at 10:09

Jan S

1,831
15
21

score 4 · Answer 2 · answered Nov 13 '13 at 11:56

4

In order to make it clear please refer the screenshot:

enter image description here

answered Nov 13 '13 at 11:56

Sathish D

4,854
31
44

Himanshu Bhardwaj · Answer 3 · 2013-03-12T08:19:21.680

3

Why use SQLYog, mysqldump is already an available command with server.

mysqldump --opt --user=username --password database > dumbfile.sql

where dumbfile will be your sql file.

MYSQLDump command I have used it a lot to get databases export and is highly reliable.

And mysql command to import the same:

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

edited Mar 12 '13 at 08:19

answered Mar 12 '13 at 05:28

Himanshu Bhardwaj

4,038
3
17
36

@Himanshu Bhardwaj mysqldump makes backup, he needs to run SQL files. – Devart Mar 12 '13 at 07:31
1

Yep @Devart is correct, here is correct command: mysql -u root -p[root_password] [database_name] < dumpfilename.sql – Himanshu Bhardwaj Mar 12 '13 at 08:06

score 2 · Answer 4 · edited Nov 13 '13 at 10:08

2

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.

edited Nov 13 '13 at 10:08

Nalaka526

11,278
21
82
116

answered Nov 13 '13 at 09:45

Pinkesh Sharma

2,428
20
16

score 0 · Answer 5 · answered Mar 12 '13 at 07:39

I think you can open your SQL file in Query window, and just run it in SQLYog. Have a look at this documentation page - Executing SQL Queries.

Also, you can use mysql — The MySQL Command-Line Tool, or dbForge Studio for MySQL (free express edition) to execute SQL files against the MySQL database.

score 0 · Answer 6 · answered Nov 04 '13 at 03:52

0

In SQLyog v7.14, run DB -> Restore from SQL Dump..., or just press Ctrl+Shift+Q.

answered Nov 04 '13 at 03:52

Ahmad Abdul Haq

1

How to import mysql dump to SQLyog

6 Answers6