Moving CDR and CEL from FreePBX 16 to 17

[faisalkhan]

I need to migrate CDRs and CEL records from FreePBX 16 to FreePBX 17.
However, my new server already has existing CDRs that I do not want to lose.
Could you please provide me with a proper guide on how to accomplish this?

[faisalkhan]

Hi Team,

I try to import the cdrs from Freepbx 16 to 17 and get this error.

I used this command to export on FreePBX 16:

mysqldump --skip-add-drop-table --no-create-db --no-create-info --complete-insert -u freepbxuser -p asteriskcdrdb cdr > cdr.sql
mysqldump --skip-add-drop-table --no-create-db --no-create-info --complete-insert -u freepbxuser -p asteriskcdrdb cel > cel.sql

root@pbx:/usr/local# mysql -uroot asteriskcdrdb < cdr.sql
ERROR 1136 (21S01) at line 23: Column count doesn't match value count at row 1
root@pbx:/usr/local#

[dicko]

In the mysql shell on both old and new machine, do
``
describe cel;
describe cdr;

You will need to 'ALTER TABLE . . .'  appropriately

[faisalkhan]

Alter table on where ? and are there any complications or impact on the new server database?

[dicko]

Alter the tables so the two databases agree on schema temporarily , lets see your ‘descriptions’ first

[faisalkhan]

New Server(FreePBX 17) column Names:

old PBX (FreePBX 16)

[dicko]

Would you like me to do a line by line coparison for you or do you feel up to the job yourself ?

[faisalkhan]

if you can do I really appreciate it

[dicko]

You add ed the last two user1 and outbound_prefix of what use I don’t know easiest way is to alter the table on NEW by adding those two columns, importimg, then deleting them if you want to .

https://dev.mysql.com/doc/refman/8.4/en/alter-table.html

[faisalkhan]

Thanks @dicko

I have altered the table on new FreePBX 17 and imported successfully.