corrupt asterisk db

[tristan625]

Hi All,
I am new to this asterisk stuff, well basically i have no idea about it , i have been handed over a corrupt mysql asterisk db in which vicidial_manager & vicidial_auto_calls tbl(s) are corrupt.

I need to re-create these, can someone please share the structure of these tbl(s).


TIA

[mflorell]

the structure of all tables is in "extras/MySQL_AST_CREATE_tables.sql"

[williamconley]

Hi All,
I am new to this asterisk stuff, well basically i have no idea about it , i have been handed over a corrupt mysql asterisk db in which vicidial_manager & vicidial_auto_calls tbl(s) are corrupt.

I need to re-create these, can someone please share the structure of these tbl(s).


TIA

Of course ... you HAVE tried to repair them with mysqlcheck, right?

Plus, if you had provided your installation method, we could likely have told you precisely where the .sql file resides. For instance, in Vicibox distros after 2.0, it resides in /usr/src/astguiclient/trunk/extras

You should always list your Vicidial Version with build and your Installation Method with version.