root/bin/my2pg_export @ 8051
1 | 6011 | aaronmk | #!/bin/sh
|
---|---|---|---|
2 | # Exports a MySQL DB in a format that can be used with my2pg
|
||
3 | # Usage: env [server=...] [schema=1] [data=1] self db [table...]
|
||
4 | |||
5 | set -x |
||
6 | ${server:+ssh "$server" }mysqldump --compatible=postgresql --add-locks=false \ |
||
7 | 7531 | aaronmk | --set-charset --lock-tables=false --quick --password\ |
8 | 6011 | aaronmk | ${schema:+ --no-data}${data:+ --no-create-info} "$@" |