database repair

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

database repair

Postby vlademir12 » Fri May 04, 2012 1:55 pm

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? :? :?
vlademir12
 
Posts: 6
Joined: Fri May 04, 2012 1:51 pm

Re: database repair

Postby spacejanitor » Fri May 04, 2012 3:03 pm

Did you try running...

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
http://www.MarketResearchTechnology.com
We are the leading users of ViciDial, LimeSurvey and Drupal in the market research industry. We're also a lead provider- contact us.

Cluster Installation, ViciBox Server
VERSION: 2.6-372a
BUILD: 120713-2123
spacejanitor
 
Posts: 178
Joined: Tue Feb 08, 2011 3:31 pm

Re: database repair

Postby vlademir12 » Fri May 04, 2012 9:56 pm

i did and i got this error

mysql: unknown option '--auto-repair'
vlademir12
 
Posts: 6
Joined: Fri May 04, 2012 1:51 pm

Re: database repair

Postby rrb555 » Fri May 04, 2012 10:16 pm

try this one instead

Code: Select all
mysqlcheck --all-databases -o -r
One server that I am managing | Single Server | ViciBox Redux 6.0 | VERSION: 2.12-549a | BUILD: 160404-0940 | revision 2508| No other hardware
For help you can send me a direct email info@support.com.ph
rrb555
 
Posts: 585
Joined: Tue Feb 08, 2011 4:24 pm
Location: Quezon City, Philippines

Re: database repair

Postby vlademir12 » Fri May 04, 2012 10:22 pm

i just forgot the "check" the 1st command works and im on processing it.. thanks anyway.. =)
vlademir12
 
Posts: 6
Joined: Fri May 04, 2012 1:51 pm

Re: database repair

Postby rrb555 » Fri May 04, 2012 10:27 pm

Sounds great, now have fun

8)
One server that I am managing | Single Server | ViciBox Redux 6.0 | VERSION: 2.12-549a | BUILD: 160404-0940 | revision 2508| No other hardware
For help you can send me a direct email info@support.com.ph
rrb555
 
Posts: 585
Joined: Tue Feb 08, 2011 4:24 pm
Location: Quezon City, Philippines

Re: database repair

Postby vlademir12 » Fri May 04, 2012 11:28 pm

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
vlademir12
 
Posts: 6
Joined: Fri May 04, 2012 1:51 pm

Re: database repair

Postby rrb555 » Fri May 04, 2012 11:53 pm

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
One server that I am managing | Single Server | ViciBox Redux 6.0 | VERSION: 2.12-549a | BUILD: 160404-0940 | revision 2508| No other hardware
For help you can send me a direct email info@support.com.ph
rrb555
 
Posts: 585
Joined: Tue Feb 08, 2011 4:24 pm
Location: Quezon City, Philippines

Re: database repair

Postby williamconley » Sun May 06, 2012 4:06 pm

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?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: database repair

Postby vlademir12 » Mon May 07, 2012 4:38 am

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.
vlademir12
 
Posts: 6
Joined: Fri May 04, 2012 1:51 pm

Re: database repair

Postby boybawang » Mon May 07, 2012 12:25 pm

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
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines

Re: database repair

Postby boybawang » Mon May 07, 2012 12:32 pm

also for database repair you can try this: mysqlcheck -p --databases=asterisk -o -r
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
boybawang
 
Posts: 989
Joined: Sat Nov 14, 2009 1:18 pm
Location: Dumaguete City, Negros Oriental, Philippines


Return to Support

Who is online

Users browsing this forum: No registered users and 132 guests