Hi all, I've some trouble trying to migrate an app db from mysql to postgres using the cpdb.py script
My appname is "sviluppo" and it has all the tables defined inside "db_wizard.py". Both the connection url (source and dest) are tested working I used this command: ./web2py.py -S sviluppo -M -R scripts/cpdb.py -A -f applications/sviluppo/databases \ -y 'mysql://sviluppo:password@localhost/sviluppo' -Y 'postgres://web2py:password@192.168.0.23/sviluppo' But I get this error: web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2013 Version 2.4.5-stable+timestamp.2013.03.18.22.46.22 Database drivers available: SQLite(sqlite3), MySQL(pymysql), MySQL(MySQLdb), PostgreSQL(pg8000), MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), IMAP(imaplib) creating tables... EXCEPTION: could not make a copy of the database 'NoneType' object is not iterable The folder application/sviluppo/databases exists and it is not empy I also tryed to save to sqlite ( -Y 'sqlite://storage.sqlite') with same failure. Any suggestions? Thanks, Rocco -- --- 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. For more options, visit https://groups.google.com/groups/opt_out.
