i had the same path.
Images you should , i think, just download from webfaction and upload to
opalstack to uploads folder.
I used dbeaver to export from webfaction . and then psql to insert in
opalstack.
I had the same problem but i used migrate=False. Check docs.
Not much but hope it helps.
Ramos
Em seg., 26 de out. de 2020 às 19:15, Gaël Princivalle <
gaelprinciva...@gmail.com> escreveu:
> Hi.
>
> I'm still trying to migrate my Web2py applications from Webfaction to
> Opalstack.
>
> Well here what I do:
> 1 I export the DB form Webfaction in the dump.sql file
> What are the best options?
> For one website only the Data's in the Copy mode has worked well.
> For another one I've loose some records.
> Any suggestion?
>
> 2 I create a new PostgreSQL DB in Opalstack.
>
> 3 I modify my DB string connection in Web2py like that:
> db = DAL('postgres://mydbuser:mydbpassword@localhost:5432/mydb',
> check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
> migrate=True, fake_migrate_all=False)
> The idea is to create the tables before importing the data.
> So here there is the problem to understand if setting migrate and
> fake:migrate_all to True or False. Any suggestion?
>
> 4 I import the data in the new DB:
> psql -U mydbuser mydb < dump.sql
>
> Depending of the attempts I have these errors:
> relation "table..." does not exist
> Some tables are not imported (empty)
> Web2py don't find the images stored in records
>
> Any idea is interesting, thanks.
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/5dac3729-f70c-405b-81c8-a0c7fa0112d7n%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/5dac3729-f70c-405b-81c8-a0c7fa0112d7n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CAEM0BxMNMABMyTynjW%3D2gB75Ei50RcN3Rn%2BoXoPxuUYjTvQdRw%40mail.gmail.com.
