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
mysqldump: Couldn't execute 'show fields from `access_output`': Got error 28 from storage engine (1030)
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 |
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 |
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 |
You had do this just for exporting, not to use on live system!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;
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 |
Thanks for sharingYou 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
Bash:mysql -u root -p
At the Enter password: prompt, well, enter mySQL Root Password
6. Select Xtream Codes Database
Bash:mysql> USE xtream_iptvpro;
7. Trim your Database and remove the useless entries with:
Bash: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
Bash:mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup.sql.gz
Export Xtream Codes Database with Timestamp and as gzip manually
Bash: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
Bash:mysql -u root -p xtream_iptvpro < [filename].sql
As gunzip archived sql (.sql.gz) File
Bash:gunzip < databasefile.sql.gz | mysql -u root -p xtream_iptvpro or zcat databasefile.sql.gz | mysql -u root -p xtream_iptvpro
It will remove the servers from the streams. ?TRUNCATE TABLE streams_sys;
will not effect any streaming ??
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 |
TRUNCATE TABLE epg_data; is fine becouse that will be filled when the epg runs.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 ??
Hi brother you can send me a links for test I m interestedi 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
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 |
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
Bash:mysql -u root -p
At the Enter password: prompt, well, enter mySQL Root Password
6. Select Xtream Codes Database
Bash:mysql> USE xtream_iptvpro;
7. Trim your Database and remove the useless entries with:
Bash: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
Bash:mysqldump -u root -p xtream_iptvpro | gzip > XtreamBackup.sql.gz
Export Xtream Codes Database with Timestamp and as gzip manually
Bash: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
Bash:mysql -u root -p xtream_iptvpro < [filename].sql
As gunzip archived sql (.sql.gz) File
Bash:gunzip < databasefile.sql.gz | mysql -u root -p xtream_iptvpro or zcat databasefile.sql.gz | mysql -u root -p xtream_iptvpro
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.