How to migrate calls log from old FreePBX to new

General Help
1

Hi,

Been running FreePBX 2.11 / Asterisk 11.5 for quite a few years.

I now built a new RasPBX (FreePBX 15).

How can I migrate the calls log from my old PBX to the new?

Thanks!

2

Do you mean CDRs? Use the backup and restore module.

3

That’s quite an old version of FreePBX. I am not actually sure if there is a direct restore path to FreePBX 15 from that. This might not be an option for you.

4

Idk if the rest of the backup would work, but if it’s a backup that only contains CDRs the legacy CDR restore option in v15 should handle it.

5

I guess the only way to find out is to try.

6

If

mysql asteriskcdrbd -e 'describe cdr;describe cel'

on both the old and the new installations are the same , then on the old machine

mysqldump -t --compact asteriskcdrdb > asteriskcdrdb.sql
cat asteriskcdrdb.sql | ssh new.machine mysql asteriskcdrdb

should work

7

Yeah it’s just that the new CDR table has additional columns that would have to be added and some columns removed as well. That’s what the legacy cdr restore does

8

Thank you @adell4444 !
the Legacy CDR Restore worked!

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.