Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 345
bshack Avatar asked Dec 06 '25 12:12

bshack


1 Answers

This will limit the length of the generated queries.

--net-buffer-length 5000

like image 147
foomagoo Avatar answered Dec 08 '25 02:12

foomagoo



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!