MySQL can’t start after updating from 5.1 to 5.5

After updating a MySQL server from 5.1.73 to 5.5.4 it won’t start. To see what was going on I checked the logs:

# tail /var/log/mysql.log
141221 13:23:41  InnoDB: Waiting for the background threads to start
141221 13:23:42 InnoDB: 5.5.41 started; log sequence number 1589339
141221 13:23:42 [ERROR] /usr/libexec/mysqld: unknown variable 'record_buffer=1M'
141221 13:23:42 [ERROR] Aborting

It was obvious that many things had changed form 5.1 to 5.5 and in this case the reason to the problem was that record_buffer has been deprecated and now it’s called read_buffer_size. Changing the name of it in /etc/my.cnf fixed the problem.

mysql

You might also like

CentOS “Error: php-mysql conflicts with php-mysqlnd” updating with PHP 7.0
If you get an error about a conflict between php-mysql and php-mysqlnd when updating CentOS packages...

Change root password in MySQL
In GNU/Linux:$ sudo mysqld_safe --skip-grant-tables & $ mysql -u root -p #press enter to use a...

Connect to MySQL over SSH with MySQL Workbench
If you don't have phpMyAdmin installed on your server or you don't feel comfortable using it there's...

Fix “Communications link failure” in Java applications with MySQL
You may have problems connecting to MySQL from Java applications using Connector/J (the Java connector...

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.