the first message is expected because of this import:
try:
from gluon import DAL
except ImportError as err:
print('gluon path not found')
It wants to assume that that gluon is already loaded as part of the web2py
environment (or as part of some other environment, like Aptana for example)
and that you already have /gluon in your path (maybe even hard coded). If
the gluon path is not set, well, you will get that "gluon path not found"
message and the -d option will be expected. Because the -d option is
expecting a *relative* path, your cmd line args will look different
depending on the environment in which you are running the script.
Hum... I guess being relative is relative ;)
So, as an example, if you were to run this cmd from a simple bash shell
(outside of any dev environment, or outside of a web2py context), you would
simply cd and drill down into .../blabla/.../web2py/scripts/. In which
case, your -d option would look like this:
-d ../gluon.
I just did this, and it all worked fine:
macMart:Documents mart$ cd Aptana\ Studio\ Workspace/_p4/src/web2py/scripts/
macMart:scripts mart$ python cpdb.py -f ../../db_storage -d ../gluon -y
sqlite://storage.sqlite -Y sqlite://storage2.sqlite -F ../../db_storage2
gluon path not found <== THIS IS AN EXPECTED MESSAGE
creating tables...
exporting data...
importing data...
done!
Hope it helps and that it makes sense!
Mart :)
On Thursday, May 17, 2012 2:00:08 AM UTC-7, backseat wrote:
>
> 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?
>
