527475 - [AMO] Give webdev CLI access to preview.amo's database

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Wil Clouser [:clouserw]]

I'm attempting to run the following command on phpmyadmin:

UPDATE addons
SET locale_disambiguation = CONVERT(CONVERT(CONVERT(locale_disambiguation USING latin1) using binary) using utf8)
WHERE LENGTH(locale_disambiguation) > CHAR_LENGTH(locale_disambiguation);

It appears to run but doesn't do the same thing as it does on my dev box on khan.  Perhaps it's connecting with a different charset or something.  Additionally, this query:

SELECT * FROM addons where id=4964;

gives me junk in the locale_disambiguation field.  Fixing phpmyadmin would be great if it's quick, but we should have command line access as well.

Comment 1

[Wil Clouser [:clouserw]]

ETA?

Comment 2

[chizu]

You can connect to addons_reskin on tm-stage01-master01 from khan now. I've emailed the details to you.

Comment 3

[Wil Clouser [:clouserw]]

works great, thanks