You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MySQL installed via ports does not show version number?
- Thread starter pucky
- Start date
yep goto /usr/local/mysql/bin rm my* files then symlink all the mysql files in /usr/local/bin/ to there and symlink /usr/local/libexec/mysqld to there and the version umber will show again as well as mysql functions working in the control panel.
Chrysalis said:yep goto /usr/local/mysql/bin rm my* files then symlink all the mysql files in /usr/local/bin/ to there and symlink /usr/local/libexec/mysqld to there and the version umber will show again as well as mysql functions working in the control panel.
There is no such directory, /usr/local/mysql /bin on my server after MySQL 4.1.21 was installed via ports.
Those my* files are in /usr/local/bin/mysql
Last edited:
every DA server has the following directory.
/usr/local/mysql /bin
Its where DA installs its own mysql package, if yours isnt there then its either been wiped or your installation didnt completele properly.
as to why you have a /usr/local/bin/mysql directory I dont know, but ports doesnt create that directory and has a bin there with that name are you sure its a directory?
/usr/local/mysql /bin
Its where DA installs its own mysql package, if yours isnt there then its either been wiped or your installation didnt completele properly.
as to why you have a /usr/local/bin/mysql directory I dont know, but ports doesnt create that directory and has a bin there with that name are you sure its a directory?
Chrysalis said:every DA server has the following directory.
/usr/local/mysql /bin
Its where DA installs its own mysql package, if yours isnt there then its either been wiped or your installation didnt completele properly.
as to why you have a /usr/local/bin/mysql directory I dont know, but ports doesnt create that directory and has a bin there with that name are you sure its a directory?
This is a fresh install of Freebsd 6.1, two days old + DA
There was a /usr/local/mysql directory origionally but that was not an installed version of MySQL from the ports collection. It was DA's installation of MySQL (binary files only). I checked another Freebsd box which runs Freebsd 5.4 and there is no directory /usr/local/mysql on that box either. There never has been and that box is running cPanel, completely different CP but basically the same OS.
My current installation of Mysql41-server is installed and working fine. The files are in /usr/local/bin wth /home/mysql being the data directory.
On my Freebsd 5.4 server mysql is once again installed in /usr/local/bin with the data drectory being /var/lib/db and this was not touched ever but simply installed via the ports system so FreeBSD must have placed the files there for a reason.
According to the howto posted on these forums the idea was to rm -rf /usr/local/mysql before beginning the ports installation then it was up to ports to install the files where its supposed to install them. That howto is here, http://www.directadmin.com/forum/showthread.php?s=&threadid=14082&highlight=freebsd+mysql
Notice, how the /usr/local/mysql directory is removed in the HOWTO at the start of the upgrade? Are you saying this was the wrong thing to do?
Also, according to DA their installed version of MySQL is placed in /usr/local/mysql so i can see why this was done at the start of the HOWTO before installing the ports version of MySQL.
Thank you
Last edited:
yes the rm was wrong because DA itself is hardcoded to read mysql from that directory if it doesnt exist then things like backups will fail, importing dbs will fail and creating new databases also fail (i think) when using directadmin panel as its tries to use/local/mysql/bin/mysql I believe /usr/local/mysql/bin/mysqld needs to exist to get the version info. Thats why I rm the binaries (not the dir) then symlink the new ones there.