Error on database import using phpmyadmin

[tayjsn]

Hi,
I'm trying to import a database dump file from another OTRS to my own OTRS using phpmyadmin.
After i choose the dumpfile and click 'Go'
This error message appears (please refer to attachment).

I've tried to change the limit in the following sections.
In php.ini
upload_max_filesize; -1M
memory_limit:500M
post_max_size: -1M

In mysql\my.ini
max_allowed_packet= -1M

After changing all that, The error still appears.
Any help is deeply appreciated.

Thanks,
Jason

[jojo]

you need to set the max allowed packet size to at least the same value as on the old system and restart mysql afterwards

[givmeasec]

Dear guys, I am having the same problem.
I am trying to import a database dump file i made from another OTRS into my own .
Using phpmyadmin, first, i drop the database otrs, then create otrs again.
Next i go to import and proceed to import the database file.
However, i get the error as attached.
I have already configured the necessary files mentioned above and i keep getting the same error.
I am not sure whether the problem has something to do with the packet_repository tables.

Any help is deeply appreciated.

[tayjsn]

Dear guys,
after some searching and digging around, I have found out that the table package_repository is related to ITSM.
It appears to store values of the installed ITSM in the OTRS. (picture below)

So what i did was to install the same ITSM version on my local OTRS.
Next is to do the same restore procedure.
However, the same error still persist as above.
It might be some problem with the values in package_repository that can not be transferred correctly.
However, I am not sure what to do now..
Any help is appreciated.

PS. I have modify the max_allowed_packet value and restarted service. It doesn't help.

[jojo]

Please check again teh setting of the max_allowed_packet value (it needs to be in the right place of the file) or ask your database admin to check.

The package_repository contains all installed OTRS packages