Easiest solution is to run a backup then run an alter database and then an alter on each table changing the character set. The table changes may be done easily with a script. LQ Marshall ----- Original Message ----- From: "Lambrecht, Charles (Charles)" To: "User questions and discussions about OTRS." Sent: 10/16/2013 18:05 Subject: Re: [otrs] OTRS 2.4.7 - Best practice to convert table charset collation before upgrades? Ok, that is helpful. I see I can convert the charset and collation on the database and tables. Do I have to do anything to the data? Part time DB Admin, Charles -------------------------------------------------------------- Charles Lambrecht Computer Operations Manager University of Tennessee College of Veterinary Medicine Email: cgl@utk.edumailto:cgl@utk.edu -------------------------------------------------------------- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Wednesday, October 16, 2013 5:51 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] OTRS 2.4.7 - Best practice to convert table charset collation before upgrades? 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) mailto: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.edumailto:cgl@utk.edu -------------------------------------------------------------- From: otrs-bounces@otrs.orgmailto:otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.orgmailto: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.plhttp://restore.pl. doesn't restore all data From: otrs-bounces@otrs.orgmailto: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.plhttp://restore.pl. doesn't restore all data Yes, that was an excellent suggestion. My 1.5 GB file only has 4 tables... :( 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 --------------------------------------------------------------------- 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