https://arangodb.com/2014/11/setting-test-data/ The database for graph and beyond Tue, 25 Jun 2024 09:27:34 +0000 hourly 1 https://wordpress.org/?v=6.7.1 https://arangodb.com/2014/11/setting-test-data/#comment-877 Mon, 30 Sep 2019 07:50:26 +0000 http://www.arangodb.com/?p=5104#comment-877 Hi,
I haven’t written a script to import data from MySQL into ArangoDB.
However, if you can export data from MySQL into JSONL (line-based) or CSV (comma-separated values) files, you can use the tool arangoimport to import the data into ArangoDB. arangoimport comes bundled with ArangoDB.
You will need to do this per collection, but that should be easily scriptable. Additionally, indexes will need to be created manually on the collections/attributes for which this is sensible.
All that being said, it may make sense to do additional transformations on the MySQL data before importing it back into ArangoDB. For example, in MySQL your primary key can be of any data type, but in ArangoDB the primary keys need to be string values. Other transformations may make sense too, but that clearly depends on the data model in use.

]]> https://arangodb.com/2014/11/setting-test-data/#comment-876 Fri, 27 Sep 2019 06:10:18 +0000 http://www.arangodb.com/?p=5104#comment-876 Hello Jan,
Are you writing a pesonal script to read data from a MySQL data source, and then import it into ArangoDB? I wonder if there’s a plug-in(API) of ArangoDB to import data from MySQL database to ArangoDB.

]]>