Transfer from MySQL to sqlite

94 views
Skip to first unread message

George

unread,
Apr 15, 2023, 10:20:22 AM4/15/23
to weewx-user
The transfer breaks off after about 40 minutes with 'killed'.
The dry-run outputs this:

Using database binding 'wx_binding', which is bound to database 'archive_mysql'
Transfer 523089 records from source database 'weewx' to destination database 'weewx.sdb'. Dry run, nothing done.

Is it maybe too much data?

vince

unread,
Apr 15, 2023, 12:41:27 PM4/15/23
to weewx-user
Impossible to say without seeing exactly your transcript verbatim.

George

unread,
Apr 16, 2023, 5:39:38 AM4/16/23
to weewx-user
I followed the instructions (option 2 wee_database) from https://github.com/weewx/weewx/wiki/Transfer%20from%20MySQL%20to%20sqlite.
I have now decided to use mysql as the database on the new system as well. With mysqldump I was able to transfer all values ​​to the new system.

Tom Keffer

unread,
Apr 16, 2023, 7:20:35 AM4/16/23
to weewx...@googlegroups.com
The instructions give two approaches: use mysqldump, or use wee_database. I think what Vince is asking is which did you do? 



--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/aa5b3470-352f-43d3-9307-71006f278a86n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages