Re: How to import data from MYSQL to Cassandra

2010-07-01 Thread Paul Prescod
As Paul said, you need to re-build your data in a Cassandra-friendly manner. Reading SQL files does not seem a very efficient way to do that though. Most databases can output in much simpler formats, like CSV. But then, why export at all? If the MySQL instance and the Cassandra instance are both ad

Re: How to import data from MYSQL to Cassandra

2010-07-01 Thread Paul Brown
On Jul 1, 2010, at 1:33 PM, Rana Aich wrote: > Can someone please please throw some light how can I import the Data from > mysql into Cassandra cluster. > - Is there any tool available? > OR > - Do I have to write my own Client using Thrift that will read the export > file (*.sql) and insert the

How to import data from MYSQL to Cassandra

2010-07-01 Thread Rana Aich
Hi, Can someone please please throw some light how can I import the Data from mysql into Cassandra cluster. - Is there any tool available? OR - Do I have to write my own Client using Thrift that will read the export file (*.sql) and insert the record in the database. Thanks raich