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.

#6

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