mysql 4.0(freebsd) 升级到5.0+(linux)的出现的问题

上一篇 / 下一篇  2007-09-04 02:49:18 / 个人分类:LAMP

mysql> desc cdb_attachments;
c'HJdX)~7c8v0+-------------+-----------------------+------+-----+---------+----------------+
&X'{9j)U[0| Field       | Type                  | Null | Key | Default | Extra          |
s,Yi BJuy%[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^-ed4xw2L0| 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+WC'x
| description | char(50)              | NO   |     | NULL    |                |
F.W d Xf#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 aCXdL!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       |                |
E7PgAHk!q0+-------------+-----------------------+------+-----+---------+----------------+
\;o)fWKsA j016 rows in set (0.01 sec)木铎校园 BBS 社区v/U E4T"?Ag$p

/~Y)hs f7d5SUp:p(D0
o XD%z*G+\rtE0mysql> 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       |                |
dA(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       |                |
6IgO;[ u#b&n \,B-m,eF0| uid         | mediumint(8) unsigned |      | MUL | 0       |                |
:t;J]7](W6Z N0| thumb       | tinyint(1) unsigned   |      |     | 0       |                |
skq6Gcl%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:sH#WFp
木铎校园 BBS 社区~:l9\6[f#m"R9D)V
上面的是freebsd上mysql4.0+的表结构,将表文件直接copy到linux下,启用mysql5.0+,表结构如下面的表。。。
nAt#F0?b tX4w0
!T Mr(rG;U:o0木铎校园 BBS 社区 b5P7| Yszh

TAG: linux mysql freebsd

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

关于作者