I am trying to convert my MYSQL DB to SQLite on my RaspberryPi with the wee_database --transfer command. The dry run was just fine, but when running in real the process fails after some time with a Out of Memory exception. >From 572643 records only 10034 were transferred. I guess the memory of my Raspi is a bit weak. Do I have another possibility?
pi@weatherpi:~ $ 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_mysql' Transfer 572643 records from source database 'weewx' to destination database 'weewx.sdb'. Dry run, nothing done. pi@weatherpi:~ $ 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_mysql' Transfer 572644 records from source database 'weewx' to destination database 'weewx.sdb' (y/n)? y transferring, this may take a while.... Out of memory (Needed 881712 bytes) complete 10034 records transferred from source database 'weewx' to destination database 'weewx.sdb'. -- 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/7803ed66-0c71-4d36-87a1-552833595851n%40googlegroups.com.
