Page 1 of 1

mysql question

PostPosted: Mon Mar 03, 2008 6:32 pm
by Michael_N
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

PostPosted: Mon Mar 03, 2008 7:11 pm
by enjay
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".

PostPosted: Tue Mar 04, 2008 6:14 pm
by Michael_N
Thank you very much

//michael

PostPosted: Wed Mar 05, 2008 12:16 am
by aster1
You can also user AST_update_server_ip.pl ( name might be bit different ) .