bugzilla update

Nick Schermer nickschermer at gmail.com
Tue Aug 15 21:47:07 CEST 2006


Maybe some like this works:

mysqldump -u=x -p=x --default-character-set=ISO-8859-1
--skip-set-charset bugs > dump.sql
mysql -u=x -p=x --execute="DROP DATABASE bugs; CREATE DATABASE bugs
CHARACTER SET utf8 COLLATE utf8_general_ci;"
mysql -u=x -p=x --default-character-set=utf8 bugs < dump.sql

Maybe:
ALTER TABLE attach_data CONVERT TO CHARACTER SET utf8;
ALTER TABLE attachments CONVERT TO CHARACTER SET utf8;
ALTER TABLE bug_group_map CONVERT TO CHARACTER SET utf8;
[...]
Also works, duno, just an idea. I've tried the ALTER TABLE [..] on my
local bugzilla and it seems nothing is broken afterwards, so you can
try this Brain. (attached file with all the tables).

Nick
-------------- next part --------------
A non-text attachment was scrubbed...
Name: alterall
Type: application/octet-stream
Size: 2778 bytes
Desc: not available
URL: <http://mail.xfce.org/pipermail/xfce4-dev/attachments/20060815/a89c1049/attachment.obj>


More information about the Xfce4-dev mailing list