MySQL Error

[sandipcd]

I am upload a Drupal Database in mysql and getting error related to max_allowed_packet.

So how can I increase max_allowed_packet for Mysql?

[MRatWork]

Try place your .sql file in /tmp and then export with select '/tmp'.

[sandipcd]

I have tried uploading file in /tmp folder and then import it to phpmyadmin. But still in phpmyadmin is showing error that "#1153 - Got a packet bigger than 'max_allowed_packet' bytes ".

I have run command in putty "mysql --help |grep packet" and found that 'max_allowed_packet' is 16MB. My server has CentOS 6 - 1GB RAM.

Any idea how to solve this problem?

[MRatWork]

Add 'max_allowed_packet=32M' under '[mysqld]' in /etc/my.cnf (for Kloxo-MR 6.5) or /etc/my.cnf.d/server.cnf. And then restart with 'sh /script/restart-mysql -y'.

[sandipcd]

I have Kloxo-MR version 7? Is the file will be different?

[MRatWork]

I have Kloxo-MR version 7? Is the file will be different?

For MariaDB (in Kloxo-MR 7), /etc/my.cnf just content link/include to files inside /etc/my.cnf.d/server.cnf.

[sandipcd]

I have Mysql table of drupal CMS, table name - cache_form and it size is 140 MB.
Is 'max_allowed_packet=32M' will be sufficient for this?

[MRatWork]

I have Mysql table of drupal CMS, table name - cache_form and it size is 140 MB.
Is 'max_allowed_packet=32M' will be sufficient for this?

max_allowed_packed not related to how big your table. Try increasing this value step-by-step.

[sandipcd]

Now the database has been imported in phpmyadmin.
But what 'max_allowed_packed' is all about ? What restriction it has and what should I keep in mind to avoid overload the 'max_allowed_packed' ?

-------------------------
I have written 'max_allowed_packed=32M' in /etc/my.cnf.d/server.cnf. But when I am trying to see it in SSH by giving command 'mysql --help |grep packet' - it is showing 16777216 (16MB). So, is it really change or not. How can I confirm this?

-------------------------
When I am writing 'max_allowed_packed=32M' in /etc/my.cnf, the Kloxo-MR panel showing error. What is the reason?

[MRatWork]

Now the database has been imported in phpmyadmin.
But what 'max_allowed_packed' is all about ? What restriction it has and what should I keep in mind to avoid overload the 'max_allowed_packed' ?

-------------------------
I have written 'max_allowed_packed=32M' in /etc/my.cnf.d/server.cnf. But when I am trying to see it in SSH by giving command 'mysql --help |grep packet' - it is showing 16777216 (16MB). So, is it really change or not. How can I confirm this?

-------------------------
When I am writing 'max_allowed_packed=32M' in /etc/my.cnf, the Kloxo-MR panel showing error. What is the reason?

Did you restart mysql/mariadb after change their config?.

As I said before, because using Kloxo-MR 7, change at /etc/my.cnf.d/server.cnf instead /etc/my.cnf.

[sandipcd]

Yes, I have given command 'sh /script/restart-mysql -y' to restart mysql. How do I restart Mariadb?
After giving this command still I got 16777216 (16MB). Any idea?

[MRatWork]

Running 'mysql --help|grep packet' just inform 'default' value (not real value).

To know real value, run 'mysql -u root -pYOURMYSQLROOTPASSWORD' and then input "SHOW VARIABLES LIKE 'max_allowed_packet';"