On Aug 19, 10:22 pm, Fred <[email protected]> wrote:
> I want to move a web2py database from one MySQL server to another. I
> dumped the database on the old server, loaded it into the new server,
> and created the database user with the necessary privileges. Then I
> changed the connection string in db.py to refer to the new server. It
> connects OK but I then get this error:
> OperationalError: (1050, "Table 'auth_user' already exists")
> That table does exist since I copied it over. Why does web2py think
> that it needs to create it? How do I work around this?
1 potential way to work around it would be to Export DB via:
db.export_to_csv_file(open('db.csv','wb'))
db.import_from_csv_file(open('db.csv','rb'))
db.commit()
Instead of using the MySQL dump.
I'm not sure why MySQL dump isn't working though...
F
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---
