I’m trying to import a sql dump file (db schema and data) using the command
mysql --host=127.0.0.1 --user=root --port=xxxx --database=MYMEMDB_NAME < MYDUMPFILEPATH/MYDUMPFILE.SQL
and I received the error:
ERROR 1712 (HY000) at line xxxxx: Leaf Error (127.0.0.1:3307): Memory used by MemSQL (1088.62 Mb) has reached the ‘maximum_memory’ setting (1782 Mb) on this node. Possible causes include (1) available query execution memory has been used up for table memory (in use table memory: 78.62 Mb) and (2) the query is large and complex and requires more query execution memory than is available (in use query execution memory 0.00 Mb). See https://docs.memsql.com/troubleshooting/latest/memory-errors for additional information.