MemSQL Backup with Split Partitions

backup-with-split-partitions.sql

-- create a database with 2 master partitions
create database thedb partitions 2;

-- create sample data
use thedb;
create table data (msg varchar(200));
insert into data (msg) values ('the data');

-- notice how we're not using the database efficiently
show partitions;

-- run backup
backup thedb with split partitions to './memsqlbackup';

-- check it
restore database thedb2 from './memsqlbackup/thedb.backup';
select * from data;
drop database thedb2;

-- restore backup into place
drop database thedb;
restore database thedb from './memsqlbackup';