Mailinglisten-Archive |
hello all, i have a - to me - heavy problem with mysql; using debian and version: mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i386) using readline 4.3 we have two harddisks in our server where i tried to move the data-dir to the second drive to improve performance. i stopped mysql, copied all (Rp) from /var/lib/mysql to the new drive and symlinked it back to /var/lib/mysql. when i try starting mysql now i got the following errors in syslog: Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 InnoDB: Started; log sequence number 2 186695629 Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] Starting crash recovery... Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] Crash recovery finished. Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only Mar 21 20:11:00 localhost mysqld_safe[29700]: ended Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! the crazy thing on it is that if i copy the data-dir *the same way* to a directory on the first harddrive (where it comes from), set link it the same way etc., everything works as expected. the drives are mounted with the identical options in /etc/fstab, both contain ext3 as filesystem. it would be great if somebody of you can give me a hint since google gives me only 3 hits. best regards, andi -- Andreas Balke (Web Development) Digiden GmbH • Agentur für Kommunikationslösungen In der Backfabrik • Saarbrückerstraße 37b • D-10405 Berlin Fon: +49 (30) 446 749 425 • Fax: +49 (30) 446 749 479 www.digiden.de -------------- nächster Teil -------------- Ein Dateianhang mit Binärdaten wurde abgetrennt... Dateiname : smime.p7s Dateityp : application/x-pkcs7-signature Dateigröße : 3236 bytes Beschreibung: S/MIME Cryptographic Signature URL : http://lists.mushaake.org/pipermail/mysql-de/attachments/20070321/14aa1e6b/attachment.bin -------------- nächster Teil -------------- _______________________________________________ Allgemeine Infos zur Liste: http://www.4t2.com/mysql/ Verwaltung: https://lists.4t2.com/cgi-bin/mailman/listinfo/mysql-de
php::bar PHP Wiki - Listenarchive