Cockroach restore not all insert is processed to the tables

(martonowibowo) #1

Hi Guys
I some problem when try to restore the sql from cockroachdb dump.
I tried to use “cockroach sql --insecure --database=database_name < database.sql”

the size of sql file is 5GB, but only one tables is finished, the other table is not.

Thank you

(Ron Arévalo) #2

Hey @martonowibowo,

Can you try using IMPORT, you can read more about it here. If it fails using import, can you provide a debug zip.

Thanks,

Ron