Unable to take schema backup

[former_member230859]

Dear Experts,

We are using SAP Business One for HANA 9.0 Pl- 13.  We are unable to take individual company schema backup by using Export Command :

we have used command: export "SBODEMOIN"."*" as binary into 'usr/sap/test/' with replace threads 10;

at command line. The output of the command are as follows :

-bash: export: SBODEMOIN.* :  not a valid indentifier 

-bash: export: 'usr/sap/test' :  not a valid indentifier 

-bash: export: '10' :  not a valid indentifier 

Could you guide to identify the error please.

With regards,

Sourish

[Former Member]

Hello Sourish,

Manu has pointed you to the correct note to use.

1785797 - SAP HANA Database Data Export

The note does have a nice working example on how to do this in the attached .pdf.

Stefan has also pointed out that you are not connect via hdbsql or studio.

From your post it's clear that you are in as the operating system user running the export command under the bash shell.

at command line. The output of the command are as follows :

-bash: export: SBODEMOIN.* :  not a valid indentifier 

-bash: export: 'usr/sap/test' :  not a valid indentifier 

-bash: export: '10' :  not a valid indentifier 

"export" is also a UNIX command to set environment variables which is exactly what you're output above is showing.

Please follow the suggestions of either Manu and Stefan and you'll be fine.

Kindest Regards,

Amerjit

[Former Member]

Hi Sourish,

looks like your are not connected  via hdbsql?

Somethin like that should connect you to the database at first:

hdbsql -n localhost:30015 -u system -p password

Then you can try to export with your command.

Regards,

Stefan

[manumohandas82]

Hi Sourish ,

Please check the following Note

1785797 - SAP HANA Database Data Export

What user you are using to take the backup

2094381 - Only SYSTEM user can export company schemas on the SAP HANA database

Thanks ,

Manu

[former_member230859]

Hi Manu,

I am using SYSTEM User ....!!

Regards,

Sourish

[manumohandas82]

Hi Sourish ,

Did you try without the initial double cotes around the schema

export SBODEMOIN."* "as binary into 'usr/sap/test/' with replace threads 10;

Thanks ,

Manu