mysql question

All installation and configuration problems and questions

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

mysql question

Postby Michael_N » Mon Mar 03, 2008 6:32 pm

In my vicidial_conferences table i have got the conferences wrong

how do i clear the table so that i only have on conference each?

and not like this:

"8600051","81.170.195.**",""
"8600051","81.170.195.**",""
"8600052","81.170.195.**",""
"8600052","81.170.195.***",""
etc
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby enjay » Mon Mar 03, 2008 7:11 pm

You could just wipe them all out and reimport them..

delete from vicidial_conferences;

then just grab the INSERT INTO vicidial_conferences from the SCRATCH_INSTALL replace the serverip and paste..

"dont do this while dialing".
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah

Postby Michael_N » Tue Mar 04, 2008 6:14 pm

Thank you very much

//michael
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby aster1 » Wed Mar 05, 2008 12:16 am

You can also user AST_update_server_ip.pl ( name might be bit different ) .
aster1
 
Posts: 281
Joined: Sun Dec 24, 2006 6:48 am
Location: India


Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 264 guests