Announcement

Collapse
No announcement yet.

How to transfer existing data from Mysql database to voltdb.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to transfer existing data from Mysql database to voltdb.

    Hello Everyone,

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


    Thank you.

  • snehal.k@saxonglibal.com
    replied
    Thank you ajgent .

    Leave a comment:


  • ajgent
    replied
    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

    Leave a comment:


  • snehal.k@saxonglibal.com
    replied
    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.

    Leave a comment:


  • francis
    replied
    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.

    Leave a comment:

Working...
X