Home > Database > Mysql Tutorial > MYSQL利用Navicat对含有Bold字段表进行导入导出_MySQL

MYSQL利用Navicat对含有Bold字段表进行导入导出_MySQL

WBOY
Release: 2016-06-01 13:07:07
Original
2659 people have browsed it

Navicat

MYSQL中含有Blob字段是一件挺麻烦的事情,导出导入不方便。我介绍我是怎么做的。

1、在MYSQL的my.ini最后中添加一行配置max_allowed_packet = 100M,重启MYSQL服务

根据实际情况来定这个数值的大小,我这次表里面有82个mediumblob字段,所以设置为100M

2、用XML格式导出数据

3、选择用XML导入数据

选择表示一行的标签,我这里是RECORD。

4、耐心等待,如果有报错多少条处理失败是因为 max_allowed_packet = 100M的值设置的太小。删掉部分成功导入的数据,扩充值,再重启Mysql,再重新导入。

source:php.cn
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template