Thread: which SQL query syntax to optimize and repair a database?

i think i have ruined my database and don't know which SQL query syntax to optimize and repair a database.
can you tell me please which SQL query syntax to optimize and repair a database?


.

Is this for Mysql?
If yes, do you have access to phpmyadmin?

Are you using MySQL database, if yes then visit below link for manual repair
For repair: MySQL :: MySQL 5.1 Reference Manual :: 12.4.2.6 REPAIR TABLE Syntax
For Optimize: MySQL :: MySQL 5.1 Reference Manual :: 12.4.2.5 OPTIMIZE TABLE Syntax
For automatic repair visit: MySQL Repair Software Repair & Recover Corrupt/Damaged MySQL Database

yes mysql. i think i have once again ruined my database.
i can view the site and can also login in the dashboard but if i click Add new post or anywhere like themes or widget, it prompts The connection cannot be used to perform this operation.

Tell me what you did wrong, so I won't do it!
But really, in your mysql in cpanel, there is a button to hit to repair a database.
I have never tried that, but it may work.

Tell me what you did wrong, so I won't do it!

Yep, knowing what you did may help. I never tried the REPAIR TABLE function but it may help if the data was corrupted.

But if you ran some code to mess up the data, then it could be difficult to undo the damage.