[ADDED IN 1.0] SQL repair

Eri · 2012-03-19 17:13:07

A php file that will repair SQL will be great because database site gets crashes sometimes

ful2fun.com · 2012-03-19 18:15:06

I Think you Should First try Optimize The SQL It might Solve Little Problem I Do that Only When It Crashes Mine MySQL.

THS · 2012-03-20 01:41:12

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?

symtab · 2012-03-20 06:26:32

I can add in Admin -> Tools (repair and optimize).

Eri · 2012-03-20 08:52:49

Yes that will be great

THS · 2012-03-20 22:52:13

Symtab, what are we talking about repairing here? The actual files or the tables in MySQL?

symtab · 2012-03-21 06:59:14

The tables in MySQL.

THS · 2012-03-21 11:42:23

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!

Coscast · 2012-03-26 23:16:24

Why don't you use that feature via phpmyadmin ? It's already implemented.

Eri · 2012-03-27 07:08:32

MY database is over 1GB ans I have to do it with SSH.

ful2fun.com · 2012-03-27 07:23:07

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.

ful2fun.com
livesexpirates.com

THS · 2012-03-27 12:15:20

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!

Eri · 2012-03-27 21:24:13

THS wrote:

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

Adult Script Pro Community Forums

#1 2012-03-19 17:13:07

[ADDED IN 1.0] SQL repair

#2 2012-03-19 18:15:06

Re: [ADDED IN 1.0] SQL repair

#3 2012-03-20 01:41:12

Re: [ADDED IN 1.0] SQL repair

#4 2012-03-20 06:26:32

Re: [ADDED IN 1.0] SQL repair

#5 2012-03-20 08:52:49

Re: [ADDED IN 1.0] SQL repair

#6 2012-03-20 22:52:13

Re: [ADDED IN 1.0] SQL repair

#7 2012-03-21 06:59:14

Re: [ADDED IN 1.0] SQL repair

#8 2012-03-21 11:42:23

Re: [ADDED IN 1.0] SQL repair

#9 2012-03-26 23:16:24

Re: [ADDED IN 1.0] SQL repair

#10 2012-03-27 07:08:32

Re: [ADDED IN 1.0] SQL repair

#11 2012-03-27 07:23:07

Re: [ADDED IN 1.0] SQL repair

#12 2012-03-27 12:15:20

Re: [ADDED IN 1.0] SQL repair

#13 2012-03-27 21:24:13

Re: [ADDED IN 1.0] SQL repair

Board footer