Re: [gentoo-server] mysql-4.1

["Francesco R." <vivo@gentoo.org>]

[sorry if this is duplicated, having some problems switching email 
client]

Re: [gentoo-server] mysql-4.1
 (Francesco R., Thu Oct 20 12:39:07 2005)
Alle 06:42, giovedì 20 ottobre 2005, Ben Munat ha scritto:
> I see that MySQL-4.1 has been marked stable... anyone have any
> warnings I should heed before undertaking the upgrade (from

Yes, I've spent some time with a user that had problem upgrading a phpBB 
site.


first: a duplicate primary key, reproduce case below

========= failed insert ===========
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
  `f1` varchar(50) binary NOT NULL default '',
  primary KEY  (`f1`)
) ENGINE=MyISAM;


/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
LOCK TABLES `t1` WRITE;
INSERT INTO `t1` VALUES ( 0x686D6D),( 0x686D6DB2);
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;

--ERROR 1062 (23000) at line 10: Duplicate entry 'hmm' for key 1
========= failed insert ===========

the duplicate key is "hmm" with "hmm²"

Another problem was MySQL importing truncated fields, 
the fields where truncated at charachter with dieresis.

The solution here was to pipe the dump through iconv:

# iconv -f ISO-8859-15 -t UTF-8 dump.sql | mysql 

The other problem was with php-4 and the well known connection charset 
problem.

To be sincere we 've not solved the last one in a satisfing way, but 
this is my fault, it's way too much time I've setted up my boxes to 
work with php-5 and mysql-4.1.

> 4.0.25-r2)? Francesco, you still lurking?
>
> b

when having time ;-)

-- 
gentoo-server@gentoo.org mailing list