Feature 'Backup of a database containing a columnar table' is not supported by MemSQL

Question

MemSQL doesn't support backup of columnar tables:

memsql> backup database stat to '/data/memsql-backup';
ERROR 1706 (HY000): Feature 'Backup of a database containing a columnar table' is not supported by MemSQL.

How to organize online backup in this case? Through export to CSV?

Answer 1

At the moment, yes, exporting columnstore tables to a file is the recommended solution. The select into outfile command or the mysqldump do the job well.

http://docs.memsql.com/4.0/ref/SELECT/

Answer 2

mysqldumping the columnar table is your best bet for an online backup in this case. If in the future you would like to run the BACKUP command on the entire database, (for the time being) it is recommended that you move your columnar table to a different database in the cluster.