MySQL v Debian 6, zmeneny datadir
Jaroslav Aster
orm na humlak.cz
Středa Říjen 17 14:56:53 CEST 2012
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>
Další informace o konferenci Linux