Hello,
As I wade through having moved OTRS to a new server, I’ve run the Support Assessment on my OTRS 2.4.7 system.
I get the error:
|
Check if the client uses utf8 for the connection. |
Your client connection is utf8. |
OK |
|
Check if the database uses utf8 as charset. |
Your database character setting is utf8. |
OK |
|
Check database utf8 support. |
Your database version supports utf8. |
OK |
|
Check the utf8 table charset collation. |
Your charset collation is set to Invalid charset collation for: article[latin1_swedish_ci], article_attachment[latin1_swedish_ci], article_flag[latin1_swedish_ci], article_plain[latin1_swedish_ci],
article_search[latin1_swedish_ci], article_sender and on for every table. |
What is the best practice to convert the table charset collation and the data before moving forward with upgrades?
Regards,
Charles
-----------------------------------
Charles Lambrecht
Computer Operations Manager
University of Tennessee
College of Veterinary Medicine
Email:
cgl@utk.edu
--------------------------------------------------------------
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]
On Behalf Of LQ Marshall
Sent: Wednesday, October 16, 2013 9:50 AM
To: 'User questions and discussions about OTRS.'
Subject: Re: [otrs] restore.pl. doesn't restore all data
From:
otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]
On Behalf Of Lambrecht, Charles (Charles)
Sent: Wednesday, October 16, 2013 8:18 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] restore.pl. doesn't restore all data
Yes, that was an excellent suggestion. My 1.5 GB file only has 4 tables…
L
Well, it’s off to see how to restore via the physical files (luckily, I have them!)
An unverified back-up process is a potential heart ache. I run through all of my back-ups at least once a year to assure they function as expected.