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