mysql 4.0.22

use tool from other thread

Code: 
wget [url]http://www.l0rdphi1.com/tools/update.mysql.sh[/url]
sh update.mysql.sh
Remember to use 4.0.22 when asked
Worked great, just had to restart mysql.
 
No, that tool is for RedHat.
I released a tool for freebsd 4.x but it will not work with the new 5.x series because mysql.com has not released any binaries for it. At this time, it must be compiled.
 
I use the port version of mysql with directadmin with no issue on freebsd 5.x to do so follow these steps.

upgrade ports tree via cvsup
cd /usr/ports/databases/mysql40-server
make DB_DIR=/usr/local/mysql/data install clean
cd /usr/local/etc/rc.d
cp mysql-server.sh mysqld
 
Now that 5.3 has been released, they should probably have a binary available in the near future.
 
Chrysalis said:
I use the port version of mysql with directadmin with no issue on freebsd 5.x to do so follow these steps.

upgrade ports tree via cvsup
cd /usr/ports/databases/mysql40-server
make DB_DIR=/usr/local/mysql/data install clean
cd /usr/local/etc/rc.d
cp mysql-server.sh mysqld
Click to expand...

Will it break DA if I do that?

Thank you!
 
It wont break DA if done right but can break DA if some steps are mixed. By default mysql uses a different db dir to the one DA set's so if this isn't specified then your current db's would stop functioning, the other potential issue is that every min DA checks for dead processes and if mysqld is down it runs /usr/local/etc/rc.d/mysqld which points to the DA installed mysql so I renamed that file and copied /usr/local/etc/rc.d/mysql-server.sh to it and that will make DA run the ports version instead, with these 2 points addressed you should have no issues at all. My DA has been functioning fine for weeks like this. As a bonus it makes upgrading mysql a doddle since doing it via the ports is much simpler.
 
Thank you, Chrysalis!
Yeah, it may make our admins' life easier if they used port version instead ;)
 
This tool has a little bug.

It will generate duplicate MySQL init script in /etc/rc*.d/

S90mysql and S90mysqld

just del S90mysql
 
Last edited:
Sorry, justa hardware problem! Please ignore this!
 
Last edited:
dan35 compile segment faults usually are a sign of ram failing, but you can try compiling linuxthreads seperatly first like this.

cd /usr/ports/devel/linuxthreads
make LINUXTHREADS_DETECT_UNSAFE_EXIT=yes WITH_CONDWAIT_PATCH=yes install clean

aand then try compiling the mysql port again as above.
 
You're right, Chrysalis! I also found out this info on FreeBSD mailing list.
"There is a FAQ entry on this, but the short answer is:
If you try to make world multiple times, and it segfaults at a different
part of the process each time, it's probably faulty hardware."

And I had a tech guy check the hardware.

You're really helpful and damn cool, Chrysalis :)

I really appreciate that!
 
Last edited:
i dont know the line command to update port list...

'cause my mysql stop every day.. 'cause i'm stupid and now it doesnt work correctly and i've to restore as soon as :(
 
look for a howto on how to use cvsup, I think there is 1 on this forum somewhere and loads on google.

To find out why your mysqld is crashing goto the db dir and read your log.
 
You must log in or register to reply here.
Back
Top