Tuesday, 5 April 2016

Repair all tables in one-shot

Rather than typing the query repair table ''tablename''; for all the tables one by one.

# mysqlcheck -u root --password=thepass --auto-repair --check --all-databases
Posted by at

2 comments:

  1. anujjain14 April 2016 at 09:47

    I will not work when password contains &(ampersand)

    ReplyDelete
  2. Anchal Singh20 April 2016 at 07:23

    To escape either ' single or " double quotes in the password, you can either escape them with a leading backslash, or enclose the entire argument in the opposite style of quotes if there are no other characters that the chosen style of quoting isn't compatible with.

    ReplyDelete

Subscribe to: Post Comments (Atom)