Tutorial Trim and Export and Import the Xtream Codes Database as sql or gzip manually

[elchispa]

gracias por todo

 

[giusi2015]

mysqldump: Couldn't execute 'show fields from `access_output`': Got error 28 from storage engine (1030)

had you fix this problem ?

--
-- Table structure for table `access_output`
--
DROP TABLE IF EXISTS `access_output` ;

?

 

[zxx96]

por todo

 

[morgalis]

thank you

 

[Drewey73]

If you are worried about database migration dump the whole xtream_iptvpro database create a cheap ups on ubuntu 16/18
Create a new database named xtream_iptvpro
Upload the database backup you made
Add a new server as main to streaminey
Then go to the migration tool in streaminey and put in the details for the vps with your backup database
Tested and worked for me

 

[Inzaghi9]

thanks
i will try it and will see if it will get me what i need
thanks again

 

[michael809]

help

mysql> mysqldu' at line 1
mysql> mysql> USE xtream_iptvpro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> USE xtream_iptvpro' at line 1

 

[tookayo]

thank you very much i have been looking this all over the internet

 

[nido]

Hello,
i'm facing issue after i did
Trim Database and remove the useless entries all channels stop working . i rebooted main server and all loadbalance but still not working
any ideas ?
Thanks

Codes with:
mysql> TRUNCATE TABLE client_logs;
mysql> TRUNCATE TABLE user_activity;
mysql> TRUNCATE TABLE user_activity_now;
mysql> TRUNCATE TABLE reg_userlog;
mysql> TRUNCATE TABLE epg_data;
mysql> TRUNCATE TABLE streams_sys;
mysql> TRUNCATE TABLE stream_logs;
mysql> TRUNCATE TABLE streams_options;

mysql> exit;

 

[BigCeti]

Thanks

 

[redhat]

Hello,
i'm facing issue after i did
Trim Database and remove the useless entries all channels stop working . i rebooted main server and all loadbalance but still not working
any ideas ?
Thanks

Codes with:
mysql> TRUNCATE TABLE client_logs;
mysql> TRUNCATE TABLE user_activity;
mysql> TRUNCATE TABLE user_activity_now;
mysql> TRUNCATE TABLE reg_userlog;
mysql> TRUNCATE TABLE epg_data;
mysql> TRUNCATE TABLE streams_sys;
mysql> TRUNCATE TABLE stream_logs;
mysql> TRUNCATE TABLE streams_options;

mysql> exit;

You had do this just for exporting, not to use on live system!
Also you alway should do a DB Backup before.

 

[didar]

Thanks for sharing

 

[bojep]

You can trim your Database and remove the useless entries. This will clear the tables client_logs and user_activity,

1. Install WinSCP
2. Install Putty
3. connect with WinSCP to your Server
4. open Putty
5. Connect to the Database

mysql -u root -p

At the Enter password: prompt, well, enter mySQL Root Password

6. Select Xtream Codes Database

mysql> USE xtream_iptvpro;

7. Trim your Database and remove the useless entries with:

mysql> TRUNCATE TABLE client_logs;
mysql> TRUNCATE TABLE user_activity;
mysql> TRUNCATE TABLE user_activity_now;
mysql> TRUNCATE TABLE reg_userlog;
mysql> TRUNCATE TABLE epg_data;
mysql> TRUNCATE TABLE streams_sys;
mysql> TRUNCATE TABLE stream_logs;
mysql> TRUNCATE TABLE streams_options;

mysql> exit;

8. Export Xtream Codes Database as gzip manually

mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup.sql.gz

Export Xtream Codes Database with Timestamp and as gzip manually

mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup_$(date "+%b_%d_%Y_%H_%M_%S").sql.gz

At the Enter password: prompt, enter again mySQL Root Password

9. Download with WinSCP the Backup File from /root Folder to your local PC

Importing the DB Dump in to the new DB

As .sql file

mysql -u root  -p xtream_iptvpro < [filename].sql

As gunzip archived sql (.sql.gz) File

gunzip < databasefile.sql.gz | mysql -u root -p xtream_iptvpro
or
zcat databasefile.sql.gz | mysql -u root -p xtream_iptvpro

Thanks for sharing

 

[dics123]

thank you

thank you

 

[daredevil]

TRUNCATE TABLE streams_sys;
will not effect any streaming ??

It will remove the servers from the streams. ?

 

[daredevil]

yes what about
TRUNCATE TABLE epg_data;
i think that it will cause nothing
i did search the entire sciript and didin't found where it is included ??

TRUNCATE TABLE epg_data; is fine becouse that will be filled when the epg runs.

 

[Vinista]

i have managed to install the panel for 3 days now and testing
working xcv2 migration works
all streams migrate ok
all users migrate ok
all bouquets migrate ok
all category live and vod migrate ok
all manage reseller migrate ok
RESELLER PACKAGES DOESN'T MIGRATE OK
NO VOD ARE IMPORTED ONLY HAVE TO DO MANUALLY
STREAMS THAT WERE ONDEMAND MIGRATE AS NORMAL STREAMS, SO CAN MASS EDIT AND PUT TO ONDEMAD

ONDEMAND STREAMS TAKING TO LONG TO OPEN OR NOT OPENING IF ANYONE CAN HELP WITH THE SETTINGS
Probesize Stream 5000000
Analyze Stream 16000000
Buffersize for Reading 4096
Prebuffer in Seconds 30
ANY ONE HAVE CORRECT SETTING FOR ONDEMAND TO WORK CORECTLY HELP PLS ????????

EPG FILES http://www.vuplus-community.net/rytec/rytecUK_Basic.xz .XZ FILES ARE NOT SUPPORTED ONLY .GZ FILES SUPPORTED
ALSO NEED THE URL TO FETCH THE EPG.XML FILE ANY HELP PLS ?????

OVERALL THE CMS IS WORKING OK AND HAPPY WITH STREAMINY CMS FEW SMALL TWEAKS NEEDED

THANKS TO STREAMINY TEAM ANY HELP WOULD BE APPRECIATED

Hi brother you can send me a links for test I m interested

 

[djasri]

u are the best

 

[medmen]

thanks guys i'll check my db migration from xtream codes to streminy

 

[bongera]

You can trim your Database and remove the useless entries. This will clear the tables client_logs and user_activity,

1. Install WinSCP
2. Install Putty
3. connect with WinSCP to your Server
4. open Putty
5. Connect to the Database

mysql -u root -p

At the Enter password: prompt, well, enter mySQL Root Password

6. Select Xtream Codes Database

mysql> USE xtream_iptvpro;

7. Trim your Database and remove the useless entries with:

mysql> TRUNCATE TABLE client_logs;
mysql> TRUNCATE TABLE user_activity;
mysql> TRUNCATE TABLE user_activity_now;
mysql> TRUNCATE TABLE reg_userlog;
mysql> TRUNCATE TABLE epg_data;
mysql> TRUNCATE TABLE streams_sys;
mysql> TRUNCATE TABLE stream_logs;
mysql> TRUNCATE TABLE streams_options;

mysql> exit;

8. Export Xtream Codes Database as gzip manually

mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup.sql.gz

Export Xtream Codes Database with Timestamp and as gzip manually

mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup_$(date "+%b_%d_%Y_%H_%M_%S").sql.gz

At the Enter password: prompt, enter again mySQL Root Password

9. Download with WinSCP the Backup File from /root Folder to your local PC

Importing the DB Dump in to the new DB

As .sql file

mysql -u root  -p xtream_iptvpro < [filename].sql

As gunzip archived sql (.sql.gz) File

gunzip < databasefile.sql.gz | mysql -u root -p xtream_iptvpro
or
zcat databasefile.sql.gz | mysql -u root -p xtream_iptvpro

Thanyou bro very useful post