yes you can migrate an entire database from the shell with one
command:
1) have a model that connects to the sqliite db
2) python web2py -S yourapp -M
3) in the shell type
db.export_to_csv_file(open('somefile.csv','wb'))
4) quit, edit the model to connect to the other db instead
5) python web2py -S yourapp -M
6) in the shell type
db.import_from_csv_file(open('somefile.csv','rb'))
7) done. Id's we'll be different but references will be preserved and
not be broken.
Massimo
On Jun 21, 8:58 am, carlo <[email protected]> wrote:
> maybe I am not fully up to date with the latest web2py releases so
> chech this out:
>
> db structure: if you have an existing mysql db with the same structure
> as the sqlite db, it is just a matter of changing the connect string
> in the model
>
> db data: I think web2py does not care for migrating data from one db
> to another (and it should not do), I think you have to do some
> scripting or use some external mysql utility to convert data.
>
> carlo
>
> On 21 Giu, 03:09, weheh <[email protected]> wrote:
>
> > Now 100% certain about causing reserved keyword conflict with mysql.
> > Thanks again for the reminder.
>
> > I successfully migrated the data to mysql from sqlite, but did it 1
> > table at a time. Is there a convenient way to move all the data from
> > all tables at once? I figured tar and detar just brings back the
> > sqlite db, so I didn't try it.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
