Mysql ISO kai UTF8

[Alexandros Kosiaris]

Vaggelis Tripolitakis wrote:
> On 6/28/06, Alexandros Kosiaris <alex at noc.ntua.gr> wrote:
>> 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
>>
>>
>>
>> -- 
>> linux-greek-users mailing list -- http://lists.hellug.gr
>>
>>
> 
> alexandre se 8elw se shared hosting periballon me mono option sou
> to phpmyadmin ... ekei na deis dramata...  xwris shell...
> 
o theos na fylaei..... ftou ftou ftou ftou ftou

-- 
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: 5176 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.hellug.gr/pipermail/linux-greek-users/attachments/20060629/13e8d56b/attachment.bin>