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:
For Repair:
# mysqlcheck --all-databases -r
For Analyze:
# mysqlcheck --all-databases -a
For optimize:
# mysqlcheck --all-databases -o
cheers!!!
# mysqlcheck --all-databases -o
cheers!!!
Comments
Post a Comment