Import and Backup
How can I backup a SingleStoreDB Cloud database?
SingleStoreDB Cloud 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:
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.
How do I load data into SingleStoreDB Cloud?
The easiest way to get data into SingleStoreDB Cloud is by uploading your dataset to Amazon S3 or Google Cloud Storage and using SingleStore Pipelines to ingest your data quickly. Get started now.
How are backups managed?
SingleStore performs daily backups on all data.
You may also manually back up your data. Refer to Back Up and Restore Data for more information.