I’ve released a simple tool to take a MySQL database and migrate its data to a Mongo database. The tool is simple, it doesn’t bring over indices, follow relationships to create references—it just moves tables to collections.
I started with the “quick and dirty mysql wrapper“, Â cleaned it up a bit for my needs and just … Read full article »
Home» Posts tagged "mysql"
Exporting every table in a MySQL database to separate CSV files
While phpMyAdmin, mysqldump and SELECT INTO OUTFILE are great tools on their own, sometimes you need a little automation to make life a little easier.
I needed the ability to export every table in a MySQL database to individual CSV files, I’ve thrown together a bash script that does just that. I am looking to use … Read full article »