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.

  • #2
    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.

    Comment


    • #3
      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.

      Comment


      • #4
        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

        Comment


        • #5
          Thank you ajgent .

          Comment

          Working...
          X