CODEWITHSUNDEEP
singlestore
Maxim
Maxim

Reputation: 9981

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

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?

Upvotes: 2

Views: 257

Answers (2)

eklhad
eklhad

Reputation: 270

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.

Upvotes: 1

Carlos Bueno
Carlos Bueno

Reputation: 176

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/

Upvotes: 2

Related Questions