FileSender supports several different database back-ends, by virtue of PHP's PDO.

Currently there are 3 back-ends that are known to work: Postgres, MySQL, and SQLite.

Assumptions:

• 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, but cut at the pipes for readability:

pg_dump -U username -h hostname -a --inserts --disable-dollar-quoting --quote-all-identifiers filesender |
sed -r 's/^INSERT\ INTO\ \"(files|logs)\"/INSERT INTO `\1`/g' |
grep --color=never "^INSERT INTO" |
mysql -u username -p filesender