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.
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.