The appliance is likely to be at a 3.3.x version. You will need to upgrade 3.0-3.1.latest to 3.2.latest to 3.3.applianceversion Read and follow UPGRADING or UPGRADING.MD for each version. There are generally three database steps: an update to SQL, an update script and a post ups to SQL. (written from memory. Docs trump what I say here) MySQLdump will be ASCII for backup. On Jun 6, 2014 6:53 PM, "Mikola Rose" wrote:

I have install the appliance distro and ran into some problems restoring the “live” database. It appears that the “live” database is in SQL_ASCII encoding and the appliance distro is encoded to UTF8. And ideas on how I can convert the live database. Then upgrade it to the appliance version level?

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Mikola Rose *Sent:* Friday, June 06, 2014 11:15 AM *To:* 'otrs@otrs.org' *Subject:* [otrs] Converting to appliance distro

Hi there List members,

Quick question I hope. I currently have an installation of OTRS 3.03 running on OSX leopard that we have been using for years. Are there any special consideration and methods to consider if I would like to migrate to the OTRS appliance installation. Would there be any suggestions on how I can upgrade and import the currently in place database to the appliance deployment?

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

The "link" was an artifact of email clients attempting to hyperlink automatically. The file itself exists in the root of each version as appropriate for the version downloaded. On Mon, Jun 9, 2014 at 1:01 PM, Mikola Rose wrote:

Hi Gerald,

The upgrading link you provided is broken

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Gerald Young *Sent:* Saturday, June 07, 2014 6:07 AM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Converting to appliance distro

The appliance is likely to be at a 3.3.x version. You will need to upgrade 3.0-3.1.latest to 3.2.latest to 3.3.applianceversion

Read and follow UPGRADING or UPGRADING.MD for each version. There are generally three database steps: an update to SQL, an update script and a post ups to SQL. (written from memory. Docs trump what I say here)

MySQLdump will be ASCII for backup.

On Jun 6, 2014 6:53 PM, "Mikola Rose" wrote:

I have install the appliance distro and ran into some problems restoring the “live” database. It appears that the “live” database is in SQL_ASCII encoding and the appliance distro is encoded to UTF8. And ideas on how I can convert the live database. Then upgrade it to the appliance version level?

*From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Mikola Rose *Sent:* Friday, June 06, 2014 11:15 AM *To:* 'otrs@otrs.org' *Subject:* [otrs] Converting to appliance distro

Hi there List members,

Quick question I hope. I currently have an installation of OTRS 3.03 running on OSX leopard that we have been using for years. Are there any special consideration and methods to consider if I would like to migrate to the OTRS appliance installation. Would there be any suggestions on how I can upgrade and import the currently in place database to the appliance deployment?

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NM scp… From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Mikola Rose Sent: Tuesday, June 10, 2014 2:07 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Converting to appliance distro Any idea on how I can get smb or something up so I can transfer this backup to the appliance? From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Mikola Rose Sent: Monday, June 09, 2014 10:02 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Converting to appliance distro Hi Gerald, The upgrading link you provided is broken From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Saturday, June 07, 2014 6:07 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Converting to appliance distro The appliance is likely to be at a 3.3.x version. You will need to upgrade 3.0-3.1.latest to 3.2.latest to 3.3.applianceversion Read and follow UPGRADING or UPGRADING.MDhttp://UPGRADING.MD for each version. There are generally three database steps: an update to SQL, an update script and a post ups to SQL. (written from memory. Docs trump what I say here) MySQLdump will be ASCII for backup. On Jun 6, 2014 6:53 PM, "Mikola Rose" mailto:mrose@power-soft.com> wrote: I have install the appliance distro and ran into some problems restoring the “live” database. It appears that the “live” database is in SQL_ASCII encoding and the appliance distro is encoded to UTF8. And ideas on how I can convert the live database. Then upgrade it to the appliance version level? From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org] On Behalf Of Mikola Rose Sent: Friday, June 06, 2014 11:15 AM To: 'otrs@otrs.orgmailto:otrs@otrs.org' Subject: [otrs] Converting to appliance distro Hi there List members, Quick question I hope. I currently have an installation of OTRS 3.03 running on OSX leopard that we have been using for years. Are there any special consideration and methods to consider if I would like to migrate to the OTRS appliance installation. Would there be any suggestions on how I can upgrade and import the currently in place database to the appliance deployment? --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs