Tutorial Import (convert) Xtream Codes v1.0.60 DB in to Xtream Codes v2.9.3 (Xtream-UI) DB

[redhat]

Dear Members,

if you are planing to change from Xtream Codes v1.0.60 to Xtream Codes v2.9.3 (Xtream-UI) so you need also import your Database.
So here is solution how can do it. But please note that maybe there some missed Tables.


The changes will do in following tables:
- bouquets
- mag_devices
- packages
- reg_users
- streams
- stream_categories
- users

How to use it:

1. On your Main Server where is Xtream Codes v2.9.3 (Xtream-UI) is already install phpmyadmin
2. Very IMPORTANT: Take Backup of your current Xtream Codes v2.9.3 (Xtream-UI) Database
3. Create a new Database from phpmyadmin, name it for example "xtream_iptvpro_v16"
4. Import your Xtream Codes v1.0.60 Database-Backup in to the new created Database "xtream_iptvpro_v16"
5. Run following SQL queries:

DELETE FROM xtream_iptvpro.`bouquets`;
DELETE FROM xtream_iptvpro.`mag_devices`;
DELETE FROM xtream_iptvpro.`packages`;
DELETE FROM xtream_iptvpro.`reg_users`;
DELETE FROM xtream_iptvpro.`streams`;
DELETE FROM xtream_iptvpro.`stream_categories`;
DELETE FROM xtream_iptvpro.`users`;

INSERT INTO xtream_iptvpro.`bouquets` (id, bouquet_name, bouquet_channels, bouquet_series)
SELECT id, bouquet_name, bouquet_channels, '[]'  FROM xtream_iptvpro_v16.`bouquets`;

INSERT INTO xtream_iptvpro.`mag_devices`
SELECT *, '', 'fit', 0, 'metric', '', 0 FROM xtream_iptvpro_v16.`mag_devices`;

INSERT INTO xtream_iptvpro.`packages`
SELECT *, 1, 0, 0, 0, 0, '', 0 FROM xtream_iptvpro_v16.`packages`;

INSERT INTO xtream_iptvpro.`reg_users`
SELECT *, '', 0, NULL, ''  FROM xtream_iptvpro_v16.`reg_users`;

INSERT INTO xtream_iptvpro.`streams`
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`,'',1,`added`,
0,0,0,0,0,0,0,0,0,0,128000,'','',0
FROM xtream_iptvpro_v16.`streams`;

INSERT INTO xtream_iptvpro.`stream_categories`
SELECT *, 0, 0 FROM xtream_iptvpro_v16.`stream_categories`;

INSERT INTO xtream_iptvpro.`users`
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`,0,`force_server_id`,`is_isplock`,`as_number`,`isp_desc`,`forced_country`,`is_stalker`,0,''
FROM xtream_iptvpro_v16.`users`;

Login to you Panel and check for and issues, You have assign your streams to your Servers (Loadbalancers) manually.

It would be fine, if you try it out and left your comments.

 

[akawi11]

that's great
i think it's will be better to clean all LB with fresh install xtream-ui

 

[kutchsky]

yes works good mate

 

[shin-]

for broadcast pannel possible migration?

 

[naskimother]

Hi,
Everything else was working fine but not a movie database, instead of gating .mp4 on playlist I'm gating .1 The only way is to recreate the movie than fix the extension to .mp4.
Please check if you have any solution for that.

Thank You

 

[stefki]

@redhat can you please check the reg_users table with latest Xtrem UI 22B , I can't import this table
it says error

ERROR 1136 (21S01): Column count doesn't match value count at row 1


INSERT INTO xtream_iptvpro.`reg_users`
SELECT *, '', 0, NULL, '' FROM xtream_iptvpro_v16.`reg_users`;

All other tables are nicely imported


tnx

 

[hazeki34]

Hello friends,

can you help me from xtream-codes 1.0.44 to xtream-ui import db ?

thank you