You did both commands and the MySQL driver is still not available? What happens if you do
*python -c "import MySQLdb"* *python -c "import weedb.mysql"* If either of these fail, then the MySQL drivers were not installed. NB: there may now be separate drivers for the MariaDB database, but we don't support them. The assumption is that the MySQL drivers will still work. If that's not true, then we have a problem! -tk On Tue, Feb 25, 2020 at 12:14 PM Eric Gammeter <[email protected]> wrote: > Yes. Both commands were issued. > > > > 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/e02915bd-b730-4478-a7b8-02a3e18bf0fd%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/e02915bd-b730-4478-a7b8-02a3e18bf0fd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEAYaMgJWmbBBb5i%2BaAO%2BMSx9nuxjNncX%2BeYucGpHMmDdQ%40mail.gmail.com.
