Welcome to World of IPTV

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

Forum Rules

Before you start, check out the forum rules first

Account upgrade

Upgrade your account to get access to full features

Advertising

Would you like to place your advertisement with us ?

Resources Manager

Hundreds of IPTV scripts and apps are available for download

[HowTo] create SQL event to truncate logs in database automatically

hazdo

Extended Member
Ext. Member
Joined
Feb 6, 2020
Messages
53
Reaction score
273
Points
64
Location
germany
hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

 

tomsaywer

Banned
Banned
Ext. Member
Joined
Sep 28, 2019
Messages
235
Reaction score
1,558
Points
104
Location
PT
hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

No quote
how do you ship?
 
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

trol750

Extended Member
Ext. Member
Joined
Dec 19, 2019
Messages
87
Reaction score
506
Points
94
Location
Portugal
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'delimiter | CREATE EVENT `done_event` ON SCHEDULE EVERY 1 DAY ...' at line 1
 
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

nuraghi015

Seller
Seller
Ext. Member
Joined
Oct 15, 2019
Messages
48
Reaction score
115
Points
44
Location
Italy
any one know how to do in mariadb
hello mates here i am going to show you a method to truncate database logs automatically by specifaying the time to truncate
here i have select stream log table as the table i want to truncate
here is the code

No quote
how to do in mariadb?
 

ayouyou

Extended Member
Ext. Member
Joined
Jan 28, 2020
Messages
35
Reaction score
15
Points
19
Location
france
tout le monde sait faire dans mariadb

comment faire dans mariadb?
CREATE EVENT `done_event` ON SCHEDULE EVERY 1 DAY DO TRUNCATE TABLE `xtream_iptvpro`.`stream_logs` with phpmyadmin


and to edit time

DROP EVENT `done_event`; CREATE DEFINER=`root`@`localhost` EVENT `done_event` ON SCHEDULE AT '2021-04-09 12:56:45' ON COMPLETION NOT PRESERVE ENABLE DO TRUNCATE TABLE `xtream_iptvpro`.`stream_logs`
 
Last edited:
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
shape1
shape2
shape3
shape4
shape5
shape6
Top
AdBlock Detected

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.

I've Disabled AdBlock