. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/subdir.run

. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/sh/resume_import.sh

dumpfile_stem=GBIFPortalDB-2013-02-20

dumpfile_stem_path="$top_dir/$dumpfile_stem"

load_data() # usage: [database=GBIF_new] load_data

{

	echo_func

	use_local_remote

	database= mysql_root <<EOF

CREATE DATABASE IF NOT EXISTS $database DEFAULT CHARACTER SET utf8/*utf8_general_ci*/;

GRANT  ALL PRIVILEGES              ON $database.* TO   '$local_user'@'%' WITH GRANT OPTION;

REVOKE UPDATE, DELETE, ALTER, DROP ON $database.* FROM '$local_user'@'%';

EOF

	sql_preamble <"$top_dir"/../_src/"$dumpfile_stem".dump >"$dumpfile_stem_path".schema.0.preamble.sql

	cat "$dumpfile_stem_path".schema*.sql|mysql_root

	time cat "$dumpfile_stem_path".data*.sql|mysql_rm_privileged_statements\

|log_queries= mysql_local

}