Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The target database has the right schema, tables, etc, and is empty. See the create scripts in the scripts/ directory.
  • Both the source and destination database are called filesender

Postgres to MySQL

Basically a shell script one liner: 

Code Block
themeMidnight
languagebash
pg_dump -U username -h hostname -a --inserts filesender |
sed -r 's/^(INSERT\ INTO\ )(files|logs)(\ VALUES\ )/\1`\2`\3/g' |
grep --color=never "^INSERT INTO" |
mysql -u username -h hostname -p filesender

  

Postgres to SQLite

Code Block
themeMidnight
languagebash
pg_dump -U username -h hostname -a --inserts filesender |
sed -r 's/^(INSERT\ INTO\ )(files|logs)(\ VALUES\ )/\1`\2`\3/g' |
grep --color=never "^INSERT INTO" |
sqlite3 filesender.sqlite