Project

General

Profile

1
#!/bin/bash -e
2
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/import.run
3
.rel ../../../lib/runscripts/subdir.run
4
.rel ../../../lib/sh/resume_import.sh
5

    
6
if self_not_included; then
7

    
8
## to reload GBIF MySQL:
9
# $ database=GBIF_new path/to/this/file load_data
10
# rename GBIF->GBIF_old, GBIF_new->GBIF on vegbiendev using the steps at
11
#     wiki.vegpath.org/MySQL_queries#Rename-database
12
# drop GBIF_old in phpMyAdmin (vegbiendev.nceas.ucsb.edu/phpmyadmin)
13

    
14
dumpfile_stem=GBIFPortalDB-2013-02-20
15
dumpfile_stem_path="$top_dir/$dumpfile_stem"
16

    
17
load_data() # usage: [database=GBIF_new] load_data
18
{
19
	echo_func
20
	
21
	use_local_remote
22
	database= mysql_root <<EOF
23
CREATE DATABASE IF NOT EXISTS $database DEFAULT CHARACTER SET utf8/*utf8_general_ci*/;
24
GRANT  ALL PRIVILEGES              ON $database.* TO   '$local_user'@'%' WITH GRANT OPTION;
25
REVOKE UPDATE, DELETE, ALTER, DROP ON $database.* FROM '$local_user'@'%';
26
EOF
27
	
28
	sql_preamble <"$top_dir"/../_src/"$dumpfile_stem".dump >"$dumpfile_stem_path".schema.0.preamble.sql
29
	cat "$dumpfile_stem_path".schema*.sql|mysql_root
30
	time cat "$dumpfile_stem_path".data*.sql|mysql_rm_privileged_statements\
31
|log_queries= mysql_local
32
}
33

    
34
import()
35
{
36
	echo_func
37
	top_make
38
}
39

    
40
fi
(13-13/13)