MySQL v Debian 6, zmeneny datadir
MaReK
marek.olsavsky na gmail.com
Středa Říjen 17 08:23:01 CEST 2012
Dobry den,
zkusim poprosit o pomoc s hledanim reseni.
Instaloval jsem mensi webserver, na aktualnim Debianu. SDA je ssd pro
system a home, SDB je standardni plotnovy disk, dedikovany na
adresare v "/srv/", prekonfiguroval sluzby httpd (s Apache zadny
problem neni) a MySQL.
V konfiguracnim souboru /etc/mysql/my.cnf je:
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /srv/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
Adresar /var/run/mysqld/ existuje, a jeho ownerem je MySQL.
Kupodivu databaze asi funguje, weby na serveru bezi, ale presto hledam
chybu (v chovani):
Restart serveru:
root na BlueNot:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root na vincent:~# ERROR 2013 (HY000) at line 1: Lost connection to MySQL
server during query
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (111)
Zaloha DB:
root na BlueNot:~# mysqldump -q -h localhost -u root -p zsjedna > zsjedna.sql
Enter password:
mysqldump: Got error: 2013: Lost connection to MySQL server during
query when using LOCK TABLES
Mimo jine se odhlasuje PHPMyAdmin i Adminer v momente, kdy se pokusim
o otevreni vetsi DB, nebo ji chci vyexportovat (ale to bude souviset s
tou jedinou chybou)
Kdyz mysql bezi, tak vidim (nicmene chyby zustavaji):
ls -lah /var/run/mysqld/
celkem 12K
drwxr-xr-x 2 mysql mysql 4,0K 17. říj 08.12 .
drwxr-xr-x 14 root root 4,0K 17. říj 06.51 ..
-rw-rw---- 1 mysql mysql 5 17. říj 08.12 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 17. říj 08.12 mysqld.sock
netstat --numeric-hosts --programs -u -t
Aktivní Internetová spojení (w/o servery)
Proto Přích-F Odch-F Místní Adresa Vzdálená Adresa
Stav PID/Program name
tcp 0 0 127.0.0.1:44xxx 127.0.0.1:www
TIME_WAIT -
tcp 0 0 127.0.0.1:60xxx 127.0.0.1:ftp
TIME_WAIT -
tcp 0 192 77.237.129.34:ssh 85.71.199.34:27884
SPOJENO 4806/0
Ted mne nenapada dalsi potrebny udaj, kam se podivat, pripadne co zmenit.
Dekuji za nejake nasmerovani
MaReK Olsavsky
Další informace o konferenci Linux