I'm trying to copy a database from Sqlite to MySQL using the cpdb.py script. In the manual, it states:
cd web2py python scripts/cpdb.py \ -f applications/app/databases \ -y 'sqlite://storage.sqlite' \ -Y 'postgresql://username:password@hocalhost/mydb' However, if I do that I get "gluon path not found". The help file suggests that I can specify the path to dal.py with -d, but: python scripts/cpdb.py -d gluon/dal.py -f applications/pytrack2/databases -y 'sqlite://storage.sqlite' -Y 'mysql://pytrack2:pytrack2@localhost/pytrack2' gluon path not found EXCEPTION: could not set DAL No module named dal If I use '-d gluon', it's better but now fails with a MySQL error (which I think relates to foreign keys), although it still gives the 'gluon path not found' error: $ python scripts/cpdb.py -d gluon -f applications/pytrack2/databases -y 'sqlite://storage.sqlite' -Y 'mysql://pytrack2:pytrack2@localhost/pytrack2' gluon path not found creating tables... EXCEPTION: could not make a copy of the database (1005, u"Can't create table 'pytrack2.t_companies_archive' (errno: 150)") I'm going to continue by migrating by hand; if I should report this elsewhere or if you need more details, let me know. -- "You can have everything in life you want if you help enough other people get what they want" - Zig Ziglar. Who did you help today?
