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
我有几个sql转储文件,如从其他数据库中取得的表。现在我想使用sqlyog将表更新到我的服务器中。所以任何人都可以帮助我将.sql文件导入SQLyog ???提前谢谢你
6 个解决方案
#1
6
In SQLyog there is an option - Tools -> Execute SQL script. You can use this to run SQL scripts.
在SQLyog中有一个选项 - 工具 - >执行SQL脚本。您可以使用它来运行SQL脚本。
#2
3
In order to make it clear please refer the screenshot:
为了说清楚,请参考屏幕截图:
#3
2
Why use SQLYog, mysqldump is already an available command with server.
为什么使用SQLYog,mysqldump已经是服务器的可用命令。
mysqldump --opt --user=username --password database > dumbfile.sql
where dumbfile will be your sql file.
其中dumbfile将是你的sql文件。
MYSQLDump command I have used it a lot to get databases export and is highly reliable.
MYSQLDump命令我已经使用它来获取数据库导出并且非常可靠。
And mysql command to import the same:
和mysql命令导入相同:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
#4
1
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.
在SQLyog中有一个选项 - 工具 - >执行SQL脚本。如果有一些错误它会弹出,然后点击“打开错误文件按钮”,它会在sql文件中给你错误。
#5
0
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.
我想你可以在Query窗口中打开你的SQL文件,然后在SQLYog中运行它。看一下这个文档页面 - 执行SQL查询。
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.
此外,您可以使用mysql - MySQL命令行工具或dbForge Studio for MySQL(免费快速版)来对MySQL数据库执行SQL文件。
#6
0
In SQLyog v7.14, run DB -> Restore from SQL Dump..., or just press Ctrl+Shift+Q.
在SQLyog v7.14中,运行DB - >从SQL转储还原...,或者只需按Ctrl + Shift + Q.
#1
6
In SQLyog there is an option - Tools -> Execute SQL script. You can use this to run SQL scripts.
在SQLyog中有一个选项 - 工具 - >执行SQL脚本。您可以使用它来运行SQL脚本。
#2
3
In order to make it clear please refer the screenshot:
为了说清楚,请参考屏幕截图:
#3
2
Why use SQLYog, mysqldump is already an available command with server.
为什么使用SQLYog,mysqldump已经是服务器的可用命令。
mysqldump --opt --user=username --password database > dumbfile.sql
where dumbfile will be your sql file.
其中dumbfile将是你的sql文件。
MYSQLDump command I have used it a lot to get databases export and is highly reliable.
MYSQLDump命令我已经使用它来获取数据库导出并且非常可靠。
And mysql command to import the same:
和mysql命令导入相同:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
#4
1
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.
在SQLyog中有一个选项 - 工具 - >执行SQL脚本。如果有一些错误它会弹出,然后点击“打开错误文件按钮”,它会在sql文件中给你错误。
#5
0
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.
我想你可以在Query窗口中打开你的SQL文件,然后在SQLYog中运行它。看一下这个文档页面 - 执行SQL查询。
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.
此外,您可以使用mysql - MySQL命令行工具或dbForge Studio for MySQL(免费快速版)来对MySQL数据库执行SQL文件。
#6
0
In SQLyog v7.14, run DB -> Restore from SQL Dump..., or just press Ctrl+Shift+Q.
在SQLyog v7.14中,运行DB - >从SQL转储还原...,或者只需按Ctrl + Shift + Q.