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

[zoomaster]

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...

 

[Youmeirean]

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]

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

 

[Youmeirean]

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]

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]

has any manged to get this working is there a easyer way off doing it ?

 

[guetteur]

has any manged to get this working is there a easyer way off doing it ?

you can test it yourself
take backup and restore it into test server or virtual machine

 

[allserveruk]

i have backup from XUI when i put that backup into TEKO dose not show userers or streams dose not seem to work

 

[tomsaywer]

i have backup from XUI when i put that backup into TEKO dose not show userers or streams dose not seem to work

I have credits but I can't download

 

[zoomaster]

I have credits but I can't download

why friend?

 

[redhat]

I have credits but I can't download

Which issue you get ?

 

[keyvpn]

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

 

[amir29]

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