root/bin/my2pg_export @ 8051
| 1 |
#!/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 |
--set-charset --lock-tables=false --quick --password\ |
| 8 |
${schema:+ --no-data}${data:+ --no-create-info} "$@" |