Help: How to automatic optimize table db

[destruction]

Could someone help me to figure it out How to automatic optimize table on database?so it's not manually to optimize database.

[tomws]

I think you've posted in the wrong forum. This doesn't seem to be an Apache problem. Besides that, your question is unclear. Optimize a table?

[Fou-Lu]

Also post what you're DB is, I moved it to mysql but I don't know if this is the type.

[destruction]

My db name rootnit_mumu
thanks to moved this thread Fou-Lu :)
Yup automatic to optimize sometimes it's broken - unable to connect db
but sometimes worked.
after I'm optimize and repair that back again :(
is that optimize or repair?

[Old Pedant]

FouLu meant what *KIND* of database is it. MySQL? SQL Server? Oracle? Access? What?

The name is not important at all.

[destruction]

Oh I'm sorry that's mysql

[Old Pedant]

Well, if you can't connect to the database, you can't run any query on it that would clean it up ("optimize" it).

So it might really be a PHP question, after all: Can your PHP code invoke the command line code that will optimize/clean the MySQL DB??

(If you aren't using PHP, then the same question about whatever you are using--JSP or ASP or whatever.)

I'm not a PHP programmer, so maybe somebody else here can help. If you don't get a response here, you might ask in the PHP forum. Your question comes down to: "How can PHP invoke an executable program, passing it arguments, so that the program can then optimize/cleanup my broken MySQL database?"

Now, the bigger question: How did the DB get "broken" in the first place???? I have used a single MySQL database for literally *millions* of operations without ever breaking it.

[destruction]

Ah I'm sorry for late reply. I've been fixed about that issues :( that's problem is on the value :(..Sorry...