Hi Dave, try it again without the quotes around the -y and -Y option values (an error in the book)
I.e.: *sudo python scripts/cpdb.py -f applications/Wikispots/databases -y sqlite://storage.sqlite -Y mysql://userxx:password@localhost/web2py* I hope it helps ! :) If not, let me know and I can debug from here. regards, Mart On Friday, July 19, 2013 1:50:45 AM UTC-7, Dave Carlson wrote: > > Hi Mart, > > this is the entirety of what I'm inputting and getting back in my shell on > the command line. Minus the actual username and password for my setup of > course. > > *[ dave@andromeda(0.18,) 4:45:37am ] /home/www-data/web2py > $ sudo python scripts/cpdb.py -f applications/Wikispots/databases -y > 'sqlite://storage.sqlite' -Y 'mysql://userxx:password@localhost/web2py' > creating tables... > EXCEPTION: could not make a copy of the database > 'NoneType' object is not iterable > [ dave@andromeda(0.27,) 4:45:49am ] /home/www-data/web2py > $ > * > Thanks > David* > * > > On Friday, July 19, 2013 3:30:33 AM UTC-4, mart wrote: >> >> can you provide the exact cmd line that you used as well as the full >> output displayed in your shell ? >> >> Thanks, >> Mart >> >> On Wednesday, July 17, 2013 2:06:39 AM UTC-7, Dave Carlson wrote: >>> >>> Using the provided script cpdb.py and following the outlined procedure >>> in the documentation ( >>> http://web2py.com/books/default/chapter/29/06#Copy-data-from-one-db-into-another >>> ) >>> >>> I get the following error >>> >>> * creating tables...* >>> *EXCEPTION: could not make a copy of the database* >>> *'NoneType' object is not iterable* >>> >>> in this particular case, I've been using sqlite to build up a wiki and >>> want to migrate the data to MariaDB, which I have installed, it is working >>> and it is functioning correctly. Opening, connecting and I have used >>> another app to interact with the database, before I attempted this copying >>> process. >>> >>> Any suggestions? >>> >>> Thanks >>> Dave >>> >> -- --- 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]. For more options, visit https://groups.google.com/groups/opt_out.
