Very urgent backup restore

This is the forum used by people to post job openings or requests for quotes or consultations

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

Very urgent backup restore

Postby Trying » Tue Oct 29, 2013 11:40 pm

We had a power failure yesterday and did a DB repair when the power came up but as it was running the power failed again. We are now getting corrupt tables that the repair cannot fix. We would probably have to restore a backup of Monday evening but have no idea how to do it. If anyone is available that knows EXACTLY what they are doing please let me know urgently as well as what your rates are. If the repair does not work we will require you to assist with the restore immediately.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Very urgent backup restore

Postby williamconley » Wed Oct 30, 2013 12:45 am

restore is usually $99 if you have a valid backup set.

but the process is fairly simple for the DB restore. unpack the files until you get the asterisk.sql file and then:

mysql -p

drop database asterisk

create database asterisk

exit

mysql -p asterisk < RESTOREFILE.sql

You'll need the root password for mysql, of course (if there is no root password, just leave off the -p). Note that if it succeeds, it will be silent for quite some time ... you can watch "htop" in another ssh session to watch it stay busy.

And get an unterruptible power supply (battery backup!) on the sql server. Really. 8-)
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Very urgent backup restore

Postby Trying » Wed Oct 30, 2013 12:50 am

Thanks a lot William. I will give it a go and if battling will get back to you for support. We have a UPS on it and shut down properly after the first power failure. However there was not enough time for it to charge again when the second power failure struck. Will get a second or stronger one though.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Very urgent backup restore

Postby Trying » Wed Oct 30, 2013 12:54 am

William, before I screw this up let me rather ask you to do it :) How quickly can you do it? We must be open for business within an hour. I can make payment immediately.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Re: Very urgent backup restore

Postby williamconley » Wed Oct 30, 2013 10:11 am

Yep. a phone call would be required to get emergency support at this time of night. Or some luck. That was my last post for the night.
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Jobs - Requests for Consultation

Who is online

Users browsing this forum: No registered users and 27 guests