Updating mySQL to 4.1.20 on FreeBSD 5.4

Is it possible? The only versions listed on the mySQL site after the version I'm currently using are for FreeBSD 6.x. Is it possible to use one of those on 5.x?

Read this post
http://help.directadmin.com/item.php?id=106 or this one http://www.directadmin.com/forum/showthread.php?s=&threadid=14082

ArielHost said:

Is it possible? The only versions listed on the mySQL site after the version I'm currently using are for FreeBSD 6.x. Is it possible to use one of those on 5.x?

Click to expand...

NO dont use the one for freebsd 6.
1.stop mysql
delete /usr/local/mysql

2. install freebsd 4.1.21 from the ports, then you need to go to /var/db/mysql and delete mysql, and link mysql to /home/mysql

3. for system backup, edit /usr/local/sysbk/sysbk.conf and change paths to new mysql install and the pid

4. for php you need to edit the configure.php in /usr/local/directadmin and change --with-mysql to --with-mysql=/usr/local \

Just wait a day or so for the DA team to make a bundle for your specific version of freebsd - they have in the past

Re: Re: Updating mySQL to 4.1.20 on FreeBSD 5.4

FreeBsd5 said:

2. install freebsd 4.1.21 from the ports, then you need to go to /var/db/mysql and delete mysql, and link mysql to /home/mysql

Click to expand...

Just put mysql_dbdir="/home/mysql" in /etc/rc.conf. Works fine.