Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.
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.
offlinestate (see Database States).
REPAIR DATABASErecovers as much data as possible from the corrupted log.
memsql> REPAIR DATABASE test;