Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

运用mysql中的source命令导入大的sql文件的解决方法_MySQL

WBOY
Release： 2016-06-01 13:38:41
Original
1007 people have browsed it

bitsCN.com


运用mysql中的source命令导入大的sql文件的解决方法

 

1    

在mysql的安装目录下 找到 my.ini文件 加入以下代码：

2

 

3

interactive_timeout = 120

4

wait_timeout = 120

5

max_allowed_packet = 32M

 

bitsCN.com
Related labels：
mysql source
source：php.cn
Previous article：MySQL 5.5.28字符集的设置_MySQL Next article：mysql的XA事务恢复_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Embedding HTML generated by an R function I want to dynamically build html and render that html in quarto. The actual application in...
From 2024-04-01 20:51:51
0
1
367
How do I link to a custom library when building MySQL server from source? I installed MySQL server using the standard source distribution (mysql-server-8.0) accordi...
From 2024-04-01 14:30:27
0
1
296
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template