How to import XS 2.9 database into XS 1.06?

[freaktab]

How to import XS 2.9 database into XS 1.06?

 

[ChickenWarrior]

You need to extract the data table by table and import removing any columns that are no longer applicable.

 

[megaman20]

just download you database from php and upload it

 

[arber]

What i did was extract table by table export them in .csv file and recopy one by one. db of 2.9 had more fields in user, mag tables. so no mass transfer table to table.

 

[multififa]

import db xtream 2 in same istance mysql and call this db xtream_old

user

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, CASE wHEN is_isplock = null THEN "0" Else "0" END is_isplock, CASE wHEN as_number = null THEN "" Else "" END as_number, CASE wHEN isp_desc = null THEN "" Else "" END isp_desc, forced_country as fotickets_repliesrced_country , is_stalker from xtream_old.users



reg user


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






if you want i will pass query for streaming and bouquet

 

[sheko2020]

import db xtream 2 in same istance mysql and call this db xtream_old

user

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, CASE wHEN is_isplock = null THEN "0" Else "0" END is_isplock, CASE wHEN as_number = null THEN "" Else "" END as_number, CASE wHEN isp_desc = null THEN "" Else "" END isp_desc, forced_country as fotickets_repliesrced_country , is_stalker from xtream_old.users



reg user


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






if you want i will pass query for streaming and bouquet

could you process for for streaming , package ,reseller, and bouqet

thx

 

[redcartr]

for mag device need migrate

thank you

 

[redcartr]

mysqldump: Got error: 1049: Unknown database 'xtream_iptvpro.users' when selecting the database

 

[multififa]

yes in same istance mysql import dump xtream 2 in dabase xtream_iptvpro