Optimize Databases

Nirjonadda

• August 28, 2014 04:45

When I run an optimize for all databases with this command: mysqlcheck -u root --auto-repair --check --optimize --all-databases
OR mysqlcheck -Aor
Does not work and get this error, How to fixing on this issue ? Error: mysqlcheck doesn't support multiple contradicting commands.

• 

  cPanelMichael

  • August 28, 2014 12:27

  Hello :) Take out the "--check" flag from your first command and it should proceed. There is no need to check the databases if you are already going to attempt the repair. Thank you.

  0
• 

  Nirjonadda

  • August 28, 2014 14:28

  What is the "--check" flag ? Please post the Correct code command. Does this Correct commands? mysql -u root --auto-repair --check --optimize --all-databases
  or mysql -Aor
  

  0
• 

  cPanelMichael

  • August 28, 2014 14:58

  These are not commands that cPanel endorses, so we won't post commands like that. Essentially, for that command to work, you would have to remove the "--check" part of the command. Thank you.

  0
• 

  Nirjonadda

  • August 28, 2014 15:07

  Thanks, Now working ! mysqlcheck -u root --auto-repair --optimize --all-databases
  

  0

Please sign in to leave a comment.