Revision 7692
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/BRIT/_MySQL/MySQL.data.sql.make | ||
---|---|---|
1 | 1 |
#!/bin/sh |
2 |
env server=localhost data=1 my2pg_export --user=bien BRIT specimen_flat |
|
2 |
env server=vegbiendev data=1 my2pg_export --user=bien BRIT specimen_flat |
inputs/BRIT/_MySQL/MySQL.schema.sql.make | ||
---|---|---|
1 | 1 |
#!/bin/sh |
2 |
env server=localhost schema=1 my2pg_export --user=bien BRIT specimen_flat |
|
2 |
env server=vegbiendev schema=1 my2pg_export --user=bien BRIT specimen_flat |
README.TXT | ||
---|---|---|
155 | 155 |
mkdir inputs/<datasrc>/_MySQL/ |
156 | 156 |
cp -p lib/MySQL.{data,schema}.sql.make inputs/<datasrc>/_MySQL/ |
157 | 157 |
Edit _MySQL/*.make for the DB connection |
158 |
For a .sql export, use server=localhost and --user=bien
|
|
158 |
For a .sql export, use server=vegbiendev and --user=bien
|
|
159 | 159 |
Skip the Add input data for each table section |
160 | 160 |
For MS Access databases: |
161 | 161 |
Place the .mdb or .accdb file in _src/ |
Also available in: Unified diff
README.TXT: Datasource setup: MySQL inputs: Editing _MySQL/*.make: Set $server to vegbiendev instead so the export command will work from any machine (though it will be faster from vegbiendev itself)