Migration - mysql

miss_kitab

ok me again..byk lak soklan miss lately nie..

ok like this, skrang miss akan wat migration from btrieve DB to MySQL.
so miss akan extract data frm btrieve db to .csv files (x byk data pon dalam 3000 jek)
than miss akan import data dalam .csv files masuk mysql guna mysql front..tp ada problem masa import..kuar
error kat mysql front..error dia camni "1148: the used command is not allowed with this mysql version"

huhuhu miss pakai mysql front version 2.5..b4 this pernah wat ok jek..sbb version ni mmg prob or kena crk version yg lg previous2 or ada cara or tools lain yg lag bagus..ada cadangan?

TQ

miss_kitab

huhuh sendiri tanya sendiri jawab..miss dah dpt another alternatif, guna heidiSQL..tp ada problem pulak nak import csv file msk table..

my csv file camni:-
fields : dun,kod_dun,daerah,kod_daerah
data : Air Putih,32,Kemaman,40

tp bila import dalam table all the data masuk dlm satu field..sepatutnya data tu masuk ikut field data..huhuh camner ek...

pls help!!!

[ Last edited by  miss_kitab at 23-1-2007 04:41 PM ]

Sarah_Radzi

check separator utk csv file camtu ...
ganti, kpd ; for example ...


biasanya .. kalau utk migrate data small to medium .. dan bermasalah sangat nak export (2 try tak berjaya tanpa sebab yg dipahami) i prefer buat program je (odbc ataupun php, tapi php lembab lah pulak) ...

query1 = "select * from table";
olddb->execute(query1)
for each row identified by currentrow
    query2 = construct_insert_query_from_values_in_current_row(currentrow)
   newdb->execute(query2)
end
// kalau ada index
query3 = "create index on newdb.table";
newdb->execute(query3);
if db.transactional and noerror then newdb->commit();

the end

Sarah_Radzi

lupa nak mention .. kalau table tu ada index .. walaupun primary index .. jgn activate dulu dlm table baru sbb akan menslowkan operasi import tadi ..

miss_kitab

thanks sarah..

tp now i dah jumpa cara paling mudah..in a second jek
juz run this MySQL statement..i run kat mysqlfront

LOAD DATA LOCAL INFILE 'dun.csv'
INTO TABLE table_dun
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(id, dun, kod_dun,parlimen,kod_parlimen);

yuhuu finally got it!!!!

Sarah_Radzi

laa yg selama ni u import camne ? i thought itu yg tak jalan

miss_kitab

hmm b4 this i import guna option import text file kat mysqlfront tu.bukan guna mysql statement..well thanks again..actually ada byk lagi cara leh import...like guna importizer tools n etc..

keychain

example tools yg bagus n senang digunakan for mysql is mysqlyog. tak yah query pon. klik mana yg patut je.

ultra78

dun,kod_dun ? Mcm database SPR aje ni?

miss_kitab

thanks..dah download..duk godek2 nie

miss_kitab

bukan spr laa...tp gov punya cabang ngak ler

keychain

better guna yg enterprise punye tau

another options.. boleh juga try mysql administrator ;)