We are planning to use NAS server for archiving our data. Basically we are planning to archive more than 3 years old data from few big tables to NAS. If there are any requirement in future we should be able to restore this data from archival location . So we are planning to schedule this archival every month but the problem is singlestore support(‘sdb-admin create backup’ and ‘backup database’ commands) backups at database level only. Is there any option to run backup/archival to network or cloud storage at table levels .?
SELECT INTO OUTFILE or SELECT INTO FS may do what you need. There are options to compress the output too. See:
We don’t have the ability to backup individual tables.
You could also create an empty database, use INSERT…SELECT… to move data over into it for one large table (with any needed filters), then back up that database, and drop the database.
Thanks @hanson for the information. We are following second approach ie.,creating a new database and moving table data to this DB and running backup script on top of this.