#!/bin/sh

set -o errexit

alias sed="sed -`case "$(uname)" in Darwin) echo E;; *) echo r;; esac`"

set -x

exec sed -n '/^-- Table structure for table `.*`$/'\

',/^\/\*!40101 SET character_set_client = @saved_cs_client \*\/;$/{p}'

#!/bin/bash

set -o errexit

cd "$(dirname "$0")"

make

include ../../../lib/common.Makefile

types := schema data

all: $(types:%=GBIFPortalDB-2013-02-20.%.sql) ;

%.schema.sql: ../_src/%.dump

	./MySQL_schema <$< >$@

%.data.sql: ../_src/%.dump

	./MySQL_data data_provider data_provider_agent data_resource \

data_resource_agent raw_occurrence_record <$< >$@

#!/bin/bash

set -o errexit

alias sed="sed -`case "$(uname)" in Darwin) echo E;; *) echo r;; esac`"

test "$#" -ge 1 || set -- '.*' # include all tables

opts=()

for table in "$@"; do

	opts=("${opts[@]}" -e '/^-- Dumping data for table `'"$table"'`$/'\

',/^UNLOCK TABLES;$/{p}')

done

set -x

exec sed -n "${opts[@]}"

#!/bin/sh

set -o errexit

cd "$(dirname "$0")"

./_MySQL/import