Yes: here it is from weewx.conf file:
[[dest_binding]]
database = archive_mysql
table_name = archive
manager = weewx.wxmanager.WXDaySummaryManager
schema = schemas.wview.schema
On Tuesday, February 25, 2020 at 9:11:40 AM UTC-5, Eric Gammeter wrote:
>
>
> Goal:
> Wanting to switch from sqlite to MySql database.
>
> I am consulting the github /weewx/wiki "Usingwee_database".
>
> The --dry-run doesn't show any error.
>
>
> pi@raspberrypi:~ $ wee_database --transfer --dest-binding=dest_binding
> --dry-run
> Using configuration file /etc/weewx/weewx.conf
> Using database binding 'wx_binding', which is bound to database
> 'archive_sqlite'
> Transfer 9177 records from source database 'weewx.sdb' to destination
> database 'weewx'.
> Dry run, nothing done.
> pi@raspberrypi:~ $ wee_database --transfer --dest-binding=dest_binding
> Using configuration file /etc/weewx/weewx.conf
> Using database binding 'wx_binding', which is bound to database
> 'archive_sqlite'
> Transfer 9177 records from source database 'weewx.sdb' to destination
> database 'weewx' (y/n)? y
> Error accessing destination database 'weewx'.
> Nothing done. Aborting.
> Traceback (most recent call last):
> File "/usr/bin/wee_database", line 794, in <module>
> main()
> File "/usr/bin/wee_database", line 159, in main
> transferDatabase(config_dict, db_binding, options)
> File "/usr/bin/wee_database", line 410, in transferDatabase
> schema=dest_manager_dict['schema']) as dest_manager:
> File "/usr/share/weewx/weewx/manager.py", line 128, in open_with_create
> connection = weedb.connect(database_dict)
> File "/usr/share/weewx/weedb/__init__.py", line 86, in connect
> __import__(db_dict['driver'])
> File "/usr/share/weewx/weedb/mysql.py", line 10, in <module>
> import MySQLdb
> ImportError: No module named MySQLdb
>
>
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/f990a6c7-8b77-446c-9f42-c57a49fd16ac%40googlegroups.com.
