[R] export from R to MySQL

Sean Davis sdavis2 at mail.nih.gov
Mon Dec 12 14:50:47 CET 2005

On 12/12/05 8:33 AM, "Meinhard Ploner" <meinhardploner at gmx.net> wrote:

> Hi R user!
> What is the fastest way to export a large matrix or vector to a MySQL
> database? The use of data.frame() and dbWriteTable() makes the process
> slow, so is there any <direct> alternative?

Probably dumping to a text file and then using mysqlimport will be fastest,
in terms of computation time, but you will have to create the table by hand
(using SQL CREATE TABLE), so it might take just as much user time.


More information about the R-help mailing list