Archive

Archive for the ‘mariadb’ Category

MariaDB 10.0.29 for Slackware 14.1 x64

January 27th, 2017 No comments

 

Update for Slackware x64 14.1 : latest version of MariaDB 10.0. This package was build on a Slackware 14.1 system. To use this package succesfully on a 14.1 system, you also need to install the jemalloc package (see my older post).

 
Downloads:

 

Enjoy 🙂

 

Categories: mariadb, slackpkg, slackware Views: 414

Upgrade MariaDB 5.5.x to 10.0.x on Slackware 14.1 x64

May 15th, 2016 No comments

 

Update for Slackware x64: latest version of MariaDB 10.0. This package was build on a Slackware 14.1 system. To build this package succesfully on a 14.1 system, you also need to install the jemalloc package.

 
Downloads:

 

How to upgrade from MariaDB 5.5.x to MariaDB 10.0.x

 
1. Start by downloading the 2 packages above.
 
2. Transfer these packages to the server you want to upgrade.
 
3. First install the jemalloc package:

installpkg jemalloc-3.6.0-x86_64-1.txz

 
4. Stop the running mysqld service:

/etc/rc.d/rc.mysqld stop

 
5. backup ALL your databases (make a copy of the entire /var/lib/mysql directory).

cp -a /var/lib/mysql/ /var/lib/mysql-BACKUP

 
6. Uninstall the MariaDB 5.5.x package (use removepkg or pkgtool).
 
7. Install the new MariaDB 10.0.25 package:

installpkg mariadb-10.0.25-x86_64-1.txz

 
8. Make sure /etc/rc.d/rc.mysqld is updated (overwrite the old rc.mysqld with rc.mysqld.new).
 
9. Start the mysqld service:

/etc/rc.d/rc.mysqld start

 
10. Check if mysqld is running now:

ps aux | grep mysql

 
11. Run mysql_secure_installation. Maybe this is not really necessary, but it doesn’t hurt to start clean. While you’re at it, you can set a new mysql root password here as well.
 
12. Run mysql_upgrade (MUST DO):

mysql_upgrade -u root -p

 
10. Restart the mysql service again (just to be sure).

/etc/rc.d/rc.mysqld restart

 
11. Now go check your DB’s and applications.

 

Enjoy 🙂
 
EDIT 27-Oct-2019: The above procedure is also valid when upgrading from say MariaDB 10.0 to 10.2 or later versions.

 

Categories: mariadb, slackpkg, slackware Views: 691

MariaDB 5.5.48

February 21st, 2016 No comments

 

Update to the latest version of MariaDB 5.5.x. This package was build on a Slackware 13.x system, but appears to work equally well on Slackware 14.1 x64.

 
For Slackware 13.x and 14.x x64:

 

Enjoy 🙂
 

Categories: mariadb, slackpkg, slackware Views: 479

MariaDB 5.5.47 for Slackware x64

December 13th, 2015 No comments

 

Update for Slackware x64: latest version of MariaDB 5.5.x. This package was build on a Slackware 13.x system, but appears to work equally well on Slackware 14.1 x64.

 
For Slackware 13.x and 14.x x64:

 

Enjoy 🙂
 

Categories: mariadb, slackpkg, slackware Views: 529

MariaDB 5.5.46 for Slackware x64

October 30th, 2015 No comments

 

Update for Slackware x64: latest version of MariaDB 5.5.x. This package was build on a Slackware 13.x system, but appears to work equally well on Slackware 14.1 x64.

 
For Slackware 13.x and 14.x x64:

 

Enjoy 😉
 

Categories: mariadb, slackpkg, slackware Views: 581

MariaDB 5.5.45 for Slackware x64

August 24th, 2015 No comments

 

Updated package for Slackware x64: latest version of MariaDB 5.5.x. This package was build on a Slackware 13.x system, but appears to work equally well on Slackware 14.1 x64.

 
For Slackware 13.x and 14.x x64:

 

Enjoy 😉
 

Categories: mariadb, slackpkg, slackware Views: 451