# Migration of MySQL data to Aerospike **URL:** \ **Category:** Configuration\ **Created:** [July 17, 2015, 7:41am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504 "2015-07-17T07:41:54Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Vinay\_Hurakadli](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/vinay_hurakadli/32/1373_2.png) [@Vinay\_Hurakadli](https://discuss.aerospike.com/u/Vinay_Hurakadli)\ **Post date:** [July 17, 2015, 7:41am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/1 "2015-07-17T07:41:54Z")
Hi All , I am newbie to aerospike , I need to load data which is currently stored in mysql with approximate count 10 Millions to aerospike by creating Json objects . Can please you explain us steps needs to be followed. ---
**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\ **Post date:** [July 17, 2015, 1:45pm UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/2 "2015-07-17T13:45:36Z")
Hi Vinay. You can do that easily without the JSON object step. I would suggest that you first dump your data out in CSV format using [mysqldump](http://dev.mysql.com/doc/refman/5.6/en/using-mysqldump.html). Then you can use the [aerospike-loader](https://github.com/aerospike/aerospike-loader) to insert that data into aerospike. It will be faster if you split the databases and tables into separate csv files, because then you can load them in parallel. ---
**Author:** ![Vinay\_Hurakadli](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/vinay_hurakadli/32/1373_2.png) [@Vinay\_Hurakadli](https://discuss.aerospike.com/u/Vinay_Hurakadli)\ **Post date:** [July 18, 2015, 5:12am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/3 "2015-07-18T05:12:08Z")
Thank you very much robot. I also needed information on this There is an ESB tool which does processing of input sources and will store data into mysql currently and it also generate json for same processing output. The generated json I want to read from web service and store into aerospike . Is this possible ? ---
**Author:** ![Vinay\_Hurakadli](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/vinay_hurakadli/32/1373_2.png) [@Vinay\_Hurakadli](https://discuss.aerospike.com/u/Vinay_Hurakadli)\ **Post date:** [November 7, 2015, 8:02am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/4 "2015-11-07T08:02:48Z")
I have installed all the tools , But facing issues while running commands. ![](https://us1.discourse-cdn.com/flex019/uploads/aerospike/original/1X/9f40bc507abddbe1c6cd2ea07e0ec7a51f63512e.png) Can you please help to resolve this. **Also can you explain how to set default-ttl as never expire.** **Also what is difference between default-ttl and max-ttl and how to reset max-ttl** **Also can you help in aql tool how to query for particular value or selecting values with limit and deleting values from set in aql.** ---
**Author:** ![zac](https://avatars.discourse-cdn.com/v4/letter/z/87869e/32.png) [@zac](https://discuss.aerospike.com/u/zac)\ **Post date:** [March 2, 2020, 8:24am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/5 "2020-03-02T08:24:57Z")
Might interest you : AS\_Mysql - Query AeroSpike from your favorite MySQL Client > **[GitHub - ZacSadan/AS\_Mysql: Query AeroSpike from MySQL Client](https://github.com/ZacSadan/AS_Mysql)** > > Query AeroSpike from MySQL Client. Contribute to ZacSadan/AS\_Mysql development by creating an account on GitHub. ---
**Author:** ![Vinay\_Hurakadli](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/vinay_hurakadli/32/1373_2.png) [@Vinay\_Hurakadli](https://discuss.aerospike.com/u/Vinay_Hurakadli)\ **Post date:** [March 2, 2020, 9:17am UTC](https://discuss.aerospike.com/t/migration-of-mysql-data-to-aerospike/1504/6 "2020-03-02T09:17:50Z")
thanks for information, It will be really helpful