Tag Archives: .my.cnf

You are here:

Home
Entries tagged with ".my.cnf"

MySQL: ERROR 1153 (08S01) at line 1355: Got a packet bigger than ‘max_allowed_packet’ bytes

ErrorsBy alex December 8, 2010 Leave a comment

Recently I needed to modify a MySQL database from a latin1 character set to a utf8 character set which I may write an article on later however when importing the MySQL dumped data back into a new database I received an error complaining about the packet size. This can easily be worked around using the…

Configure Logrotate To Rotate And Flush MySQL Logs Without A Password

InsightsBy alex December 20, 2009 22 Comments

If you have the resources (CPU + RAM) available on your server then its can be a great troubleshooting tool if you enable MySQL logging which includes server messages, SQL query logs, and slow query logs. If you do not have the resources I would suggest only enable minimal logging such as only server messages…