server:/usr/local/directadmin/custombuild# ./build mysql d
Dumping database admin_avtzis
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database admin_billing
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database admin_ehost
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database admin_jcontact
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database admin_portal
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database admin_projects
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database arisj_bjj
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database da_roundcube
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database gameplanet_yasoo
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database mysql
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database nestoridis_shop
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database test
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database tsantek_tsantek
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database xtremegr_jom
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database yiouhou_blog
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database yiouhou_portal
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Dumping database zaxaro_wines
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
Stopping mysqld ...
Starting mysqld: [ OK ]
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/local/mysql/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
Running 'mysqlcheck'...
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
/usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
Restarting MySQL.
Stopping mysqld: [ FAILED ]
Starting mysqld: [ OK ]
It is recommended to do "./build php n" after MySQL update.
server:/usr/local/directadmin/custombuild# netstat -lnp |grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 12552/mysqld
unix 2 [ ACC ] STREAM LISTENING 38755 12552/mysqld /tmp/mysql.sock
server:/usr/local/directadmin/custombuild# /etc/init.d/mysqld restart
Stopping mysqld: [ FAILED ]
Starting mysqld: [ OK ]
server:/usr/local/directadmin/custombuild# ps aux | grep mysql
root 12483 0.0 0.0 3896 1288 pts/0 S 03:51 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --log-error=/var/log/messages --user=mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/server.pid
mysql 12552 0.0 0.9 102964 18708 pts/0 Sl 03:51 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --log-error=/var/log/messages.err --pid-file=/usr/local/mysql/data/server.pid
root 12723 0.6 0.0 3892 1284 pts/0 S 03:57 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --log-error=/var/log/messages --user=mysql --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/server.pid
mysql 12788 0.0 0.5 65960 10712 pts/0 Sl 03:57 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --log-error=/var/log/messages.err --pid-file=/usr/local/mysql/data/server.pid
root 12802 0.0 0.0 3116 716 pts/0 S+ 03:58 0:00 grep mysql
This is the error that I'm getting everytime I try to upgrade to MySQL 5.1. I read all posts related to this issue in this forum but nothing helped.
I run some commands so they maybe help you guys on helping me solve this issue
I have two my.cnf files one is located on /etc/my.cnf and the other is located on /etc/mysql/my.cnf how ever i renamed the one under /etc/mysql to my.cnf.bk and created a symbolic there so now I have a symbolic link /etc/mysql/my.cnf that is poiting to /etc/my.cnf.
The contents of my.cnf are:
Code:
[mysqld]
local-infile=0
My "mysql.sock" is under /tmp folder but I'm getting the error that says that it cannot connect through /tmp/mysql.sock...
/var/log/messages does not contain any error related to mysql.
/home/mysql/server.topsrv.com.err have this in the error log:
Code:
090704 3:40:12 InnoDB: Starting shutdown...
090704 3:40:13 InnoDB: Shutdown completed; log sequence number 0 263626315
090704 3:40:13 [Warning] Forcing shutdown of 1 plugins
090704 3:40:13 [Note]
090704 03:40:13 mysqld_safe mysqld from pid file /usr/local/mysql/data/server.pid ended
090704 03:42:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090704 3:42:35 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
/usr/local/mysql/bin/mysqld: Unknown error 1146
090704 3:42:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090704 3:42:35 InnoDB: Started; log sequence number 0 263626315
090704 3:42:35 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--skip-bdb'
090704 3:42:35 [ERROR] Aborting
090704 3:42:35 InnoDB: Starting shutdown...
090704 3:42:37 InnoDB: Shutdown completed; log sequence number 0 263626315
090704 3:42:37 [Warning] Forcing shutdown of 1 plugins
090704 3:42:37 [Note]
090704 03:42:37 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql.pid ended
On /usr/local/mysql/data/ there isn't any server.pid and mysql.pid files.
The folder /usr/share/mysql does not exist, only the mysql-common is under /usr/share
Hope these help...