i was updating mysql but it fails and i'm getting error message now

FileSick

Verified User
Joined
Oct 5, 2013
Messages
104
hello

i was trying to update php, mysql and apache

updated all of them but when i type this command " ./build mysql d "

i'm getting this error

Code:
Stopping mysqld ...
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
 ERROR! MySQL server PID file could not be found!
Updating MySQL 5.1.73 to 5.1.73
Preparing...                ########################################### [100%]
        package MySQL-shared-5.1.73-1.glibc23.x86_64 is already installed
        package MySQL-devel-5.1.73-1.glibc23.x86_64 is already installed
        package MySQL-client-5.1.73-1.glibc23.x86_64 is already installed
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
Starting MySQL ERROR! Couldn't find MySQL server (/usr/bin/mysqld_safe)
Giving mysqld a few seconds to start up...
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
 ERROR! MySQL server PID file could not be found!
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
Starting MySQL ERROR! Couldn't find MySQL server (/usr/bin/mysqld_safe)
It is recommended to do "./build php n" after MySQL update.

one last thing before doing this update by following updating guide and i just found out that this guide is 2012 old i read that mysql before the update was 5.5 and now it's 5.1

here is my website too cause there is couple of other error messages on the home page too

http://www.filesick.com/

so could you please help me out and tell me what to ASAP please

waiting for your responds
 
If you'd like to go back to 5.5, please try:
Code:
cd /usr/local/directadmin/custombuild
./build update
./build set mysql 5.5
./build mysql
 
If you'd like to go back to 5.5, please try:
Code:
cd /usr/local/directadmin/custombuild
./build update
./build set mysql 5.5
./build mysql

thank you so much for your fast respond i just pasted the commands and it's giving me error message and here is it

Please check its status, then do
rm /var/lib/mysql/RPM_UPGRADE_MARKER
before repeating the MySQL upgrade.
error: %pre(MySQL-server-5.5.40-1.linux2.6.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.5.40-1.linux2.6
2:MySQL-devel ########################################### [ 50%]
3:MySQL-client ########################################### [ 75%]
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
Starting MySQL ERROR! Couldn't find MySQL server (/usr/bin/mysqld_safe)
Giving mysqld a few seconds to start up...
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
ERROR! MySQL server PID file could not be found!
/etc/init.d/mysqld: line 256: my_print_defaults: command not found
Starting MySQL ERROR! Couldn't find MySQL server (/usr/bin/mysqld_safe)
It is recommended to do "./build php n" after MySQL update.

waiting for your respond
 
Something is still not okay there. May I check why it broke? (that would be free of charge)
 
The following fixed the issue:
Code:
rm -f /var/lib/mysql/RPM_UPGRADE_MARKER
./build mysql
 
Back
Top