Metatroph export apo mysql 4.1 se 4.02 Diorthonontas provlima me ta ellhnika!
Xreiastike na kano alagh sto mhxanima pou filoksenh to linuxer xrisimopiontas export (mysqldump) apo thn mysql 4.1.
Ta provlimata eitan pola.
Prota apo ola h ekdosh ths mysql pou eixa diaueshmh eitan h 4.02.
To export eixe ginei me UTF8 kai eixan mpei entoles pou h palioterh ayth ekdosh den katalavenei.
Opote:
Prota metetrepsa to character set
Sto my.cnf prepei na exei setaristh prota to default-character-set = greek
nai einai iso-8859-1 kai oxi iso-8859-7!!!!
.#iconv -cs -f UTF-8 -t ISO-8859-1 linuxer.sql > iso.linuxer.sql Tora diorthono ths parametrous pou den katalavenei h palioterh ekdosh
.#cat iso.linuxer.sql |sed ‘s/ENGINE=MyISAM DEFAULT CHARSET=latin1/TYPE=MyISAM/’>fix.sql
.#cat fix.sql |sed ‘s/CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP/0000 /’>fix1.sql
kai telos fortono to sql arxeio sthn vash
.#mysql -uroot -p linuxer <fix1.sql
Ayto htan to linuxer einai pali ston aera 😉