Import and Backup

How can I backup a SingleStore Helios database?

SingleStore Helios supports consistent, online, workspace-wide BACKUP and RESTORE operations that do not require blocking write operations on the database like mysqldump does.

See Back Up and Restore Data for more information.

How can I import data from MySQL, Postgres, MS-SQL etc?

Refer to Load Data for more information.

How can I easily copy a table?

You can use CREATE TABLE dest AS SELECT * FROM source. See CREATE TABLE.

Or, create a new empty table using the schema of the original table from SHOW CREATE TABLE source and copy data from source table into the new table using INSERT INTO dest SELECT * FROM source.

How can I easily copy a database?

Available options include:

• BACKUP the database and RESTORE it on the same (or a different) workspace under a different name.

Where are the important data files (recovery log, binary logs, snapshots, data files etc)?

Run SHOW STATUS EXTENDED LIKE '%_directory' to get the full paths.