https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8132
Bug ID: 8132
Summary: Database Migration: PostgreSQL to MariaDB
Product: Spamassassin
Version: 4.0.0
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: spamassassin
Assignee: dev@spamassassin.apache.org
Reporter: spamassas...@aschoettler.com
Target Milestone: Undefined
It is currently not possible to perform a database migration
from PostgreSQL to MariaDB.
Option A:
- sa-learn --backup > backup.db
- change local.cf to use MariaDB
- sa-learn --restore backup.db
The import takes ages but is incomplete.
Option B:
- pg_dump --inserts spamassassin > dump_postgres.sql
- cat dump_postgres.sql | grep "INSERT INTO" > dump_mysql.sql
- sed -i 's/INSERT INTO public./INSERT INTO /' dump_mysql.sql
- mysql -D spamassassin -u spamassassin -p < dump_mysql.sql
ERROR 1406 (22001) at line 7106628: Data too long for column 'token' at row 1.
Is there a solution for this?
--
You are receiving this mail because:
You are the assignee for the bug.
