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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/5dac3729-f70c-405b-81c8-a0c7fa0112d7n%40googlegroups.com.
