SingleStore DB

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.