[otrs] Help.. phpmyadmin cant import my sql dump

Thanks for pointing me in the right direction. I did end up using phpmyadmin, as I had already made the size changes to PHP. The problem was mysql though. Adding : [mysqld] max_packet_size=50m to the my.ini file was the fix. Thank you for the help.

You need to raise the max_allowed_packet for both the server and the client. And then don't go through phpMyAdmin or you'll also have to deal with a PHP's memory/upload/etc. limits. On Linux I'd set a big enough value for max_packet_size (say, 50M) in /etc/my.cnf (don't know where you'd do this on Windows), restart the MySQL server and then issue a command like this:

# mysql --max_allowed_packet=50M db_name < db_dump.sql

If the dump file contains a CREATE statement you leave out the db_name of the command (as it doesn't exist yet, but the dump file will create it). See the 'Packet too large' docs: . I guess the procedure is mostly the same on Windows.

Barry Keyles