mysql 5 upgrade elhasal
Hola! Ma reggel upgrade tortent a Debian Etch gepemen. Felkuszott a mysql-server-5.0 5.0.32-7etch3. De nem indul el. A baj ugyanaz, mint a #411672 szamu hibajegyben: ... mysqld[14107]: 071127 6:31:21 [ERROR] Fatal error: Can 't open and lock privilege tables: Incorrect file format 'host' Javaslom aki meg teheti, tegye holdba a 4.1-es mysql-jet, amig meg nem oldodik ez a mostantol tomeges fejfajast okozo hiba. :-( kissg _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux
Re: mysql 5 upgrade elhasal
Kiss Gabor wrote: > Hola! > > Ma reggel upgrade tortent a Debian Etch gepemen. > Felkuszott a mysql-server-5.0 5.0.32-7etch3. > De nem indul el. > A baj ugyanaz, mint a #411672 szamu hibajegyben: > > ... mysqld[14107]: 071127 6:31:21 [ERROR] Fatal error: Can 't open and lock > privilege tables: Incorrect file format 'host' > > Javaslom aki meg teheti, tegye holdba a 4.1-es mysql-jet, > amig meg nem oldodik ez a mostantol tomeges fejfajast okozo hiba. :-( Ezt probaltad? http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html -- Gabor HALASZ <[EMAIL PROTECTED]> _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux
Re: mysql 5 upgrade elhasal
In article <[EMAIL PROTECTED]>, Gabor HALASZ <[EMAIL PROTECTED]> writes: >> A baj ugyanaz, mint a #411672 szamu hibajegyben: >> >> ... mysqld[14107]: 071127 6:31:21 [ERROR] Fatal error: Can 't open and lock >> privilege tables: Incorrect file format 'host' >> >> Javaslom aki meg teheti, tegye holdba a 4.1-es mysql-jet, >> amig meg nem oldodik ez a mostantol tomeges fejfajast okozo hiba. :-( > > Ezt probaltad? > > http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html Ez sem mukodik, ha nem fut a demon: $ mysql_upgrade /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect Error executing '/usr/bin/mysqlcheck --check-upgrade --all-databases --auto-repair --user=root' $ Megvarom, mit lepnek a Debian fiuk. Az adatbazisom jelenleg ugyis hasznalaton kivul van, nem sietek. :-) kissg _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux
Re: mysql 5 upgrade elhasal
Kiss Gabor wrote: > In article <[EMAIL PROTECTED]>, > Gabor HALASZ <[EMAIL PROTECTED]> writes: >>> A baj ugyanaz, mint a #411672 szamu hibajegyben: >>> >>> ... mysqld[14107]: 071127 6:31:21 [ERROR] Fatal error: Can 't open and >>> lock privilege tables: Incorrect file format 'host' >>> >>> Javaslom aki meg teheti, tegye holdba a 4.1-es mysql-jet, >>> amig meg nem oldodik ez a mostantol tomeges fejfajast okozo hiba. :-( >> Ezt probaltad? >> >> http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html > > Ez sem mukodik, ha nem fut a demon: --skip-grant-tables-sel probald a mysql-t inditani. -- Gabor HALASZ <[EMAIL PROTECTED]> _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux
Re: mysql 5 upgrade elhasal
In article <[EMAIL PROTECTED]>, Gabor HALASZ <[EMAIL PROTECTED]> writes: >>> http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html >> >> Ez sem mukodik, ha nem fut a demon: > > --skip-grant-tables-sel probald a mysql-t inditani. Ez esetben viszont: # mysql_upgrade ERROR 130 (HY000) at line 22: Incorrect file format 'user' ERROR 130 (HY000) at line 26: Incorrect file format 'user' ERROR 130 (HY000) at line 28: Incorrect file format 'user' ERROR 130 (HY000) at line 29: Incorrect file format 'host' ERROR 130 (HY000) at line 30: Incorrect file format 'db' ERROR 130 (HY000) at line 33: Incorrect file format 'user' ERROR 130 (HY000) at line 34: Incorrect file format 'db' ERROR 130 (HY000) at line 35: Incorrect file format 'host' ERROR 130 (HY000) at line 41: Incorrect file format 'user' ERROR 130 (HY000) at line 46: Incorrect file format 'user' ERROR 1061 (42000) at line 66: Duplicate key name 'Grantor' ERROR 1054 (42S22) at line 102: Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21) at line 124: Duplicate column name 'type' ERROR 130 (HY000) at line 132: Incorrect file format 'user' ERROR 130 (HY000) at line 134: Incorrect file format 'user' ERROR 130 (HY000) at line 145: Incorrect file format 'user' ERROR 130 (HY000) at line 151: Incorrect file format 'user' ERROR 130 (HY000) at line 161: Incorrect file format 'db' ERROR 130 (HY000) at line 164: Incorrect file format 'host' ERROR 130 (HY000) at line 168: Incorrect file format 'user' ERROR 130 (HY000) at line 171: Incorrect file format 'db' ERROR 130 (HY000) at line 172: Incorrect file format 'host' ERROR 130 (HY000) at line 173: Incorrect file format 'user' ERROR 130 (HY000) at line 178: Incorrect file format 'user' ERROR 130 (HY000) at line 182: Incorrect file format 'user' ERROR 130 (HY000) at line 207: Incorrect file format 'db' ERROR 130 (HY000) at line 212: Incorrect file format 'db' ERROR 130 (HY000) at line 226: Incorrect file format 'host' ERROR 130 (HY000) at line 230: Incorrect file format 'host' ERROR 130 (HY000) at line 253: Incorrect file format 'user' ERROR 130 (HY000) at line 258: Incorrect file format 'db' ERROR 130 (HY000) at line 259: Incorrect file format 'db' ERROR 130 (HY000) at line 261: Incorrect file format 'host' ERROR 130 (HY000) at line 262: Incorrect file format 'host' ERROR 130 (HY000) at line 264: Incorrect file format 'user' ERROR 130 (HY000) at line 265: Incorrect file format 'user' ERROR 130 (HY000) at line 270: Incorrect file format 'db' ERROR 130 (HY000) at line 271: Incorrect file format 'db' ERROR 130 (HY000) at line 273: Incorrect file format 'host' ERROR 130 (HY000) at line 274: Incorrect file format 'host' ERROR 130 (HY000) at line 276: Incorrect file format 'user' ERROR 130 (HY000) at line 277: Incorrect file format 'user' ERROR 130 (HY000) at line 282: Incorrect file format 'user' ERROR 130 (HY000) at line 288: Incorrect file format 'user' ERROR 130 (HY000) at line 293: Incorrect file format 'db' ERROR 130 (HY000) at line 294: Incorrect file format 'db' ERROR 130 (HY000) at line 296: Incorrect file format 'host' ERROR 130 (HY000) at line 297: Incorrect file format 'host' ERROR 130 (HY000) at line 299: Incorrect file format 'user' ERROR 130 (HY000) at line 300: Incorrect file format 'user' ERROR 130 (HY000) at line 305: Incorrect file format 'db' ERROR 130 (HY000) at line 306: Incorrect file format 'db' ERROR 130 (HY000) at line 308: Incorrect file format 'host' ERROR 130 (HY000) at line 309: Incorrect file format 'host' ERROR 130 (HY000) at line 311: Incorrect file format 'user' ERROR 130 (HY000) at line 312: Incorrect file format 'user' ERROR 130 (HY000) at line 314: Incorrect file format 'db' ERROR 130 (HY000) at line 315: Incorrect file format 'db' ERROR 130 (HY000) at line 317: Incorrect file format 'host' ERROR 130 (HY000) at line 318: Incorrect file format 'host' ERROR 130 (HY000) at line 323: Incorrect file format 'user' ERROR 130 (HY000) at line 324: Incorrect file format 'db' ERROR 130 (HY000) at line 325: Incorrect file format 'host' ERROR 130 (HY000) at line 330: Incorrect file format 'user' ERROR 130 (HY000) at line 337: Incorrect file format 'user' ERROR 130 (HY000) at line 339: Incorrect file format 'user' ERROR 130 (HY000) at line 340: Incorrect file format 'user' ERROR 130 (HY000) at line 341: Incorrect file format 'user' ERROR 130 (HY000) at line 362: Incorrect file format 'procs_priv' ERROR 130 (HY000) at line 366: Incorrect file format 'procs_priv' ERROR 130 (HY000) at line 370: Incorrect file format 'procs_priv' ERROR 130 (HY000) at line 374: Incorrect file format 'procs_priv' ERROR 130 (HY000) at line 428: Incorrect file format 'time_zone' ERROR 130 (HY000) at line 516: Incorrect file format 'proc' ERROR 130 (HY000) at line 560: Incorrect file format 'proc' ERROR 130 (HY000) at line 562: Incorrect file format 'proc' # Mondom: nem akarok en ezzel kiserletezni. g _ linux lista - linux@mlf.linux.rulez.org http://mlf
Re: mysql 5 upgrade elhasal
Kiss Gabor írta: > Ma reggel upgrade tortent a Debian Etch gepemen. > Felkuszott a mysql-server-5.0 5.0.32-7etch3. > De nem indul el. Ma reggel frissítettem ugyanezt a verziót. Csak annyi figyelmeztetést kaptam, hogy az ISAM táblákat frissítsem. apt-get upgrade rendesen leállította és újraindította. Üdv, János _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux
Re: mysql 5 upgrade elhasal
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Kiss Gabor) writes: http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html >>> >>> Ez sem mukodik, ha nem fut a demon: >> >> --skip-grant-tables-sel probald a mysql-t inditani. > > Ez esetben viszont: > > # mysql_upgrade > ERROR 130 (HY000) at line 22: Incorrect file format 'user' > ERROR 130 (HY000) at line 26: Incorrect file format 'user' > # Csak a jegyzokonyv kedveert: Nagyjabol sikerult helyrekalapalni a http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=411672 oldalon (Danai SAE-HAN, 08 Jul 2007 15:48:01 +0200) leirt modon. kissg _ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux