Mysql ISO kai UTF8

[Alexandros Kosiaris]

Dimitris Mexis wrote:
> On Wed, 28 Jun 2006 16:32:56 +0300, Spiros Bolis wrote:
> 
>> On Wed, 28 Jun 2006, Dimitris Mexis wrote:
>>
>>> Gnorizi kaneis ena sosto kai sigouro tropo, na metatrepso ola ta
>>> iso8859-7 alpharithmitika, se mia vasi dedomenon, se utf8?
>> dump, iconv kai 3ana restore nomizw pws einai o endedeigmenos tropos
>>
> 
> Ligo pio analitika mipos ginete? Kapoia katefthintiria grammi? Steps?
> 

[backup]

a) me mysqldump ( edo tha ginei axtarmas isos i ypothesi an kai pote den eixa problima

b) stop mysqld, copy /var/db/mysql(i tespa oti exeis), start mysqld (oute auto 
einai aparaithto oti tha pai3ei teleia(alla mexri stigmis den me exei apogoiteusei 
para mono se major allages tis ekdoshs tis bashs

[dump]

mysqldump dummydb > mysql-dump.sql (nai borei na ginei axtarmas, mexri stigmis mou 
exei simbei mono mia fora kai auto giati ton $##%$#$%#%$ i idia h mysql ekdosi
4.1.12 ean thymamai kala)

Edo isos na xreiazetai kana option oste na min ginei kamia bourda sta tables. Px 
ean einai me default character encoding na ginei utf8(thelei ligo psa3imo)

[iconv]

iconv -t UTF-8 -f greek < mysql-dump.sql |  mysql -pdymmy -udummy dummydb

kai o theos na boithisei :-)





-- 
Alexandros Kosiaris     Network Management Center , NTUA
e-mail : alex at noc.ntua.gr
Public Key Fingerprint :
D6B1 0634 BE65 719C 6C95  7492 8201 4B46 C478 F074
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3166 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.hellug.gr/pipermail/linux-greek-users/attachments/20060628/a92dcb18/attachment.bin>