The easiest way to do this is to export the data as CSV
and use mysqlimport
from the command line to import it. You may have to convert any data that is not purely numeric or text (e.g. Quantity
, DateObject
, ...) before using Export
.
You could also convert your data to a format suitable for SQLImport
.