Not the answer you need?
Register and ask your own question!

Run a repair and optimization query in Mysql database

jacanandjacanand EntrantCurrent User Role Beginner
Hi,

I need to install my java application in a non-US operating machine. It has mysql as DB. After installing the app it is not working properly for some links, where as it works without any issues. I am not able to get the logs also. But I got a temporary work around like running the following command in the non-US operating system.

"for %i in (*.MYI) do ..\..\bin\myisamchk --defaults-file=..\..\my.cnf -c -r -a -v %i"

After applying this it works without any issues in the Non-Us OS. But I need to fix it permenantly, since customer wont accept the temp solution.

Please help on this.

Thanks.

Comments

  • jcesariojcesario Contributor Current User Role Beginner
    What does "non-US" mean ?

    What does the mysql error log contain ?

    Also, when it is not working properly for some links:
    Is there an error message returned? What is it ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.