How to drop and recreate CEL table

FreePBX
1

My CEL table is damaged and unrepairable. How to drop it and recreate it?

2

From the machine with the database:

mysqldump -u root --add-drop-table --no-data asteriskcdrdb cel | mysql -u root asteriskcdrdb

That should copy the structure and support structures in the table without the data.

3

After dropping the cel table, you can recreate by installing the cel module again:

fwconsole ma install cel
4

mysqldump: Got error: 1049: “Unknown database ‘–’” when selecting the database

5

Errant space - edited - try it with the fixed syntax.