24x7server

Well-Known Member
Apr 17, 2013
1,896
91
78
India
cPanel Access Level
Root Administrator
Hi,

What is the error that you are facing? Can you give us more information here, so we can take a look and check if that can be solved with guideliness and discussion or will require direct assistance.
 

Nirjonadda

Well-Known Member
May 8, 2013
659
17
68
cPanel Access Level
Root Administrator
Hi,

What is the error that you are facing? Can you give us more information here, so we can take a look and check if that can be solved with guideliness and discussion or will require direct assistance.
I like to Optimize one Databases, We can run an optimize for all databases with this command but not one database.

Code:
mysqlcheck -u root --auto-repair --optimize --all-databases
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
I like to Optimize one Databases, We can run an optimize for all databases with this command but not one database.
Hello,

You would simply replace the "--all-databases" part of that command with the actual database name. EX:

Code:
mysqlcheck --optimize database_name
Thank you.
 
  • Like
Reactions: Nirjonadda

Nirjonadda

Well-Known Member
May 8, 2013
659
17
68
cPanel Access Level
Root Administrator
Hello,

You would simply replace the "--all-databases" part of that command with the actual database name. EX:

Code:
mysqlcheck --optimize database_name
Thank you.
Also can be add repair? Is this command correct?

Code:
mysqlcheck -u root --auto-repair --optimize database_name
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

Yes, you can add in additional flags such as "--auto-repair" if you prefer and understand the purpose of doing so.

Thank you.
 
  • Like
Reactions: Nirjonadda