Sunday, 24 February 2013

How repair ALL database tables:

Here the command for repair, alalyze or optimze all database talbes in server.


# mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Below commands are also do the same without mysql root password:

For Repair:

# mysqlcheck --all-databases -r

For Analyze:

# mysqlcheck --all-databases -a

For optimize:

# mysqlcheck --all-databases -o

cheers!!!

No comments:

Post a Comment