sql importazione dati

Alex_70

Utente Attivo
13 Nov 2018
371
14
18
HELL
Salve a tutti, ho scaricato un database sql con i relativi file dal sito inducks (public domain)

questo e' una piccola porzione sql per il database

SQL:
# SQL for re-creating and filling table inducks_storyversion
DROP TABLE IF EXISTS inducks_storyversion_temp;
CREATE TABLE inducks_storyversion_temp (
    storyversioncode varchar(20),
    storycode varchar(19),
    entirepages int(7),
    brokenpagenumerator int(7),
    brokenpagedenominator int(7),
    brokenpageunspecified enum('Y','N'),
    kind varchar(1),
    rowsperpage int(7),
    columnsperpage int(7),
    appisxapp enum('Y','N'),
    what varchar(1),
    appsummary text,
    plotsummary text,
    writsummary text,
    artsummary text,
    inksummary text,
    creatorrefsummary text,
    keywordsummary text,
    estimatedpanels int(7),
    KEY pk0 (storyversioncode),
    KEY fk1 (storycode)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOAD DATA LOCAL INFILE "./isv/inducks_storyversion.isv" INTO TABLE inducks_storyversion_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
ALTER TABLE inducks_storyversion_temp ADD FULLTEXT(appsummary,plotsummary,writsummary,artsummary,inksummary,creatorrefsummary,keywordsummary);

il problema e' che non funziona l'importazione dei file esterni da questo comando

Codice:
LOAD DATA LOCAL INFILE "./isv/inducks_storyversion.isv" INTO TABLE inducks_storyversion_temp FIELDS TERMINATED BY '^' IGNORE 1 LINES;
il file e' questo (ma deve caricarne altri)

inducks_storyversion.isv

con dentro questo (una piccola porzione di codice)

Codice:
storyversioncode^storycode^entirepages^brokenpagenumerator^brokenpagedenominator^brokenpageunspecified^kind^rowsperpage^columnsperpage^appisxapp^what^appsummary^plotsummary^writsummary^artsummary^inksummary^creatorrefsummary^keywordsummary^estimatedpanels^
I DMR   3-1^I DMR   3-1^1^0^1^N^n^4^2^Y^s^,GO,^,TFa,^,TFa,^,SZi,^,SZi,^^^8^
I DMR   3-2^I DMR   3-2^1^0^1^N^n^4^2^Y^s^,GO,^,TFa,^,TFa,^,SZi,^,SZi,^^^8^
I DMR  33-1^I DMR  33-1^1^0^1^N^n^4^2^Y^s^,Battista,US,^,BEn,^,BEn,^,LLe,^,LLe,^^^8^
I DMR  33-2^I DMR  33-2^1^0^1^N^n^4^2^Y^s^,Battista,US,^,BEn,^,BEn,^,LLe,^,LLe,^^^8^
I DMR  33-3^I DMR  33-3^1^0^1^N^n^4^2^Y^s^,US,^,BEn,^,BEn,^,LLe,^,LLe,^^^8^
I DMR  33-4^I DMR  33-4^1^0^1^N^n^4^2^Y^s^,DD,HDL,US,^,BEn,^,BEn,^,LLe,^,LLe,^^^8^
I DMR  33-5^I DMR  33-5^1^0^1^N^n^4^2^Y^s^,Battista,US,^,BEn,^,BEn,^,LLe,^,LLe,^^^8^
qualcuno ha la soluzione?