tried the script too, but having no luck
*static/scripts/python/mover.py*
def main():
URI = 'mysql://root:mysqlpassword@localhost/site'
other_db = DAL(URI)
print ("creating tables")
for table in db:
other_db.define_table(table._tablename, *[field for field in table]
)
print ('exporting data')
db.export_to_csv_file(open('tmp.csv', 'wb') )
print ('importing data')
other_db.import_from_csv_file(open('tmp.csv', 'rb') )
other_db.commit()
print ('done!')
$ python ~/python/web2py/web2py.py -S site -M -R ~/python/web2py/
applications/site/static/scripts/python/mover.py
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2018
Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
Database drivers available: psycopg2, couchdb, pymysql, imaplib, sqlite3,
pg8000, pyodbc, pymongo
result in database in mysql is no tables created (no data too), any hints?
thx and best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
