Brings a database that has failed to recover (due to a log corruption) back into the online state.
MemSQL versions 4 and higher automatically repair databases as needed.
REPAIR DATABASE db_name
db_nameis the name of a MemSQL database.
- The database must be in an
offlinestate (see Database States).
REPAIR DATABASErecovers as much data as possible from the corrupted log.
- See Using Durability and Recovery for more information on database recovery and associated errors.
- This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
memsql> REPAIR DATABASE test;