got a packet bigger (solved)

[benos]

if you get "got a packet bigger than max allowed packet bytes"

go to my.cnf under 777 permision

change both max_allowed_packet fields to the same value (in both put the same value - better be 64m).

than save the file.

if it's still don't work, try to rechange it's permission to 644, it worked for me than...

[JonB]

why don't you use the mysql.exe (on Linux mysql) CLI ??

(that's the MySQL monitor aka MySQL CLI - Command Line Interface - its a raw SQL interface)

http://www.techiecorner.com/31/how-to-r ... dump-file/

read down to about the middle of the page

he/she explains about large file direct imports.

and

http://www.webcheatsheet.com/SQL/mysql_ ... hp#restore

Note - you may need to create the database and/or users first, and sometimes 'tip article' authors are a bit off on the parameter syntax. sometimes you need --user instaed of -u and --password instead of -p. The need to create the user is very likely, the need to create the database depends on the options used dumping/exporting (the matter of create/drop inclusions)

Its worth learning, as you will avoid all this timeout crap when you are working on your own servers. phpMyAdmin is a great tool, but that's what it is - a tool -. Its not a replacement for knowledge