>
> $ sudo wee_database --transfer --dest-binding = dest_binding --dry-run
> Traceback (most recent call last):
> File "/usr/bin/wee_database", line 794, in <module>
> main()
> File "/usr/bin/wee_database", line 133, in main
> config_path, config_dict = weecfg.read_config(options.config_path,
> args)
> File "/usr/share/weewx/weecfg/__init__.py", line 173, in read_config
> locations=locations, file_name=file_name)
> File "/usr/share/weewx/weecfg/__init__.py", line 147, in find_file
> raise IOError("%s is not a file" % file_path)
> IOError: dest_binding is not a file
>
Is dest_binding defined in your configuration file?
$ sudo python -c "import weedb.mysql"
> Traceback (most recent call last):
> File "<string>", line 1, in <module>
> ImportError: No module named weedb.mysql
This is probably a PYTHONPATH problem.
-tk
On Tue, Mar 3, 2020 at 8:47 AM Eric Gammeter <[email protected]> wrote:
> My error: I was wrong on my situation- it is not fixed.
>
> I have attached debug.info file with all the particulars.
>
> I am attempting to convert my existing sqlite weewx db file to MySQL and
> then migrate it over to a new RaspberryPi 4 platform.
> /EG
>
>
>
>
>
> 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/160ebdf6-3c35-4c85-9902-85d0685b9034%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/160ebdf6-3c35-4c85-9902-85d0685b9034%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/CAPq0zEAUUDSZTBFQSLcRasFiWOSkyxwKpogCFO%3DJGmjcXtPAUQ%40mail.gmail.com.
