Base de données import

English Forum Technical
1

Hello,
I have a .sqlfc file to reload an axelor program database. I don’t know what to do with it? Can anyone help me ?

2

.SQL or sqlfc ?

3

Hi Siddique,

it’s actually a .sqlfc and that’s what confuses me, and apparently it’s a binary file.

I have a loadDatabase file in the project where it is marked this:

# Database Dump Storing Path

WORKING_PATH="/srv/hdd/data/dump/nameproject"

Database Dump Name

DUMP=« nameproject.sqlfc »

Location of sql migration scripts

SCRIPTS_PATH=« src/main/resources/scripts »

4

I found it’s a custom format dump…

5

oh, no one can judge, issue solved,?

6

yes thanks Siddique.

7

Hello, sqlfc is a very usefull format to create backup.

You can restore a database using a sqlfc file with this instruction

pg_restore -x -O -d yourDataBaseName -v yourFile.sqlfc

8

we can do this without the extension

9

Thank you Pierre, the order was good.

10

Thanks siddique.

11

Ce sujet a été automatiquement fermé après 30 jours. Aucune réponse n’est permise dorénavant.