Question sql backup problem

[kalitv]

hi guys I have a problem with the size of my sql, is there yet what am I doing wrong?

6-AD54-DB8-9476-4-E6-A-A64-B-244502-D0-EAEA hosted at ImgBB

Image 6-AD54-DB8-9476-4-E6-A-A64-B-244502-D0-EAEA hosted in ImgBB

ibb.co

 

[mini-pro]

hi guys I have a problem with the size of my sql, is there yet what am I doing wrong?

6-AD54-DB8-9476-4-E6-A-A64-B-244502-D0-EAEA hosted at ImgBB

Image 6-AD54-DB8-9476-4-E6-A-A64-B-244502-D0-EAEA hosted in ImgBB

ibb.co

Clear logs from database.

 

[kalitv]

Clear logs from database.

I think the problem is the reseller log

but from the panel it won't let me delete it, bandwidth error 503 and it won't load the page.

is there another way to delete those logs?

 

[iptvayr]

I think the problem is the reseller log

but from the panel it won't let me delete it, bandwidth error 503 and it won't load the page.

is there another way to delete those logs?

Log into mysql/Mariadb via ssh
Select the database with the user command

TRUNCATE thr tables you want to clear

 

[kalitv]

Log into mysql/Mariadb via ssh
Select the database with the user command

TRUNCATE thr tables you want to clear

thanks i will try

 

[kalitv]

Log into mysql/Mariadb via ssh
Select the database with the user command

TRUNCATE thr tables you want to clear

I tried with TRUNCATE, delete and drop but the system keeps thinking and does nothing due to the large table size.

is there any way to force delete the table?

is it possible to delete the file manually with # rm?

 

[Xaltouney]

I tried with TRUNCATE, delete and drop but the system keeps thinking and does nothing due to the large table size.

is there any way to force delete the table?

is it possible to delete the file manually with # rm?

its not folder/file its sql imput... so you need to open mysql daemon to make it manualy.
you can use navicat/heidiSQL, the GUI is more easy for noob!

 

[kartel]

I tried with TRUNCATE, delete and drop but the system keeps thinking and does nothing due to the large table size.

is there any way to force delete the table?

is it possible to delete the file manually with # rm?

Login to XC via MySql
mysql -u root -pPASSWORD
use xtream_iptvpro;

Then run each one of these commands:

TRUNCATE panel_logs;
TRUNCATE client_logs;
TRUNCATE stream_logs;
TRUNCATE epg_data;
TRUNCATE user_activity;

 

[kalitv]

I have already used these commands. in all the log tables they work but in stream_logs it keeps thinking and does nothing, so I ask if there is another way
no oteo command works.

delete
drop
truncate

that table seems to exceed the size

stream_log 44447 MB size

 

[kartel]

I have already used these commands. in all the log tables they work but in stream_logs it keeps thinking and does nothing, so I ask if there is another way
no oteo command works.

delete
drop
truncate

that table seems to exceed the size

stream_log 44447 MB size

have you tried deleting in the database?

 

[kalitv]

have you tried deleting in the database?

try deleting that particular table and then creating the same table with the same structure, but it doesn't answer anything in that table.

 

[mroz]

The best way delete the log tables in sql that is the best option

 

[kalitv]

my solution

mysql_upgrade
truncate table stream_logs;

ok ok