Re: mysql 4->5 problem
Mel Flynn wrote: > > On Saturday 06 June 2009 01:05:07 Randy Bush wrote: > > going from mysql 4 to 5.1.34. server will not start. diag is > > > > 090606 8:56:28 [ERROR] Fatal error: Can't open and lock privilege tables: > > Incorrect key file for table 'host'; try to repair it 090606 08:56:28 > > mysqld_safe mysqld from pid file /var/db/mysql/psg.com.pid ended > > > > googling around gets me to > > > > http://www.issociate.de/board/post/495472/SOLVED!_(was:_RE:_Error_:_Incorre > >ct_key_file_for_table_%27X%27).html to > > http://bugs.mysql.com/bug.php?id=37631 > > to > > http://lists.mysql.com/commits/73145 > > > > which says fix is in 5.1.35. > > > > i hack up some patches, except do not have the files > >mysql-test/std_data/bug37631.MYD > >mysql-test/std_data/bug37631.frm > > > > i rebuild. no fix. > > > > and, the error is after a "you can not go back" message. oh goodie. > > (yes, i have backups). > > > > any clues out there? > > You ran mysql_upgrade before starting the new server? mysql_upgrade requires a running server i ended up just o blowing /var/mysql/* away o starting new server o restoring from backup randy ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: mysql 4->5 problem
Mel Flynn wrote: On Thursday 11 June 2009 11:29:59 Philip M. Gollucci wrote: Mel Flynn wrote: You ran mysql_upgrade before starting the new server? Usually you have to start the server to run it. it conects to it to make changes to the 'mysql' database. Right. Sometimes aliases are evil: alias mysql_upgrade='/usr/local/libexec/mysqld --no-defaults --skip-grant- tables --socket=/tmp/mysql.sock --skip-networking --datadir=/var/db/mysql && /usr/local/bin/mysql_upgrade -S /tmp/mysql.sock; killall mysqld' Though, reading up on his error, I doubt it's the problem. Maybe we should consider adding an 'extra_command' called upgrade. -- 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Philip M. Gollucci (pgollu...@p6m7g8.com) c: 703.336.9354 Consultant - P6M7G8 Inc.http://p6m7g8.net Senior Sys Admin- RideCharge, Inc. http://ridecharge.com Contractor - PositiveEnergyUSA http://positiveenergyusa.com ASF Member - Apache Software Foundation http://apache.org FreeBSD Committer - FreeBSD Foundation http://freebsd.org Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: mysql 4->5 problem
On Thursday 11 June 2009 11:29:59 Philip M. Gollucci wrote: > Mel Flynn wrote: > > You ran mysql_upgrade before starting the new server? > > Usually you have to start the server to run it. it conects to it to make > changes to the 'mysql' database. Right. Sometimes aliases are evil: alias mysql_upgrade='/usr/local/libexec/mysqld --no-defaults --skip-grant- tables --socket=/tmp/mysql.sock --skip-networking --datadir=/var/db/mysql && /usr/local/bin/mysql_upgrade -S /tmp/mysql.sock; killall mysqld' Though, reading up on his error, I doubt it's the problem. -- Mel ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: mysql 4->5 problem
Mel Flynn wrote: You ran mysql_upgrade before starting the new server? Usually you have to start the server to run it. it conects to it to make changes to the 'mysql' database. -- 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Philip M. Gollucci (pgollu...@p6m7g8.com) c: 703.336.9354 Consultant - P6M7G8 Inc.http://p6m7g8.net Senior Sys Admin- RideCharge, Inc. http://ridecharge.com Contractor - PositiveEnergyUSA http://positiveenergyusa.com ASF Member - Apache Software Foundation http://apache.org FreeBSD Committer - FreeBSD Foundation http://freebsd.org Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: mysql 4->5 problem
On Saturday 06 June 2009 01:05:07 Randy Bush wrote: > going from mysql 4 to 5.1.34. server will not start. diag is > > 090606 8:56:28 [ERROR] Fatal error: Can't open and lock privilege tables: > Incorrect key file for table 'host'; try to repair it 090606 08:56:28 > mysqld_safe mysqld from pid file /var/db/mysql/psg.com.pid ended > > googling around gets me to > > http://www.issociate.de/board/post/495472/SOLVED!_(was:_RE:_Error_:_Incorre >ct_key_file_for_table_%27X%27).html to > http://bugs.mysql.com/bug.php?id=37631 > to > http://lists.mysql.com/commits/73145 > > which says fix is in 5.1.35. > > i hack up some patches, except do not have the files >mysql-test/std_data/bug37631.MYD >mysql-test/std_data/bug37631.frm > > i rebuild. no fix. > > and, the error is after a "you can not go back" message. oh goodie. > (yes, i have backups). > > any clues out there? You ran mysql_upgrade before starting the new server? -- Mel ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
mysql 4->5 problem
going from mysql 4 to 5.1.34. server will not start. diag is 090606 8:56:28 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'host'; try to repair it 090606 08:56:28 mysqld_safe mysqld from pid file /var/db/mysql/psg.com.pid ended googling around gets me to http://www.issociate.de/board/post/495472/SOLVED!_(was:_RE:_Error_:_Incorrect_key_file_for_table_%27X%27).html to http://bugs.mysql.com/bug.php?id=37631 to http://lists.mysql.com/commits/73145 which says fix is in 5.1.35. i hack up some patches, except do not have the files mysql-test/std_data/bug37631.MYD mysql-test/std_data/bug37631.frm i rebuild. no fix. and, the error is after a "you can not go back" message. oh goodie. (yes, i have backups). any clues out there? randy ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"