Import and Backup
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
How can I backup a SingleStore database?
SingleStore supports consistent, online, cluster-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
.
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_
, and after it fully synchronizes rundb FROM user@host:port/src_ db 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.
Last modified: February 7, 2025