Page 1 of 1

corrupt asterisk db

PostPosted: Mon Jan 18, 2016 1:22 am
by 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

Re: corrupt asterisk db

PostPosted: Mon Jan 18, 2016 7:14 am
by mflorell
the structure of all tables is in "extras/MySQL_AST_CREATE_tables.sql"

Re: corrupt asterisk db

PostPosted: Mon Jan 18, 2016 10:57 am
by williamconley
tristan625 wrote: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.