( mysql -u root -p to login mysql first )
TRUNCATE TABLE xtream_iptvpro.bouquets;
INSERT INTO xtream_iptvpro.bouquets (id, bouquet_name, bouquet_channels)
SELECT id, bouquet_name, bouquet_channels
from xtream_old.bouquets;
TRUNCATE TABLE xtream_iptvpro.member_groups;
INSERT INTO xtream_iptvpro.member_groups (group_id, group_name, group_color, is_banned, is_admin, is_reseller, total_allowed_gen_trials, total_allowed_gen_in, delete_users)
select group_id, group_name, group_color, is_banned, is_admin, is_reseller, total_allowed_gen_trials, total_allowed_gen_in, can_delete
from xtream_old.member_groups;
TRUNCATE TABLE xtream_iptvpro.reg_users;
INSERT INTO xtream_iptvpro.reg_users (id, username, password, email, ip, date_registered, verify_key, last_login, member_group_id, verified, credits, notes, status, default_lang)
select id, username, password, email, ip, date_registered, verify_key, last_login, member_group_id, verified, credits, notes, status, default_lang
from xtream_old.reg_users;
TRUNCATE TABLE xtream_iptvpro.streams;
INSERT INTO xtream_iptvpro.streams (id,`type`,category_id,stream_display_name,stream_source,stream_icon,notes,created_channel_location,enable_transcode,transcode_attributes,custom_ffmpeg,movie_propeties,movie_subtitles,read_native,target_container,stream_all,remove_subtitles,custom_sid,epg_id,channel_id,epg_lang,`order`,auto_restart,transcode_profile_id,pids_create_channel,cchannel_rsources,gen_timestamps,added)
SELECT id,`type`,category_id,stream_display_name,stream_source,stream_icon,notes,created_channel_location,enable_transcode,transcode_attributes,custom_ffmpeg,movie_propeties,movie_subtitles,read_native,target_container_id,stream_all,remove_subtitles,custom_sid,epg_id,channel_id,epg_lang,`order`,auto_restart,transcode_profile_id,pids_create_channel,create_channel_queue,gen_pts,added
FROM xtream_old.streams;
TRUNCATE TABLE xtream_iptvpro.streams_options;
INSERT INTO xtream_iptvpro.streams_options (id, stream_id, argument_id, `value`)
SELECT id, stream_id, argument_id, `value`
FROM xtream_old.streams_options;
TRUNCATE TABLE xtream_iptvpro.streams_sys;
INSERT INTO xtream_iptvpro.streams_sys (server_stream_id, stream_id, server_id, parent_id, pid, to_analyze, stream_status, stream_started, stream_info, current_source)
SELECT server_stream_id, stream_id, server_id, parent_id, pid, to_analyze, stream_status, stream_started, stream_info, current_source
FROM xtream_old.streams_sys;
TRUNCATE TABLE xtream_iptvpro.stream_categories;
INSERT INTO xtream_iptvpro.stream_categories (id,category_type,category_name)
SELECT id, category_type, category_name
FROM xtream_old.stream_categories;
TRUNCATE TABLE xtream_iptvpro.users;
INSERT INTO xtream_iptvpro.users (id, member_id, username, password, exp_date, admin_enabled, enabled, admin_notes, reseller_notes, bouquet, max_connections, is_restreamer, allowed_ips, allowed_ua, is_trial, created_at, created_by, pair_id, is_mag, force_server_id, is_isplock, as_number, isp_desc, forced_country, is_stalker)
SELECT `id`, `member_id`, `username`, `password`, `exp_date`, `admin_enabled`, `enabled`, `admin_notes`, `reseller_notes`, `bouquet`, `max_connections`, `is_restreamer`, `allowed_ips`, `allowed_ua`, `is_trial`, `created_at`, `created_by`, `pair_id`, `is_mag`, `force_server_id`, `is_isplock`, `as_number`, `isp_desc`, `forced_country`, `is_stalker`
FROM xtream_old.users;
TRUNCATE TABLE xtream_iptvpro.user_output;
INSERT INTO xtream_iptvpro.user_output (`id`, `user_id`, `access_output_id`)
SELECT `id`, `user_id`, `access_output_id`
FROM xtream_old.user_output;
