How can Optimize one Databases

[Nirjonadda]

Please let me know that How can Optimize/repair one Databases, not all database?

 

[24x7server]

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]

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.

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

 

[cPanelMichael]

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:

mysqlcheck --optimize database_name

Thank you.

 

[Nirjonadda]

Hello,

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

mysqlcheck --optimize database_name

Thank you.

Also can be add repair? Is this command correct?

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

 

[cPanelMichael]

Hello,

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

Thank you.