Error Failed deployment

[karicom.com]

Hi all

When i try to migrate one site to my server i have this error

Failed deployment of database sitename (domain sitename.net)

Execution of /usr/local/psa/admin/sbin/cid_unpacker /usr/local/psa/PMM/var/2007-08-14-16.27.36.271135 failed with return code 1.
Stdin is db

heve you any idea !!
plese help me

 

[apro2000]

same here, any ideas, I cannot migrate anything

 

[faris]

It is possible that you need to adjust /etc/my.cnf

You can test it manually by dumping the database manually on the first one then trying to load it on the machine you are migrating to. You will then see a more helpful error about the issue. (it is possible there maybe something more helpful in one of the logs too).

Anyway, it is very likely that you have individual bits of data in one of the database tables that is larger than the default size that can be imported to mysql with the default my.cnf.

To solve the issue add a max_allowed_packet = 2M (or 4M or 16M or whatever you want - 16MB is safe at least during the migration) to /etc/my.cnf under the [mysqld] heading.

Also it might be an idea to make sure that you have old_passwords=1 in that section to make sure you don't have any issues with older scripts that might be installed.

Restart mysqld after making changes.

Faris.