mysql 4.0(freebsd) 升级到5.0+(linux)的出现的问题
上一篇 / 下一篇 2007-09-04 02:49:18 / 个人分类：LAMP
mysql> desc cdb_attachments;
c'H JdX)~7c8v0+-------------+-----------------------+------+-----+---------+----------------+
&X'{9j)U [0| Field | Type | Null | Key | Default | Extra |
s,Yi B Juy%[U0+-------------+-----------------------+------+-----+---------+----------------+
H$Z3oT3Z \0| aid | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |木铎校园 BBS 社区*B6?a iy0N-V-v1|
| tid | mediumint(8) unsigned | NO | MUL | 0 | |
g^-e d4xw2L0| pid | int(10) unsigned | NO | MUL | 0 | |
k~9hqa }4Reo3L0| dateline | int(10) unsigned | NO | | 0 | |
]7~9r6| ^ G!}7V0| readperm | tinyint(3) unsigned | NO | | 0 | |
+dR1|!Y.@] P0| price | smallint(6) unsigned | NO | | 0 | |木铎校园 BBS 社区u2g%i @ J:G C
| filename | char(50) | NO | | NULL | |木铎校园 BBS 社区 J6o+W C'x
| description | char(50) | NO | | NULL | |
F.W d X f#Fs0| filetype | char(25) | NO | | NULL | |
3nK4Kz#zw(L6|3`0| filesize | int(10) unsigned | NO | | 0 | |木铎校园 BBS 社区W8z"NoW1p l,q6{'G,R%q~:S
| attachment | char(50) | NO | | NULL | |木铎校园 BBS 社区q3b[9}P#kI
| downloads | mediumint(8) | NO | | 0 | |木铎校园 BBS 社区*hKMM9O aC XdL!X1s
| isimage | tinyint(1) unsigned | NO | | 0 | |木铎校园 BBS 社区#_:Q3^&c7k4v!e_ D
| uid | mediumint(8) unsigned | NO | MUL | 0 | |木铎校园 BBS 社区8E;h:pS u8^+S
| thumb | tinyint(1) unsigned | NO | | 0 | |木铎校园 BBS 社区Wnl Gv'C$B$h
| remote | tinyint(1) unsigned | NO | | 0 | |
E7Pg A H k!q0+-------------+-----------------------+------+-----+---------+----------------+
\;o)fWKsA j016 rows in set (0.01 sec)木铎校园 BBS 社区v/U E4T"? Ag$p
/~ Y)hs f7d5S Up:p(D0
o X D%z*G+\rt E0mysql> desc cdb_attachments;
O/a s GkM0+-------------+-----------------------+------+-----+---------+----------------+
8t Z5r6{ n(\ vG!m0| Field | Type | Null | Key | Default | Extra |木铎校园 BBS 社区2V8A6i&H }w,jL$G
+-------------+-----------------------+------+-----+---------+----------------+木铎校园 BBS 社区4v8kMt F+|9Ko*Y^{!U
| aid | mediumint(8) unsigned | | PRI | NULL | auto_increment |
fp9?5ZMG7v6u:o0| tid | mediumint(8) unsigned | | MUL | 0 | |
gN4A*k~ S P7|:|:c0| pid | int(10) unsigned | | MUL | 0 | |木铎校园 BBS 社区 j.kg8m&tX~ n
| dateline | int(10) unsigned | | | 0 | |
d A(a$C6N0| readperm | tinyint(3) unsigned | | | 0 | |木铎校园 BBS 社区5r$Od ]_
| price | smallint(6) unsigned | | | 0 | |木铎校园 BBS 社区7g5])Z1N3\7`m
| filename | char(100) | | | | |木铎校园 BBS 社区6` a2{ ^`x P
| description | char(100) | | | | |
;fK:gxK0o6_3iX/N0| filetype | char(50) | | | | |
mB.gu o"\:z0| filesize | int(10) unsigned | | | 0 | |
S O{ y NHJR0| attachment | char(100) | | | | |
i \/u;}}y(v0| downloads | mediumint(8) | | | 0 | |
!z.?8c \ wB \#s:K(U0| isimage | tinyint(1) unsigned | | | 0 | |
6Ig O;[ u#b&n \,B-m,e F0| uid | mediumint(8) unsigned | | MUL | 0 | |
:t;J]7](W6Z N0| thumb | tinyint(1) unsigned | | | 0 | |
skq6G cl%DE E0| remote | tinyint(1) unsigned | | | 0 | |木铎校园 BBS 社区8uZl)G%L:Z;pOH_V)^'F
+-------------+-----------------------+------+-----+---------+----------------+木铎校园 BBS 社区!`ax/z-V~H&X'HR
16 rows in set (0.00 sec)木铎校园 BBS 社区%k&z:s H#WFp
木铎校园 BBS 社区 ~:l9\6[f#m"R9D)V
上面的是freebsd上mysql4.0+的表结构，将表文件直接copy到linux下，启用mysql5.0+,表结构如下面的表。。。
nAt#F0? b tX4w0
!T Mr(r G;U:o0木铎校园 BBS 社区 b5P7| Yszh
c'H JdX)~7c8v0+-------------+-----------------------+------+-----+---------+----------------+
&X'{9j)U [0| Field | Type | Null | Key | Default | Extra |
s,Yi B Juy%[U0+-------------+-----------------------+------+-----+---------+----------------+
H$Z3oT3Z \0| aid | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |木铎校园 BBS 社区*B6?a iy0N-V-v1|
| tid | mediumint(8) unsigned | NO | MUL | 0 | |
g^-e d4xw2L0| pid | int(10) unsigned | NO | MUL | 0 | |
k~9hqa }4Reo3L0| dateline | int(10) unsigned | NO | | 0 | |
]7~9r6| ^ G!}7V0| readperm | tinyint(3) unsigned | NO | | 0 | |
+dR1|!Y.@] P0| price | smallint(6) unsigned | NO | | 0 | |木铎校园 BBS 社区u2g%i @ J:G C
| filename | char(50) | NO | | NULL | |木铎校园 BBS 社区 J6o+W C'x
| description | char(50) | NO | | NULL | |
F.W d X f#Fs0| filetype | char(25) | NO | | NULL | |
3nK4Kz#zw(L6|3`0| filesize | int(10) unsigned | NO | | 0 | |木铎校园 BBS 社区W8z"NoW1p l,q6{'G,R%q~:S
| attachment | char(50) | NO | | NULL | |木铎校园 BBS 社区q3b[9}P#kI
| downloads | mediumint(8) | NO | | 0 | |木铎校园 BBS 社区*hKMM9O aC XdL!X1s
| isimage | tinyint(1) unsigned | NO | | 0 | |木铎校园 BBS 社区#_:Q3^&c7k4v!e_ D
| uid | mediumint(8) unsigned | NO | MUL | 0 | |木铎校园 BBS 社区8E;h:pS u8^+S
| thumb | tinyint(1) unsigned | NO | | 0 | |木铎校园 BBS 社区Wnl Gv'C$B$h
| remote | tinyint(1) unsigned | NO | | 0 | |
E7Pg A H k!q0+-------------+-----------------------+------+-----+---------+----------------+
\;o)fWKsA j016 rows in set (0.01 sec)木铎校园 BBS 社区v/U E4T"? Ag$p
/~ Y)hs f7d5S Up:p(D0
o X D%z*G+\rt E0mysql> desc cdb_attachments;
O/a s GkM0+-------------+-----------------------+------+-----+---------+----------------+
8t Z5r6{ n(\ vG!m0| Field | Type | Null | Key | Default | Extra |木铎校园 BBS 社区2V8A6i&H }w,jL$G
+-------------+-----------------------+------+-----+---------+----------------+木铎校园 BBS 社区4v8kMt F+|9Ko*Y^{!U
| aid | mediumint(8) unsigned | | PRI | NULL | auto_increment |
fp9?5ZMG7v6u:o0| tid | mediumint(8) unsigned | | MUL | 0 | |
gN4A*k~ S P7|:|:c0| pid | int(10) unsigned | | MUL | 0 | |木铎校园 BBS 社区 j.kg8m&tX~ n
| dateline | int(10) unsigned | | | 0 | |
d A(a$C6N0| readperm | tinyint(3) unsigned | | | 0 | |木铎校园 BBS 社区5r$Od ]_
| price | smallint(6) unsigned | | | 0 | |木铎校园 BBS 社区7g5])Z1N3\7`m
| filename | char(100) | | | | |木铎校园 BBS 社区6` a2{ ^`x P
| description | char(100) | | | | |
;fK:gxK0o6_3iX/N0| filetype | char(50) | | | | |
mB.gu o"\:z0| filesize | int(10) unsigned | | | 0 | |
S O{ y NHJR0| attachment | char(100) | | | | |
i \/u;}}y(v0| downloads | mediumint(8) | | | 0 | |
!z.?8c \ wB \#s:K(U0| isimage | tinyint(1) unsigned | | | 0 | |
6Ig O;[ u#b&n \,B-m,e F0| uid | mediumint(8) unsigned | | MUL | 0 | |
:t;J]7](W6Z N0| thumb | tinyint(1) unsigned | | | 0 | |
skq6G cl%DE E0| remote | tinyint(1) unsigned | | | 0 | |木铎校园 BBS 社区8uZl)G%L:Z;pOH_V)^'F
+-------------+-----------------------+------+-----+---------+----------------+木铎校园 BBS 社区!`ax/z-V~H&X'HR
16 rows in set (0.00 sec)木铎校园 BBS 社区%k&z:s H#WFp
木铎校园 BBS 社区 ~:l9\6[f#m"R9D)V
上面的是freebsd上mysql4.0+的表结构，将表文件直接copy到linux下，启用mysql5.0+,表结构如下面的表。。。
nAt#F0? b tX4w0
!T Mr(r G;U:o0木铎校园 BBS 社区 b5P7| Yszh
相关阅读:
- InnoDB Performance Optimization [zz] (平凡的香草, 2007-6-28)
- top-secret tuned mysql configurations for rails :: evan weaver (平凡的香草, 2007-7-16)
- Linux Standard Base Specification 2.1 (平凡的香草, 2007-7-20)
- ReiserFS (平凡的香草, 2007-7-25)
- How to backup and import a MySQL InnoDB database (平凡的香草, 2007-7-26)
- Qt参考文档 (行云流水, 2007-8-09)
- 基于Qt/Embedded和Qtopia的GUI设计（转） (行云流水, 2007-8-13)
- QtEmbedded/Qtopia FAQ (行云流水, 2007-8-13)
- qipnx的专栏 (行云流水, 2007-8-16)
- mysql 4.0.x 升级到 mysql 5.0.x 总结 zz (平凡的香草, 2007-8-31)
联系电话：13810154053