Welcome to World of IPTV

With

+23k members
+11k threads
+106k posts

we are the most popular IPTV community on the web. 

IMPORTANT NOTE:
WE HAVE RECENTLY NOTICED THAT TOO MANY DOUBLE FAKE ACCOUNTS ARE CREATED IN THE PAST.
TO PREVENT THIS ISSUE THE DECISION WAS MADE THAT IN THE FUTURE A ANNUALLY FEE 20 EURO WILL BE RAISED FOR NEW MEMBERSHIPS.

Join now to the World of IPTV

Forum Rules

Before you start, check out the forum rules first

Account upgrade

Upgrade your account to get access to full features

Advertising

Would you like to place your advertisement with us ?

Resources Manager

Hundreds of IPTV scripts and apps are available for download
Resource icon

Resource MySql Codes - XUI one RETURN to Xtream Teko, Stream.. etc. 1.0

Register & Get access to index

zoomaster

Extended Member
Ext. Member
Joined
Apr 7, 2020
Messages
79
Reaction score
106
Points
44
Location
Portugal
zoomaster submitted a new resource:

MySql Codes - XUI one RETURN to Xtream Teko, StreamCreed etc. - Individuals codes for return to Xtream Database Default

Process step by step! Need know mysql code and can use management as mysql workbranch by oracle.
exemple named xui.bouquets - Database(xui).table(Bouquets)

Downloads files - ZipFolder are safe
URL LINK: ******

1 - do your backup - On your XUI.ONE Server
Run as root: mysqldump xui > backup.sql
2 - install mysql workbranch or use your software
3 - create a external user for mysql on your new xtream(teko, streamcreed or another)
4 - connect your database and create new schema named xui ( run...

Read more about this resource...
 
This resource has been reported as working in 0 time(s), and as not-working 0 time(s) this month.
(2 time(s) working and 0 time(s) not-working in total)

Youmeirean

VIP Member 3M
VIP Member 3M
Ext. Member
Joined
Jan 17, 2020
Messages
75
Reaction score
30
Points
29
Location
Myahbell1234
I followed every step that you mentioned above.. I have a lot of errors on Mysql Workbench

19:25:29 INSERT INTO bouquets..............
fyi been here had to edit quite alot of the scripts also unneeded steps inbetween in the readme. and all can be done via ssh no need for work bench
 

zoomaster

Extended Member
Ext. Member
Joined
Apr 7, 2020
Messages
79
Reaction score
106
Points
44
Location
Portugal
fyi been here had to edit quite alot of the scripts also unneeded steps inbetween in the readme. and all can be done via ssh no need for work bench
So, friend it's your vision! As I told need know mysql.
This error which friend are show is very simple. Are told primary key already exist. Only need change existent id or remove all and run again the code.
Other thing is, some DB are different, Streamcreed, xtream ui, xtream teko! So when see are missing attribute or have more attribute need fix as I told in read me.
Pls don't talk nothing if don't know what are u talking or doing. It's script is for professional. Thx
I told "workbench" is the software I used. You can use your software or another (SSH also) bye

I followed every step that you mentioned above.. I have a lot of errors on Mysql Workbench

19:25:29 INSERT INTO bouquets(id, bouquet_name, bouquet_channels, bouquet_series) SELECT id, bouquet_name, bouquet_channels, bouquet_series FROM xui.bouquets Error Code: 1062. Duplicate entry '1' for key 'PRIMARY' 0.000 sec
This error which friend are show is very simple. Are told primary key already exist. Only need change existent id or remove all and run again the code.
You have bouquets already create. Delete then run again. Thx

Other thing bro, read me I told! NEED KNOW MYSQL ok. This Error is very simple for don't understand.
Obs* Can't you show code inside resource bro. You pay and now are you give for all free? Maybe good way is private message. Thx
 
Last edited:
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com

Youmeirean

VIP Member 3M
VIP Member 3M
Ext. Member
Joined
Jan 17, 2020
Messages
75
Reaction score
30
Points
29
Location
Myahbell1234
So, friend it's your vision! As I told need know mysql.
This error which friend are show is very simple. Are told primary key already exist. Only need change existent id or remove all and run again the code.
Other thing is, some DB are different, Streamcreed, xtream ui, xtream teko! So when see are missing attribute or have more attribute need fix as I told in read me.
Pls don't talk nothing if don't know what are u talking or doing. It's script is for professional. Thx
I told "workbench" is the software I used. You can use your software or another (SSH also) bye


This error which friend are show is very simple. Are told primary key already exist. Only need change existent id or remove all and run again the code.
You have bouquets already create. Delete then run again. Thx

Other thing bro, read me I told! NEED KNOW MYSQL ok. This Error is very simple for don't understand.
Obs* Can't you show code inside resource bro. You pay and now are you give for all free? Maybe good way is private message. Thx
i know he needs to add the WHERE id > 1; cluse to it so dont come being cleaver i also know mysql my self all i was doing was pointing out the scripts need adjusting thanks
 

zoomaster

Extended Member
Ext. Member
Joined
Apr 7, 2020
Messages
79
Reaction score
106
Points
44
Location
Portugal
i know he needs to add the WHERE id > 1; cluse to it so dont come being cleaver i also know mysql my self all i was doing was pointing out the scripts need adjusting thanks
ok friend. Don't need adjust, when buy only know what are u doing! The code is referrence to migration.
 

allserveruk

Extended Member
Ext. Member
Joined
Mar 22, 2020
Messages
233
Reaction score
24
Points
29
Location
england
has any manged to get this working is there a easyer way off doing it ?
 
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com

allserveruk

Extended Member
Ext. Member
Joined
Mar 22, 2020
Messages
233
Reaction score
24
Points
29
Location
england
i have backup from XUI when i put that backup into TEKO dose not show userers or streams dose not seem to work
 
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com

keyvpn

Extended Member
Ext. Member
Joined
Oct 18, 2019
Messages
23
Reaction score
5
Points
14
Location
London
I found out today that none of my backups from ck mods had users, or half the other stuff.
properly fucked me up.
great panel. was until it zapped
 
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com

amir29

Extended Member
Ext. Member
Joined
Sep 10, 2019
Messages
23
Reaction score
20
Points
14
Location
Amir2906
greetings to everyone, I have one question for everyone, I'm trying to migrate the database from xui.one to CK, I follow these instructions 1 - do your backup - On your XUI.ONE Server Run as root: mysqldump xui > backup.sql 2 - install mysql workbranch or use your software 3 - create an external user for mysql on your new xtream (teko, streamcreed or another) 4 - connect your database and create a new schema named xui ( run --> create schema xui; ) 5 - dump your backup for new schema ( Upload backup.sql to your new xtream (teko, streamcreed or another) (It's OK to use /root) Run as root: mysql xui < /root/backup.sql
  1. and the first 4 packages pass without any problems bouquets - 01 category - 02 packages - 03 epg - 04 but when I get to the streams, it throws me this crap ERROR 1305 (42000): FUNCTION xtream_iptvpro.REGEXP_REPLACE does not exist this is the command I'm learning with INSERT INTO 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, auto_restart, transcode_profile_id, pids_create_channel, cchannel_rsources, gen_timestamps, added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, movie_symlink, redirect_stream, rtmp_output, number, allow_record, probesize_ondemand, custom_map, external_push, delay_minutes, is_adult, is_website, mng_order) SELECT id, type, REGEXP_REPLACE(category_id, '[^0-9]+', ''), stream_display_name, stream_source, IFNULL(stream_icon, ''), notes, 0,enable_transcode, IFNULL(transcode_attributes, ''), IFNULL (custom_ffmpeg, ''), movie_properties, IFNULL(movie_subtitles, ''), read_native, target_container, stream_all, remove_subtitles, custom_sid, epg_id, channel_id, epg_lang, IFNULL(auto_restart, ''), transcode_profile_id, '', '', gen_timestamps , added, series_no, direct_source, tv_archive_duration, tv_archive_server_id, tv_archive_pid, 0, 0, rtmp_output, 0, allow_record, probesize_ondemand, IFNULL(custom_map, ''), IFNULL(external_push, ''), delay_minutes, 0,0,0 FROM xui.streams; here in the picture
 

Attachments

  • image.png
    image.png
    147.2 KB · Views: 34
shape1
shape2
shape3
shape4
shape5
shape6
Top
AdBlock Detected

We know, ad-blocking software do a great job at blocking ads. But our site is sponsored by advertising. 

For the best possible site experience please take a moment to disable your AdBlocker.
You can create a Account with us or if you already have account, you can prefer an Account Upgrade.

I've Disabled AdBlock