Migration to a new Vicidial Server with Navicat?

All installation and configuration problems and questions

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

Migration to a new Vicidial Server with Navicat?

Postby oonyxx » Wed Oct 12, 2016 2:29 am

Hi all, i hope you are doing well.
I have a problem with a new installation of VICIbox 4.0.3 (Asterisk 1.4). I have installed the ISO and everything looks ok. What i need is to transfer all the Vicidial Files (Campaigns, Lists, Users, Call Statuses etc.) from the old server to the new one so they can start working the operators with nothing changed. Well, i don't much of SQL migration etc. so i install Navicat for more ease. Does anyone know what tables from the Asterisk DB do i need to transfer to the new Asterisk DB? How is it done with Navicat? I mean i know the export/import wizard... but...

Thanks i advance from your help!
Server1: Quad Core Xeon 3.0GHz | 24GB Ram | VICIdial 2.6-393a BUILD: 130124-1721 | Asterisk 1.4.44
Server2: Quad Core Xeon 2.8GHz | 8GB Ram | VICIdial 2.12-558a BUILD: 160602-1450 | Asterisk 1.4.44
oonyxx
 
Posts: 5
Joined: Tue Oct 11, 2016 7:16 am

Re: Migration to a new Vicidial Server with Navicat?

Postby dreedy » Thu Oct 13, 2016 9:11 am

I have only really used vicibox 6.0.3 but it would be worth checking in the 4.0.3 version directory of " /usr/share/astguiclient/ " for a a file called " ADMIN_backup.pl ". this utility would go through and tarball the db and the other components of the server. I am not sure if you are using a single server or cluster. you can also run the " ADMIN_backup.pl --help " and it will list out the variables of what actions it can take.

here is a link to more information.

http://www.vicidial.org/VICIDIALforum/v ... hp?t=11788
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Web (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici | VERSION: 2.14-924a | BUILD: 240716-1453 | svn 3856|dbschema 1717
dreedy
 
Posts: 182
Joined: Tue Nov 24, 2015 10:16 pm


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 102 guests