10.3/unstable, trying to install latest mysql (5.0.38-1) with the previous version of that package (5.0.34-6) installed, I got:
Setting up mysql (5.0.38-1) ... Installing MySQL system tables... 070403 12:42:22 [Warning] Setting lower_case_table_names=2 because file system for /sw/var/mysql/ is case insensitive ERROR: 1136 Column count doesn't match value count at row 1 070403 12:42:23 [ERROR] Aborting 070403 12:42:23 [Note] /sw/sbin/mysqld: Shutdown complete Installation of system tables failed! Looking at the PostInst, I see it's doing: # create initial database # it is safe to call mysql_install_db even if a db is already present /sw/bin/mysql_install_db --user=mysql Digging into that script, apparently it doesn't realize I already have a mysql database installed, so it tries to set up a new one, which is different from the old. Got a lot of errors from the mysql_upgrade script that mysql_install_db, so gave up and started over: rm -rf /sw/var/mysql dpkg --r mysql fink install mysql That worked. For fun, I tried 'fink reinstall mysql', which gives: Installing MySQL system tables... 070404 1:08:10 [Warning] Setting lower_case_table_names=2 because file system for /sw/var/mysql/ is case insensitive ERROR: 1062 Duplicate entry '%-test-' for key 1 070404 1:08:10 [ERROR] Aborting So it's reproducibly impossible to install mysql without throwing away my old intallation entirely? That's bad. dan -- Daniel Macks [EMAIL PROTECTED] http://www.netspace.org/~dmacks ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Fink-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fink-devel
