Hi, Did you do both commands that were indicated.? sudo apt-get install mysql-client *sudo apt-get install python-mysqldb*
The second install is also needed. Jerry On Tuesday, February 25, 2020 at 12:30:31 PM UTC-7, Eric Gammeter wrote: > > > Hmm . > FYI: The mysql-client has been replaced with the mariadb-client-10.0. > Still not working. > > 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 9187 records from source database 'weewx.sdb' to destination > database 'weewx' (y/n)? y > Error accessing destination database 'weewx'. > Maybe it does not exist (MySQL) or is incorrectly defined in weewx.conf? > Nothing done. Aborting. > > > 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3793b0ca-a43c-43e9-bdbb-ab5603241ec0%40googlegroups.com.
