Importing data from MySQL databases

So far, we have learned how to work with graph or network data present in the form of comma-separated value (csv) files, GEXF files, GML files, and so on. These are all ways of explicitly gathering data into files that are directly ingestible by Gephi. One really cool feature of Gephi is its ability to ingest data directly from sources such as MySQL databases. In this recipe, we will learn how to get network/graph data from the MySQL database and consume it directly in Gephi for analysis.

Getting ready

To perform this recipe, ensure that you have a MySQL database set up on your system and running. The installation of MySQL databases is beyond the scope of this book but there is enough documentation on the Internet to help you with that. Apart from that, ensure that you have a database created for your use.

How to do it…

To learn how to directly consume network data from MySQL into Gephi, follow these steps:

1. Start Gephi and navigate to File in the menu bar.

2. Click...