MySQL v Debian 6, zmeneny datadir

[Jaroslav Aster]

MaReK píše v St 17. 10. 2012 v 08:23 +0200:
> 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.

Podívejte se do souboru /var/log/daemon.log, zda tam mysql nepise
nejakou chybu. Pro me je to prvni soubor, kam se divam, kdyz mi blbne
mysql :-).

-- 
Jaroslav Aster <orm na humlak.cz>