clear log: 
mysql -u root -pn+s16456g xtream_iptvpro -s --execute="TRUNCATE client_logs;"
mysql -u root -pn+s16456g xtream_iptvpro -s --execute="TRUNCATE user_activity;"
mysql -u root -pn+s16456g xtream_iptvpro -s --execute="TRUNCATE user_activity_now;"
mysql -u root -pn+s16456g xtream_iptvpro -s --execute="TRUNCATE stream_logs;"
mysql -u root -pn+s16456g xtream_iptvpro -s --execute="TRUNCATE blocked_ips;"
#################################################################################################
mysql -u root -pN+s16456g
USE xtream_iptvpro;
UPDATE `streams` set `movie_propeties` = replace(`movie_propeties`, 'mytv4k.ddns.net:80', "reseller.mytv4k.net:2082") where `movie_propeties` like '%mytv4k.ddns.net:80%' ;
UPDATE `streams` set `movie_propeties` = replace(`movie_propeties`, 'mytv4k.ddns.net', "reseller.mytv4k.net") where `movie_propeties` like '%mytv4k.ddns.net%' ;
UPDATE `streams` SET `movie_propeties` = REPLACE(`movie_propeties`, 'eumytv.ath.cx', 'mytv4k.dyndns.org') WHERE `movie_propeties` LIKE '%eu.mytv4k.com%' COLLATE utf8mb4_bin

UPDATE `streams` SET `movie_propeties` = REPLACE(`movie_propeties`, "euro.mytv4k.net", "reseller.mytv4k.net") WHERE `movie_propeties` LIKE "%euro.mytv4k.net%";
UPDATE `streams` SET `movie_propeties` = REPLACE(`movie_propeties`, "GER_", "DE: ") WHERE `movie_propeties` LIKE "%GER_%";
UPDATE `streams` SET `movie_propeties` = REPLACE(`movie_propeties`, "TUR_", "TR: ") WHERE `movie_propeties` LIKE "%TUR_%";
UPDATE `streams` SET `stream_icon` = REPLACE(`stream_icon`, "pnl69.ath.cx", "69.mytv4k.net") WHERE `stream_icon` LIKE "%pnl69.ath.cx%";
UPDATE `streams` SET `stream_icon` = REPLACE(`stream_icon`, "euro.mytv4k.net", "reseller.mytv4k.net") WHERE `stream_icon` LIKE "%euro.mytv4k.net%";
UPDATE `series` SET `cover` = REPLACE(`cover`, "mytv4k.ddns.net:80/", "reseller.mytv4k.net:2082/") WHERE `cover` LIKE "%mytv4k.ddns.net:80/%";
UPDATE `series_episodes` SET `movie_image\` = REPLACE(`movie_image\`, "mytv4k.ddns.net:80/", "reseller.mytv4k.net:2082/") WHERE `movie_image\` LIKE "%mytv4k.ddns.net:80/%";
UPDATE `series_episodes` SET `movie_image` = REPLACE(`movie_image`, "mytv4k.ddns.net:80", "reseller.mytv4k.net:2082") WHERE `movie_image` LIKE "%mytv4k.ddns.net:80%";
stream_display_name
UPDATE `streams` SET `stream_display_name` = REPLACE(`stream_display_name`, "GER_", "DE: ") WHERE `stream_display_name` LIKE "%GER_:%";
UPDATE `streams` SET `stream_display_name` = REPLACE(`stream_display_name`, "ALB:", "AL: ") WHERE `stream_display_name` LIKE "%ALB:%";
UPDATE `series` SET `cover` = REPLACE(`cover`, "eumytv.ath.cx", "reseller.mytv4k.net") WHERE `stream_icon` LIKE "%eumytv.ath.cx%";
UPDATE `series_episodes` SET `cover_big` = REPLACE(`cover_big`, "eumytv.ath.cx", "mytv4k.ddns.net") WHERE `cover_big` LIKE "%eumytv.ath.cx%";
UPDATE `series` SET `cover_big` = REPLACE(`cover_big`, "reseller.mytv4k.net:8080", "mytv4k.ddns.net:2082") WHERE `cover_big` LIKE "%reseller.mytv4k.net:8080%";
##########################################################################################
mysql -u root -p
USE xtream_iptvpro;
TRUNCATE TABLE client_logs;
TRUNCATE TABLE panel_logs;
TRUNCATE TABLE user_activity;
TRUNCATE TABLE user_activity_now;
TRUNCATE TABLE reg_userlog;
TRUNCATE TABLE epg_data;
TRUNCATE TABLE streams_sys;
TRUNCATE TABLE stream_logs;
TRUNCATE TABLE streams_options;
##########################################################################################
look like problem in backup date, if you still have your old database on any server take backup again with command
mysql -u root -p xtream_iptvpro > /root/xtream_iptvpro.sql
but before take backup run this in phpmyadmin
TRUNCATE TABLE client_logs;
TRUNCATE TABLE user_activity;
TRUNCATE TABLE stream_logs;
TRUNCATE TABLE blocked_ips;
##########################################################################################
marian db passwort
CREATE USER 'root1'@'localhost' IDENTIFIED WITH mysql_native_password BY 'n+s1218080cs';
CREATE USER 'nazmi'@'localhost' IDENTIFIED BY 'n+s1218080cs';
GRANT ALL PRIVILEGES ON *.* TO 'nazmi'@'localhost';
############################################################################################
mysqldump -u root -pn+s16456g xtream_iptvpro > backup.sql

mysql -u root -p xtream_iptvpro < backup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro streaming_servers > eu_streaming_serversbackup.sql
mysql -u root -p xtream_iptvpro < eu_streaming_serversbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro streams > eu_streamsbackup.sql
mysql -u root -p xtream_iptvpro  < eu_streamsbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro reg_users > eu_reg_usersbackup.sql
mysql -u root -p xtream_iptvpro < eu_reg_usersbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro member_groups > eu_member_groupsbackup.sql
mysql -u root -p xtream_iptvpro < eu_member_groupsbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro settings > eu_settingsbackup.sql
mysql -u root -p xtream_iptvpro < eu_settingsbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro stream_categories > eu_stream_categoriesbackup.sql
mysql -u root -p xtream_iptvpro < eu_stream_categoriesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro series > eu_seriesbackup.sql
mysql -u root -p xtream_iptvpro < eu_seriesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro series_episodes > eu_series_episodesbackup.sql
mysql -u root -p xtream_iptvpro < eu_series_episodesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro packages > eu_packagesbackup.sql
mysql -u root -p xtream_iptvpro < eu_packagesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro bouquets > eu_bouquetsbackup.sql
mysql -u root -p xtream_iptvpro < eu_bouquetsbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro users > eu_usersbackup.sql
mysql -u root -p xtream_iptvpro < eu_usersbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro mag_devices > eu_mag_devicesbackup.sql
mysql -u root -p xtream_iptvpro < eu_mag_devicesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro enigma2_devices > eu_enigma2_devicesbackup.sql
mysql -u root -p xtream_iptvpro < eu_enigma2_devicesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro epg > eu_epgbackup.sql
mysql -u root -p xtream_iptvpro < eu_epgbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro transcoding_profiles > eu_transcoding_profilesbackup.sql
mysql -u root -p xtream_iptvpro < eu_transcoding_profilesbackup.sql
---------------------------------------------------------------------------
mysqldump xtream_iptvpro admin_settings > eu_admin_settingsbackup.sql
mysql -u root -p xtream_iptvpro < eu_admin_settingsbackup.sql
-----------------------------------------------------------------------------------
mysqldump -u root -p xtream_iptvpro access_output admin_settings blocked_ips blocked_user_agents bouquets client_logs created credits_log cronjobs dashboard_statistics devices enigma2_actions enigma2_devices enigma2_failed epg epg_data isp_addon licence login_flood login_logs login_users mag_claims mag_devices mag_events mag_logs member_groups packages panel_logs reg_userlog reg_users reseller_credentials reseller_imex rtmp_ips series series_episodes server_activity settings signals stream_categories stream_logs stream_subcategories streaming_servers streams streams_arguments streams_options streams_providers streams_seasons streams_sys streams_types subreseller_setup suspicious_logs tickets tickets_replies tmdb_async transcoding_profiles user_activity user_activity_now user_output users watch_categories watch_folders watch_output 	watch_settings xtream_main > backup05102021.sqlmysqldump -u root -p xtream_iptvpro > backup.sql
mysql xtream_iptvpro < backup.sql
mysql problem:

apt-get install libjemalloc1
service mysql restart

Step 1.
nano /etc/mysql/my.cnf

[mysqld_safe]
malloc-lib=/usr/lib64/libjemalloc.so.1


step 2. (add line enviroment)

nano /lib/systemd/system/mysql.service

Environment=/usr/lib/x86_64-linux-gnu/libjemalloc.so.1


Step 3.
now just restart mysql service with: 
service mysql restart 


How to Reset XtreamUI Admin Password

Login to the MySQL Server:
sudo mysql -u root -p

Now copy & past following commands:
UPDATE xtream_iptvpro.reg_users SET password='$6$rounds=20000$xtreamcodes$XThC5OwfuS0YwS4ahiifzF14vkGbGsFF1w7ETL4sRRC5sOrAWCjWvQJDromZUQoQuwbAXAFdX3h3Cp3vqulpS0' WHERE id='1';

UPDATE xtream_iptvpro.reg_users SET username = 'admin' WHERE id = '1';

UPDATE xtream_iptvpro.reg_users SET member_group_id = '1' WHERE id = '1';

exit

Now you can login with:
User: admin
Pass: admin