I've tried also like that.
http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Copy-data-from-one-db-into-another

(env) [user@server web2py]$ python scripts/cpdb.py -f 
applications/myapp/databases -y 
postgres://user:pass@localhost:5432/mypostgdb -Y 
mysql://user:pass@localhost:3306/mymariadb -d ../gluon
gluon path not found
EXCEPTION: could not set DAL
No module named dal
EXCEPTION: could not make a copy of the database
global name 'DAL' is not defined

Of course the web2py directory have the gluon folder and inside there's the 
dal.py file:
Il giorno mercoledì 25 novembre 2020 alle 18:53:45 UTC+1 Gaël Princivalle 
ha scritto:

> Hello.
>
> After the migration from Webfaction to Opalstack I'm still having some 
> troubles with PostgreSQL.
> In a first time I was unable to run he scheduler workers, but now 
> installing the Psycog2 library like that this problem is resolved.
> pip2 install uwsgi psycopg2-binary http://effbot.org/downloads/
> Imaging-1.1.7.tar.gz 
>
> My scheduler tasks import in tables some csv files.
> Depending of the functions I have:
> No errors, but the tables still empty.
> This ticket: <class '_csv.Error'> line contains NULL byte
>
> That's quite difficult to understand where's the problem.
>
> I was thinking to clone the PostgreSQL db to a MariaDB one.
>
> How can I do that?
>
> 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/f3a3544f-be5d-4cc2-8e2c-78bf35881be6n%40googlegroups.com.

Reply via email to