Adult Script Pro Community Forums
The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#2 2012-03-19 18:15:06
- ful2fun.com
- Member
- From: Usa
- Registered: 2011-09-16
- Posts: 1,041
- Website
Re: [ADDED IN 1.0] SQL repair
I Think you Should First try Optimize The SQL It might Solve Little Problem I Do that Only When It Crashes Mine MySQL.
Offline
#3 2012-03-20 01:41:12
Re: [ADDED IN 1.0] SQL repair
Its not possible to repair the SQL as that is in every module and either it works or it doesn't. Is there an error that needs to be resolved?
Offline
#4 2012-03-20 06:26:32
Re: [ADDED IN 1.0] SQL repair
I can add in Admin -> Tools (repair and optimize).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#6 2012-03-20 22:52:13
Re: [ADDED IN 1.0] SQL repair
Symtab, what are we talking about repairing here? The actual files or the tables in MySQL?
Offline
#7 2012-03-21 06:59:14
Re: [ADDED IN 1.0] SQL repair
The tables in MySQL.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#8 2012-03-21 11:42:23
Re: [ADDED IN 1.0] SQL repair
Ah ok, I was thinking Eri was talking about the actual queries and not the DB. Makes sense now. Thats what I get for posting so late in the day!
Offline
#9 2012-03-26 23:16:24
- Coscast
- Member
- From: Germany
- Registered: 2010-10-03
- Posts: 546
Re: [ADDED IN 1.0] SQL repair
Why don't you use that feature via phpmyadmin ? It's already implemented.
Offline
#11 2012-03-27 07:23:07
- ful2fun.com
- Member
- From: Usa
- Registered: 2011-09-16
- Posts: 1,041
- Website
Re: [ADDED IN 1.0] SQL repair
Our Sites Database Increase Because Of Views Record And Visitors Hits Records. As I See In My Site Database Daily It increases 2 MB To 3 MB With 1000 Views/Hits Currently It Is 160.14 MB But 1 Month Before It Is Used To Be 99 MB. So This Is Not The Solution To Repair/Optimize The MYSQL It Only Reduce 2 MB In 200 MB. There Should Be Some Other Way To Reduce Video History Size First And Second If We Can Reduce Size Of Tag Or We Can Remove Them From MYSQL And Shift Them To Some PHP Or TXT Files.
Offline
#12 2012-03-27 12:15:20
Re: [ADDED IN 1.0] SQL repair
My site was doing the same, so I just removed the code that adds a row to the video history. I left the code that increments the number of views as its just an update. This has helped a TON!
Offline
#13 2012-03-27 21:24:13
- Eri
- Member
- Registered: 2011-03-18
- Posts: 977
Re: [ADDED IN 1.0] SQL repair
My site was doing the same, so I just removed the code that adds a row to the video history. I left the code that increments the number of views as its just an update. This has helped a TON!
Yes , I have also removed all the embed code and my database was reduced by 40% more with this code 
http://forum.adultscriptpro.com/viewtop … 7025#p7025
Offline
Pages: 1