MemSQL Helios does not support this command.
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 Replay Configuration and Error Handling for information on errors that can occur during database recovery.
- This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).
memsql> REPAIR DATABASE test;