开发者

is there a mysqldump option for "Maximal length of created query" which I noticed in phpmyadmin?

开发者 https://www.devze.com 2023-01-22 20:03 出处:网络
I am getting server has gone away errors when i try to re import a database created with mysqldump. I don\'t get that error when I export from phpmyadmin. I am 开发者_运维问答trying to mimic the phpmy

I am getting server has gone away errors when i try to re import a database created with mysqldump. I don't get that error when I export from phpmyadmin. I am 开发者_运维问答trying to mimic the phpmyadmin export output with mysqldump.

phpmyadmin has something called "Maximal length of created query" set to 50000. What option does that translate to in the mysqldump command?

Here is what I have so far:

mysqldump -u username -p pass > backup.sql


This will limit the length of the generated queries.

--net-buffer-length 5000

0

精彩评论

暂无评论...
验证码 换一张
取 消