There are (more than) two ways to go about this. 

1) use phpmyadmin to change coalation per table (tedious)
2) mysqldump, global search/replace the result, (first make another, verified backup!) and then drop the database create the database and load from modified backup.

Which to do?

Oh, that's the question. and neither are *fast*... one requires a lot of hunt, click click click change, and the other is ... well, as long as you have *all* the tables, probably a bit faster, though it does mean that you'll be doing a search/replace through a potentially fairly large text file (NotePad++ or vim would be recommended).

or https://www.google.com/search?q=mass+change+collation+mysql



On Wed, Oct 16, 2013 at 5:40 PM, Lambrecht, Charles (Charles) <cgl@utk.edu> wrote:

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.

 


---------------------------------------------------------------------
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