主題: 請問ubuntu怎麼升級mysql

[itw]

請問一下各位前輩

目前我的ubuntu是10.04,Mysql是5.1.41

我想請問怎麼升級?

另外想請問有辦法降成5.0版嗎

如有文章可以推薦我看一下，因為我上google查，好像都不是我要的

謝謝各位

[HaWay]

移除掉, 自己抓 tar.gz 的回來 ./configure, make, mak install 就好了

[Darkhero]

先問一下...
你為什麼要升級或是降級?... 理由是?...

[itw]

移除掉, 自己抓 tar.gz 的回來 ./configure, make, mak install 就好了

是唷，先謝謝你了

除了這個方法之外，沒有其他方法了嗎，謝謝唷

[itw]

先問一下...
你為什麼要升級或是降級?... 理由是?...

Darkhero兄，因為我發現使用vtiger的行事曆功能時，他的sql語法在5.1版和5.0版取出的資料是不一樣的，以下是他的語法，
如果不是因為版本的問題，再麻煩指教一下

代碼: [選擇]

select case when (vtiger_activity.status not like '') then vtiger_activity.status else vtiger_activity.eventstatus end as activitystatus,vtiger_activity.activitytype,vtiger_activity.subject,vtiger_activity.date_start,vtiger_activity.due_date,case when (vtiger_users.user_name not like '') then vtiger_users.user_name else vtiger_groups.groupname end as user_name, vtiger_activity.activityid, vtiger_activity.activitytype as type, vtiger_activity.priority, case when (vtiger_activity.status not like '') then vtiger_activity.status else vtiger_activity.eventstatus end as status, vtiger_crmentity.crmid,vtiger_contactdetails.contactid FROM vtiger_activity LEFT JOIN vtiger_activitycf ON vtiger_activitycf.activityid = vtiger_activity.activityid LEFT JOIN vtiger_cntactivityrel ON vtiger_cntactivityrel.activityid = vtiger_activity.activityid LEFT JOIN vtiger_contactdetails ON vtiger_contactdetails.contactid = vtiger_cntactivityrel.contactid LEFT JOIN vtiger_seactivityrel ON vtiger_seactivityrel.activityid = vtiger_activity.activityid LEFT OUTER JOIN vtiger_activity_reminder ON vtiger_activity_reminder.activity_id = vtiger_activity.activityid LEFT JOIN vtiger_crmentity ON vtiger_crmentity.crmid = vtiger_activity.activityid LEFT JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid LEFT JOIN vtiger_groups ON vtiger_groups.groupid = vtiger_crmentity.smownerid LEFT OUTER JOIN vtiger_account ON vtiger_account.accountid = vtiger_contactdetails.accountid LEFT OUTER JOIN vtiger_leaddetails ON vtiger_leaddetails.leadid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_account vtiger_account2 ON vtiger_account2.accountid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_potential ON vtiger_potential.potentialid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_salesorder ON vtiger_salesorder.salesorderid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_purchaseorder ON vtiger_purchaseorder.purchaseorderid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_quotes ON vtiger_quotes.quoteid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_invoice ON vtiger_invoice.invoiceid = vtiger_seactivityrel.crmid LEFT OUTER JOIN vtiger_campaign ON vtiger_campaign.campaignid = vtiger_seactivityrel.crmid WHERE vtiger_crmentity.deleted = 0 AND activitytype != 'Emails' LIMIT 0, 20


[Yamaka]

請問一下各位前輩

目前我的ubuntu是10.04,Mysql是5.1.41

我想請問怎麼升級?

另外想請問有辦法降成5.0版嗎

如有文章可以推薦我看一下，因為我上google查，好像都不是我要的

這篇參考看看, 我沒試過, 所以也不知道是否可行 

http://serverfault.com/questions/147883/how-can-i-install-mysql-5-0-on-ubuntu-10-04