database xtream ui

[michy2106]

hello everyone, I have just installed xtream ui and now I should move my datebase. before I used phpmyadmin. now if i install it n i see the database. is there a way like phpmyadmin for xtream ui?

 

[doc]

Just install phpmyadmin and use it on :80 with Apache.
Or use Webmin.

 

[redhat]

Allway restore your DB directly in mySQL. PhpMyAdmin is a security issue in my mind.

 

[doc]

Allway restore your DB directly in mySQL. PhpMyAdmin is a security issue in my mind.

Bad configuration is a bigger problem

 

[michy2106]

Just install phpmyadmin and use it on :80 with Apache.
Or use Webmin.

I have phpmyadmin installed but I don't see the database

 

[michy2106]

Allway restore your DB directly in mySQL. PhpMyAdmin is a security issue in my mind.

Allway restore your DB directly in mySQL. PhpMyAdmin is a security issue in my mind.

I tried but it gives me error for the same columns

 

[Euro-iptv]

hello everyone, I have just installed xtream ui and now I should move my datebase. before I used phpmyadmin. now if i install it n i see the database. is there a way like phpmyadmin for xtream ui?

for move database .. upload your backup database on main server tmp and run command in ssh
mysql -u root -p xtream_iptvpro < /tmp/xtream_iptvpro.sql
and wait after few minutes database should restored, time depended on database volume

 

[michy2106]

for move database .. upload your backup database on main server tmp and run command in ssh
mysql -u root -p xtream_iptvpro < /tmp/xtream_iptvpro.sql
and wait after few minutes database sh

already made excto this error 1050 at line 29 etc

 

[Euro-iptv]

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;

 

[michy2106]

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;

but the problem already gives it to the first access output table so I don't think so

 

[urgodfather]

dont use phpmyadmin unless you like getting hacked.

 

[michy2106]

dont use phpmyadmin unless you like getting hacked.

give me help me.

 

[Ruthless]

Yes I suggest mySQL

 

[Ricky1331]

hello everyone, I have just installed xtream ui and now I should move my datebase. before I used phpmyadmin. now if i install it n i see the database. is there a way like phpmyadmin for xtream ui?

the database you will found it like this xtream_iptvpro
if you use Ubunto 16.04 or Ubunto 18.04 with phpmyadmin dont use user: root
create other user name
if you want once you use phpmyadmin and you not going to use it, you can desable the phpmyadmin with a command and if you have to use again you can activated again, then when you are done you can disabled again.

 

[delphiniptv]

if you have an error with

but the problem already gives it to the first access output table so I don't think so

if you get wrong with that, you have to put this line before because it does not allow you to load large files
In mysql sesion :
SET GLOBAL max_allowed_packet=1073741824;