jack60705 2006-4-27 06:24 AM
【求助】請問如何從4.0 => 5.0 ?
【求助】請問如何從4.0 => 5.0 ?
因為之前使用5.0來架設Discuz~ SQL匯出都是亂碼~
朋友說那是5.0的問題~
所以最後我採用4.0架設~就沒此問題...
但是當初降為4.0 真的感覺不是很好用~
請問如果我現在4.0的SQL 要晉升到 5.0 該如何升級:em36:
有請大大分享:angel:
Linux0911 2006-4-27 12:46 PM
回覆 #1 jack60705 的帖子
很特別, 似乎只提供 4.1 升級 5.0
MySQL Official Manual: 2.10.2. Upgrading from MySQL 4.1 to 5.0
[url]http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html[/url]
5.0 有些東西不再支援 4.0 的東西, 手冊有說明, 可參考 What's New in MySQL 5.0
下面有使用者評論有提到：
[quote][b]Posted by Liam Redmond on February 21 2006 3:42pm[/b] [Delete] [Edit]
When installing the 5.0 build from a 4.0 installation you cannot use "localhost" in your jdbc connection url anymore. beware, you my have to recompile/re-deploy all your java web apps rather than just changing the database server. "localhost" forces the use of unix sockets and you won't be able to connect without changing your jdbc url to contain the local IP address. I found no way of disabling unix sockets or making it so that localhost used tcp/ip.[/quote]
jack60705 2006-4-27 10:22 PM
好可惜喔~~偏偏我是4.0....
感謝提供告知!