Конвертация баз данных

Для каждой таблицы - экспортировать в CSV, по-умолчанию, результаты будут лежать тут: C:\ProgramData\MySQL\MySQL Server 5.6\data\

SELECT 'PERSONID','FNAME','NAME','LNAME','BIRTHDATE','BIRTHPLACE','NATION','AWORK','LIVEPLACE','ARESTDATE','SUDORGAN','SUDDATE','STAT','PRIGOVOR','RASSTREL','MORTDATE','REABDATE', 'BOOK','AGE','GENDER'
UNION ALL
SELECT * FROM `#mysql50#memo-persons`.`persons`
INTO OUTFILE 'C:/temp/memorial/export/persons.csv'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n';

SELECT 'AGEID','AGE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`ages`
INTO OUTFILE 'C:/temp/memorial/export/ages.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'ARESTORGANID','ARESTORGAN'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`arestorg`
INTO OUTFILE 'C:/temp/memorial/export/arestorg.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'ARESTTYPEID','ARESTTYPE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`aresttyp`
INTO OUTFILE 'C:/temp/memorial/export/aresttyp.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'BIRTHYEARID','BIRTHYEAR'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`birthye`
INTO OUTFILE 'C:/temp/memorial/export/birthyear.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'BOOKID','BOOK','BOOKSOURCE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`books`
INTO OUTFILE 'C:/temp/memorial/export/books.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'DELOID','DELO'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`delos`
INTO OUTFILE 'C:/temp/memorial/export/delos.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'EDUCATIONID','EDUCATION'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`educat`
INTO OUTFILE 'C:/temp/memorial/export/educat.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'FAMSID','FAMS'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`fams`
INTO OUTFILE 'C:/temp/memorial/export/fams.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'FNAMEID','FNAME'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`fnames`
INTO OUTFILE 'C:/temp/memorial/export/fnames.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'GEOPLACEID','GEOPLACE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`geoplace`
INTO OUTFILE 'C:/temp/memorial/export/geoplace.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','ARESTPRGAN'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkarestorg`
INTO OUTFILE 'C:/temp/memorial/export/linkarestorg.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','ARESTTYPE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkaresttyp`
INTO OUTFILE 'C:/temp/memorial/export/linkaresttyp.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','BIRTHYEAR'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkbirthye`
INTO OUTFILE 'C:/temp/memorial/export/linkbirthye.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','DELO'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkdelo`
INTO OUTFILE 'C:/temp/memorial/export/linkdelo.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','EDUCATION'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkeducat`
INTO OUTFILE 'C:/temp/memorial/export/linkeducat.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','FAMS'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkfams`
INTO OUTFILE 'C:/temp/memorial/export/linkfams.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','MORTPLACE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkmortplace`
INTO OUTFILE 'C:/temp/memorial/export/linkmortplace.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','PARTY'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkparty`
INTO OUTFILE 'C:/temp/memorial/export/linkparty.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','PODDAN'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkpoddan`
INTO OUTFILE 'C:/temp/memorial/export/linkpoddan.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','REABORGAN'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkreaborg`
INTO OUTFILE 'C:/temp/memorial/export/linkreaborg.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','REABREASON'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkreabreas`
INTO OUTFILE 'C:/temp/memorial/export/linkreabreas.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','REPRNEXT'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkreprnext`
INTO OUTFILE 'C:/temp/memorial/export/linkreprnext.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','REPRPREV'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkreprprev`
INTO OUTFILE 'C:/temp/memorial/export/linkreprprev.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PERSONIDL','VARNAME'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`linkvarfio`
INTO OUTFILE 'C:/temp/memorial/export/linkvarfio.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'LNAMEID','LNAME'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`lnames`
INTO OUTFILE 'C:/temp/memorial/export/lnames.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'MORTPLACEID','MORTPLACE'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`mortplac`
INTO OUTFILE 'C:/temp/memorial/export/mortplac.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'NAMEID','NAME'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`names`
INTO OUTFILE 'C:/temp/memorial/export/names.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'NATIONID','NATION'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`nations`
INTO OUTFILE 'C:/temp/memorial/export/nations.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PARTYID','PARTY'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`parties`
INTO OUTFILE 'C:/temp/memorial/export/parties.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PODDANID','PODDAN'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`poddan`
INTO OUTFILE 'C:/temp/memorial/export/poddan.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'PRIGOVORID','PRIGOVOR'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`prigovor`
INTO OUTFILE 'C:/temp/memorial/export/prigovor.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'REABORGID','REABORG'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`reaborg`
INTO OUTFILE 'C:/temp/memorial/export/reaborg.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'REABRESONID','REABREASON'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`reabreas`
INTO OUTFILE 'C:/temp/memorial/export/reabreas.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'REPRNEXTID','REPRNEXT'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`reprnext`
INTO OUTFILE 'C:/temp/memorial/export/reprnext.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'REPRPREVID','REPRPREV'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`reprprev`
INTO OUTFILE 'C:/temp/memorial/export/reprprev.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'STATID','STAT'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`stat`
INTO OUTFILE 'C:/temp/memorial/export/stat.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'SUDORGID','SUDORG'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`sudorg`
INTO OUTFILE 'C:/temp/memorial/export/sudorg.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'VARNAMEID','VARNAME','VARIFNAME','VARINAME','VARILNAME','VARIALL'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`varnames`
INTO OUTFILE 'C:/temp/memorial/export/varnames.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';

SELECT 'AWORKID','AWORK'
UNION ALL
SELECT *
FROM `#mysql50#memo-books`.`works`
INTO OUTFILE 'C:/temp/memorial/export/works.csv' 
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n';