export-yap.sql

select concat("insert into conference_participants (callsid, conferencesid, friendlyname, timestamp) values ('", callsid, "','", conferencesid, "','", friendlyname, "','", timestamp, "')") from conference_participants;
select concat("insert into config (service_body_id, data_type, data, parent_id) values (", service_body_id, ",'", data_type, "','", data, "',", IFNULL(parent_id, "NULL"), ")") from config;
select concat("insert into metrics (timestamp, data) values ('", timestamp, "','", data, "')") from metrics;