SQL LOGS

dazza1223 · Post by **dazza1223** » Mon 28 Jan 2019 11:09 am

hi i had some erroes in my logs ive fix then but i got some errors in my sql data... i dont know how to delete january logs

is there a query that i can run to remove january logs ?

Post by **water01** » Mon 28 Jan 2019 2:31 pm

Any reason why you cannot run phpMyAdmin in a browser on the database server and remove the data that way? That is what I always used to do.

dazza1223 · Post by **dazza1223** » Mon 28 Jan 2019 5:13 pm

ok water thank thank you and how do u search phpmyadmin?

Post by **water01** » Mon 28 Jan 2019 5:32 pm

Where exactly are you holding your Cumulus MX MySQL database?

If it is on a server supplied by your hosting company you should have access to it via the Cpanel area.

If you have set up your own host using Apache Server for instance then download phpmyadmin from here https://www.phpmyadmin.net/ install it in the htdocs area of the server space and then browse to it via a browser.

dazza1223 · Post by **dazza1223** » Mon 28 Jan 2019 8:01 pm

ok i got phpmyadmin all runing now so do i need to search for that date if so how? as i cant see it in phpmyadmin?

typiod · Post by **typiod** » Tue 29 Jan 2019 7:31 pm

dazza open phpmyadmin, then select databases (near the top left handside), then you can select your db. From there you can select your dayfile, monthly, or realtime, table, click on edit next to the table that you want to alter you will then see all of the data stored in that particular table scroll to the date you want to change the data on then select edit on the left hand side

dazza1223 · Post by **dazza1223** » Tue 29 Jan 2019 8:18 pm

ha that did the trick thank u

Cumulus Support

SQL LOGS

SQL LOGS

Re: SQL LOGS

Re: SQL LOGS

Re: SQL LOGS

Re: SQL LOGS

Re: SQL LOGS

Re: SQL LOGS