wee_database transfer - out of memory

[StefMel]

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'.

[vince]

On Wednesday, July 14, 2021 at 1:08:02 PM UTC-7 StefMel wrote:

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?

If you have another computer that you can use, or a virtual machine with a lot of RAM allocated to it, that would work too.