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:
scripts/
directory.
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 |
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 |
SQLite to MySQL
sqlite3 filesender.sqlite .dump | sed -r 's/^(INSERT\ INTO\ )"(logs|files)"(\ VALUES)/\1`\2`\3/g' | grep --color=never "^INSERT INTO \`" | mysql -u username -h hostname -p filesender |