Knowledgebase

How to delete calls and failed calls from Mysql database

PingPipe does not take any responsibility about the effects of the tutorial: this is just an example scenario. Always remember to do full database backup before making any changes to your database. 1) Make a database backup. 2) Go to start - > All programs - > Mysql - > MySQL Qwery Browser 3) Login to MySQL Query Browser: Chose the Database host - default "localhost"(1.) ; Chose the Mysql port - default "3306"(2.) ; Chose the Mysql username - default "root"(3.); Chose the Mysql password - (4.) Chose the voipswitch database - default "voipswitch"(5.)Click the "OK" button 4) Type the query to delete failedcalls: "DELETE FROM `voipswitch`.`callsfailed` where call_start <'2008-01-01';" (1.)

The query "DELETE FROM `voipswitch`.`callsfailed` where call_start <'2008-01-01'"
will delete all the failed calls that have been made before 1 January 2008.
The date can be changed - the format of the date is 'YYYY-MM-DD'

Tip2:
Below is te query for deleting calls instead callsfailed:
"DELETE FROM `voipswitch`.`calls` where call_start <'2008-01-01'"

Click the "execute" button to start the query(2.) 5) After finish just close the MySql Query Browser

Add to Favourites

Print this Article