Revision 9851
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/GBIF/_MySQL/MySQL_schema | ||
|---|---|---|
| 5 | 5 |
|
| 6 | 6 |
set -x |
| 7 | 7 |
exec sed -n '/^-- Table structure for table `.*`$/'\ |
| 8 |
',/^\/\*!40101 SET character_set_client = @saved_cs_client \*\/;$/{p}'
|
|
| 8 |
',/^\/\*!40101 SET character_set_client = @saved_cs_client \*\/;$/{
|
|
| 9 |
p |
|
| 10 |
}' |
|
| inputs/GBIF/_MySQL/MySQL_data | ||
|---|---|---|
| 8 | 8 |
opts=() |
| 9 | 9 |
for table in "$@"; do |
| 10 | 10 |
opts=("${opts[@]}" -e '/^-- Dumping data for table `'"$table"'`$/'\
|
| 11 |
',/^UNLOCK TABLES;$/{p}')
|
|
| 11 |
',/^UNLOCK TABLES;$/{
|
|
| 12 |
p |
|
| 13 |
}') |
|
| 12 | 14 |
done |
| 13 | 15 |
|
| 14 | 16 |
set -x |
Also available in: Unified diff
bugfix: inputs/GBIF/_MySQL/MySQL_schema, MySQL_data: sed: put {} commands on their own line to work on Mac