View on GitHub

LOAD_PATSTAT

PATSTAT DB Loading in Mysql

Download this project as a .zip file Download this project as a tar.gz file

Import script for PATSTAT

Prerequisites

All PATSTAT txt files should be decompressed in a load path as configured in setup.sh

Use

Go in bin and:

    export APPL=patstat
    export REL=04
    export YEAR=2012
    export MYSQL=mysql
    export MYSQLADM=mysqladmin
    export MYSQLDUMP=mysqldump
    export MYISAMCHK=myisamchk
    export MYISAMPACK=myisampack
    export USER=root
    export PASS=root
    export SOCKET=/opt/local/var/run/mysql5/mysqld.sock
    export LOADPATH=/Users/Shared/PATSTAT-DVD
    export ZIPARCHIVE=/Users/Shared/PATSTAT-DVD
    export RELEASE=Patstat_${YEAR}_${REL}
    export MYSQLVARPATH=/var/mysql
    export DUMPFILE=$HOME/dumps/${RELEASE}.sql

    cd bin
    ./go

    loading_log_20120511_0951.txt
    loading_err_20120511_0951.txt

    backup_db.sh

    cd ../make_italian_db
    mysql -uroot -p

and in the mysql console:

    mysql> source select_italian_applicants.sql