Forum: Other

Post: How to transfer existing data from Mysql database to voltdb.

How to transfer existing data from Mysql database to voltdb.
snehal.k@saxonglibal.com
Jul 1, 2013
Hello Everyone,

Can any one tell me is it possible to transfer existing data from Mysql database to Voltdb.


Thank you.
francis
Jul 5, 2013
Yes it is possible! We've managed this with relative ease. There are a few ways to do this, but the easiest is through a CSV export. As long as you don't plan on changing your DB schema, you can export your MySQL data in CSV and then import it into VoltDB with the CSV importer. The alternative is that you do it through code, you do a SELECT on your MySQL data and then you loop through it and INSERT it into VoltDB.
snehal.k@saxonglibal.com
Jul 8, 2013
Hi francis ,

Thanks For Reply. Can you give some information(links) about CSV importer and also can you give sample code to do it through code.

Thank you.
ajgent
Jul 8, 2013
Hi,

The csvloader utility is documented in the Using VoltDB manual here: http://voltdb.com/docs/UsingVoltDB/clicsvloader.php

There are several examples on the reference page.

--Andrew
snehal.k@saxonglibal.com
Jul 8, 2013
Thank you ajgent .