# CrateDB backup table From one table to another table
**URL:** https://community.cratedb.com/t/cratedb-backup-table-from-one-table-to-another-table/1690
**Category:** CrateDB
**Created:** [January 8, 2024, 1:35pm UTC](https://community.cratedb.com/t/cratedb-backup-table-from-one-table-to-another-table/1690 "2024-01-08T13:35:18Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Vinayak\_Katkar](https://community.cratedb.com/u/Vinayak_Katkar)
#### Post date: [January 8, 2024, 1:35pm UTC](https://community.cratedb.com/t/cratedb-backup-table-from-one-table-to-another-table/1690/1 "2024-01-08T13:35:18Z")
Hi Team,
Hope everyone is doing great.
I want to some help regrading restore Cratedb. I want to restore one table into another table.
We have table which is around 200 GB. and want to restore or make copy that table but table structure is little different. while we inserting into copy table from main table below error occurs.
CircuitBreakingException[[parent] Data too large, data for [collect: 0] would be [3064355594/2.8gb], which is larger than the limit of [3060164198/2.8gb], usages [request=0/0b, in\_flight\_requests=0/0b, query=1272381900/1.1gb, jobs\_log=14022688/13.3mb, operations\_log=4558672/4.3mb, accounting=121276142/115.6mb]]
Can we restore One table into another ?
---
### Author:  [@hernanc](https://community.cratedb.com/u/hernanc)
#### Post date: [January 8, 2024, 5:10pm UTC](https://community.cratedb.com/t/cratedb-backup-table-from-one-table-to-another-table/1690/2 "2024-01-08T17:10:14Z")
Hi,
One option for this could be to use [insert-from-sql](https://github.com/mfussenegger/cr8#insert-from-sql)