database repair

[vlademir12]

1) Version of VICIDIAL – 2.4-310a
2) loadavg – 0.37
3) Server Specs – 500G – HD, Quad core, 4G RAM
4) Codecs used – G729
5) VOIP or PSTN - VOIP
6) OS – Windows XP for work stations

i cant generate reports on my database is there any way to repair my database if yes how?
anyone can teach me how to repair my database?

[spacejanitor]

Did you try running...

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

[vlademir12]

i did and i got this error

mysql: unknown option '--auto-repair'

[rrb555]

try this one instead

Code: Select all

mysqlcheck --all-databases -o -r

[vlademir12]

i just forgot the "check" the 1st command works and im on processing it.. thanks anyway.. =)

[rrb555]

Sounds great, now have fun

[vlademir12]

still i got this error when im using export call report any idea how to fix this =)

There are no outbound calls during this time period for these parameters

[rrb555]

can u make a snapshot or anything that could help us identify the issue. give as much information as u can give so we could analyze it more

[williamconley]

still i got this error

The earlier error of not recognizing --auto-repair had been resolved, so that isn't the error ... so to what error do you refer?

[vlademir12]

ok this is the problem..

i cant generate any outbound report and export report it always says "There are no outbound calls during this time period for these parameters " i already check all the parameters dates campaigns etc.. still same output.

[boybawang]

Do you have archiving enabled? probably the reports you are looking for are in the _archive tables , if so you can do a REPLACE INTO _log SELECT * FROM _log_archive to put back the archived rows into the main log file

[boybawang]

also for database repair you can try this: mysqlcheck -p --databases=asterisk -o -r