Step-by-step: Migrating Messages into vBulletin PM Reader
Overview
This guide walks through moving private messages into the vBulletin PM Reader plugin (assumes vBulletin ⁄5 compatibility). It covers exporting from the source, preparing data, importing into PM Reader, and verification. Adjust file paths, table names, and SQL to your environment.
Requirements
- Full database backups (source and target).
- File-system backup of attachments (if applicable).
- SSH / database access (mysqldump, mysql) or phpMyAdmin.
- PHP CLI access or a custom import script.
- Knowledge of source message schema and vBulletin PM schema.
Step 1 — Backup everything
- Database: Dump both source and target databases:
Code
mysqldump -u root -p source_db > source_db.sql mysqldump -u root -p target_db > targetdb.sql - Files: Copy attachments and any related files.
- Configuration snapshot: Record vBulletin version and PM Reader plugin version.
Step 2 — Export messages from the source
- Export messages to CSV or SQL from source tables (threads, messages, users). Example CSV export (MySQL):
Code
SELECT messageid, senderid, recipientid, title, message, dateline, hasattachments INTO OUTFILE ‘/tmp/messages.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“’ LINES TERMINATED BY ‘ ’ FROM source_messages_table; - Export attachment records and files (store mapping of file names to message IDs).
Leave a Reply