1 |
[sorry if this is duplicated, having some problems switching email |
2 |
client] |
3 |
|
4 |
Re: [gentoo-server] mysql-4.1 |
5 |
(Francesco R., Thu Oct 20 12:39:07 2005) |
6 |
Alle 06:42, giovedì 20 ottobre 2005, Ben Munat ha scritto: |
7 |
> I see that MySQL-4.1 has been marked stable... anyone have any |
8 |
> warnings I should heed before undertaking the upgrade (from |
9 |
|
10 |
Yes, I've spent some time with a user that had problem upgrading a phpBB |
11 |
site. |
12 |
|
13 |
|
14 |
first: a duplicate primary key, reproduce case below |
15 |
|
16 |
========= failed insert =========== |
17 |
DROP TABLE IF EXISTS `t1`; |
18 |
CREATE TABLE `t1` ( |
19 |
`f1` varchar(50) binary NOT NULL default '', |
20 |
primary KEY (`f1`) |
21 |
) ENGINE=MyISAM; |
22 |
|
23 |
|
24 |
/*!40000 ALTER TABLE `t1` DISABLE KEYS */; |
25 |
LOCK TABLES `t1` WRITE; |
26 |
INSERT INTO `t1` VALUES ( 0x686D6D),( 0x686D6DB2); |
27 |
/*!40000 ALTER TABLE `t1` ENABLE KEYS */; |
28 |
|
29 |
--ERROR 1062 (23000) at line 10: Duplicate entry 'hmm' for key 1 |
30 |
========= failed insert =========== |
31 |
|
32 |
the duplicate key is "hmm" with "hmm²" |
33 |
|
34 |
Another problem was MySQL importing truncated fields, |
35 |
the fields where truncated at charachter with dieresis. |
36 |
|
37 |
The solution here was to pipe the dump through iconv: |
38 |
|
39 |
# iconv -f ISO-8859-15 -t UTF-8 dump.sql | mysql |
40 |
|
41 |
The other problem was with php-4 and the well known connection charset |
42 |
problem. |
43 |
|
44 |
To be sincere we 've not solved the last one in a satisfing way, but |
45 |
this is my fault, it's way too much time I've setted up my boxes to |
46 |
work with php-5 and mysql-4.1. |
47 |
|
48 |
> 4.0.25-r2)? Francesco, you still lurking? |
49 |
> |
50 |
> b |
51 |
|
52 |
when having time ;-) |
53 |
|
54 |
-- |
55 |
gentoo-server@g.o mailing list |