# Transfer data to a new installation

**URL:** https://discuss.tryton.org/t/transfer-data-to-a-new-installation/6785
**Category:** System Administrator
**Created:** [December 15, 2023, 11:12am UTC](https://discuss.tryton.org/t/transfer-data-to-a-new-installation/6785 "2023-12-15T11:12:23Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![efe](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/efe/32/2555_2.png) [@efe](https://discuss.tryton.org/u/efe)
#### Post date: [December 15, 2023, 11:12am UTC](https://discuss.tryton.org/t/transfer-data-to-a-new-installation/6785/1 "2023-12-15T11:12:25Z")

</div>

I tried to copy data from one installation to another one (both trytond version 6) by creating an sql dump from the origin and importing it using the command  
sudo -u postgres psql -h localhost -d -U -f \*.sql  
The terminal output confirms that the dump is imported but when trying to update the database with  
rytond-admin -c trytond.conf -d -m -vv  
I get the error ‘could not load database’  
Can anyone help me with this? Is there another way to copy data from one installation to another?

---

<div class="post-metadata">

### Author: ![edbo](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/e/f14d63/32.png) [@edbo](https://discuss.tryton.org/u/edbo)
#### Post date: [December 15, 2023, 1:11pm UTC](https://discuss.tryton.org/t/transfer-data-to-a-new-installation/6785/2 "2023-12-15T13:11:30Z")

</div>

I’m always using the user who owns the database, and is used to connect to the database with Tryton. Make sure you only dump your particular database and not the others.

To create a new database:

```auto
testadmin@docsrv:~$ sudo -u postgres createdb -O <the-user> <the-db>

```

And import your SQL dump with

```auto
testadmin@docsrv:~$ psql -d <the-db> -U <the-user> -h localhost -f <sql-dump.sql>

```

> [@efe](#):
>
> I get the error ‘could not load database’

Probably because the user you are using to connect to the database doesn’t have access.

> [@efe](#):
>
> rytond-admin -c trytond.conf -d -m -vv

I’m missing the database name here

---

<div class="post-metadata">

### Author: ![efe](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/efe/32/2555_2.png) [@efe](https://discuss.tryton.org/u/efe)
#### Post date: [December 15, 2023, 2:03pm UTC](https://discuss.tryton.org/t/transfer-data-to-a-new-installation/6785/3 "2023-12-15T14:03:10Z")

</div>

Thanks edbo for another clear protocol. I followed it and could transfer the database.  
In my last line of above post I did indeed forget the database name but that was not the origin of the error since I entered the command correctly in the terminal.  
I keep working on the learning curve.