Mysql ISO kai UTF8

[Vaggelis Tripolitakis]

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...

-- 
Τριπολιτάκης Ευάγγελος

Ηλεκτρονικός Μηχανικός & Μηχανικός Η/Υ,
ΜΔΕ, Υποψήφιος Διδάκτορας Πολυτεχνείου Κρήτης

ΒΙΟ.ΠΑ. Χανίων
Κτίριο 2.01
Τηλέφωνο/Fax : 2821089588
Κινητό: 6944848656
e-mail: vaggelis at nohsys.net
web: http://www.nohsys.net