mysql - How come doing a find/replace on sql dump and importing it gives error #2006? -

i have sql dump wordpress install lives on domain. need make changes site have set localhost using mamp.

if import sql dump "as-is" imports without problem. need change url's in sql dump point localhost instead.

when use aptana replace on sql file http://example.com http://localhost/example , try import modified file mysql error "#2006 - mysql server has gone away"

what problem here? have temporarily fixed overriding hosts file example.com point localhost not long term viable option.

i aware error occurs files large or server not responding able import non-modified version of sql. there 9538 replaces being done cannot go through 1 1 find culprit.

thank you

(just realized doesn't relate directly problem, still need info if doing search , replace in mysql dump).

data in wp database serialized. can't search , replace.

you can't change data without re-serializing it.

there scripts , services allow proper search , replace.

i use this tool (git repository here), , works perfectly. there couple plugins work, , discovered this service theme creation company same thing.

good luck , happy wordpressing.