Split csv option

[expired user #6771]'s profile image [expired user #6771] posted 7 years ago in Import/Export Permalink

HI. I got to import large csv into remote database, but got "server gone away" error on too lonf sql length it would be helpful to get option to limit rows per one insert

ansgar's profile image ansgar posted 7 years ago Permalink

Did you try to use the "Server parses file contents" method?

[expired user #6771]'s profile image [expired user #6771] posted 7 years ago Permalink

It's a remote server. Can't find file

ansgar's profile image ansgar posted 7 years ago Permalink

Ok, then try to increase the max_allowed_packet variable on the target server?

Please login to leave a reply, or register at first.