Import and Backup
On this page
How can I backup a SingleStoreDB database?
SingleStoreDB supports consistent, online, cluster-wide
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:
Use replication. Run
REPLICATE DATABASE dest_db FROM user@host:port/src_db, and after it fully synchronizes run
STOP REPLICATING dest_db. See Replicating Data Across Clusters .
BACKUP the database and RESTORE it on the same (or a different) cluster under a different name.
Where are the important data files (recovery log, binary logs, snapshots, data files etc)?
SHOW STATUS EXTENDED LIKE '%_directory' to get the full paths.
Last modified: January 10, 2023
Was this article helpful?