How can Optimize one Databases

Nirjonadda

• December 14, 2017 18:00

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

• 

  24x7server

  • December 15, 2017 08:21

  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.

  0
• 

  Nirjonadda

  • December 15, 2017 09:04

  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
  

  0
• 

  cPanelMichael

  • December 15, 2017 17:47

  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.

  0
• 

  Nirjonadda

  • December 15, 2017 17:52

  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
  

  0
• 

  cPanelMichael

  • December 15, 2017 18:55

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

  0

Please sign in to leave a comment.