MySQL 5.1.46 is now available

May 14, 2010 · Guillaume Plessis

MySQL 5.1.46 is now available on Dotdeb for your Lenny servers, in amd64 and i386 flavours. It fixes a lot of annoying bugs and upgrades the InnoDB plugin to version 1.0.7 for more performances.

Be careful : the MySQL server is now split in two separate packages :

mysql-server-core-5.1 that contains only the mysqld binary and some system files,
mysql-server-5.1 that depends on mysql-server-core-5.1 and that contains the init scripts and utilities to run the MySQL server in a Debian environment.

The migration to this new packaging schema is transparent and will not break any dependencies.

As usual, please read the changes in MySQL 5.1.46 and what’s new in the InnoDB plugin 1.0.7 before upgrading.

littlecho May 15, 2010
Hello, While I upgrade to the version 5.1.46, I get a notice about “Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.45.” from phpmyamdin. Can you give me some idea to fixed this warning msg?
- Guillaume Plessis May 15, 2010
  @littleecho : They are PHP client-side pieces of information. PHP is built against the old libmysqlclient15off (5.0.51a) to avoid Apache-related issues and segfaults. Anyway, 5.0.51a-linked clients interacts with a 5.1.46 server without any issue. Just tweak PHPMyAdmin to avoid the display.
littlecho May 15, 2010
Okay,I got it.Many thanks!!
Sorin May 17, 2010
I tried today to update to the new version:
Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) … Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action “stop” failed. dpkg: warning - old pre-removal script returned error exit status 1 dpkg - trying script from the new package instead … Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action “stop” failed. dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): subprocess new pre-removal script returned error exit status 1 Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action “stop” failed. Starting MySQL database server: mysqld already running. dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1: mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2) mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed. dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): conflicting packages - not installing mysql-server-core-5.1 Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover.
Any solution to this ?
- Guillaume Plessis May 17, 2010
  Strange. Follow these steps :
  Stop MySQL manually :/etc/init.d/mysql stop Place an exit 0 at the beginning of /etc/init.d/mysql Try to upgrade Remove the previously-inserted exit 0
Import Worker May 19, 2010
Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: warning – old pre-removal script returned error exit status 1dpkg – trying script from the new package instead …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): subprocess new pre-removal script returned error exit status 1Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.Starting MySQL database server: mysqld already running.dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1: mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2) mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed.dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): conflicting packages – not installing mysql-server-core-5.1Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.debE: Sub-process /usr/bin/dpkg returned an error code (1)A package failed to install. Trying to recover. +1
Guillaume Plessis May 19, 2010
@Import Worker : as written on the above comment :
Follow these steps :
Stop MySQL manually :/etc/init.d/mysql stop Place an exit 0 at the beginning of /etc/init.d/mysql Try to upgrade Remove the previously-inserted exit 0
Steve May 28, 2010
Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: warning – old pre-removal script returned error exit status 1dpkg – trying script from the new package instead …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): subprocess new pre-removal script returned error exit status 1Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.Starting MySQL database server: mysqld already running.dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1: mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2) mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed.dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): conflicting packages – not installing mysql-server-core-5.1Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.debE: Sub-process /usr/bin/dpkg returned an error code (1)A package failed to install. Trying to recover. +1
- Guillaume Plessis May 29, 2010
  @Steve : Follow these steps…
  - Stop MySQL manually :/etc/init.d/mysql stop
  - Place an exit 0 at the beginning of /etc/init.d/mysql
  - Try to upgrade
  - Remove the previously-inserted exit 0