-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
River Tarnell:
I was looking at your encoding problem earlier; the most likely possibility seemed to be that after the MySQL 5.5 upgrade, the default client character set changed to UTF-8, which broke some tools. I've changed that back to latin1 to restore the old behaviour, but it didn't fix your problem.
It looks like the problem is that you override --defaults-file in ~lvova/public_html/cgi-bin/ts. This prevents the client from reading /etc/my.cnf, so you don't get the correct default character set.
If you do this instead:
HOME=$(getent passwd $(id -u)|cut -f6 -d:) export HOME
... then you don't need to use --defaults-file and your script will probably work correct.
(Example: http://toolserver.org/~river/sql.cgi.)
- river.