# Backup taking too long

**URL:** <https://forum.yugabyte.com/t/backup-taking-too-long/455>\
**Category:** General\
**Created:** [July 29, 2019, 12:49pm UTC](https://forum.yugabyte.com/t/backup-taking-too-long/455 "2019-07-29T12:49:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raghunath\_Murmu](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/raghunath_murmu/32/136_2.png) [@Raghunath\_Murmu](https://forum.yugabyte.com/u/Raghunath_Murmu)\
**Post date:** [July 29, 2019, 12:49pm UTC](https://forum.yugabyte.com/t/backup-taking-too-long/455/1 "2019-07-29T12:49:09Z")

</div>

Hi ,  
I am using **yugabyte-1.3.0.0** , and tried the command cqlsh -e “COPY test.mytable TO ‘mytable.csv’ WITH HEADER = true AND PAGESIZE =10000 AND PAGETIMEOUT = 100;” to take backup. It takes around 7 mins for 2 million record. This is a very long time , is there any other methods to take backup in less time. I think this command will take backup of only cassandra keyspace , how to take backup of data inserted using redis api and posgresql api.  
I am also looking for “ **INCREMENTAL BACKUP** ” , unable to find any supporting docs.

---

<div class="post-metadata">

**Author:** ![neha](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/neha/32/231_2.png) [@neha](https://forum.yugabyte.com/u/neha)\
**Post date:** [July 29, 2019, 6:18pm UTC](https://forum.yugabyte.com/t/backup-taking-too-long/455/2 "2019-07-29T18:18:49Z")

</div>

Hi @Raghunath_Murmu,

You can try using cassandra-unloader for exporting larger tables: [Bulk export YSQL | YugabyteDB Docs](https://docs.yugabyte.com/latest/manage/data-migration/bulk-export/#ycql)

For SQL, you can use `COPY TO` command for now. We are currently also working on enabling `pg_dump` for use with YugaByte and hope to have it ready in the next 2-3 weeks.

Note that these are export-based backups (where the output is readable). For better performance, you can use distributed backups. @bogdan or @ramkumar should be able to provide more information on that.

Regarding incremental backups, that’s on our roadmap but we don’t support it yet.
