DEV Community

Cover image for Awesome cli that you didn't know #3 mysql tools
Andres 🐍 in 🇨🇦
Andres 🐍 in 🇨🇦

Posted on

Awesome cli that you didn't know #3 mysql tools

When I was working I have projects with a BIG database in MySQL. Big Means as really BIG!!! when you can do a mysqldump it takes hours! If you have some of these problems, these tools will be very helpful.

big database

Only for MYSQL

You have a mysqldump of Gb's of data, to load it you need to wait hours and hours. Imagine you need to update the new structure table in your local environment. To not wait hours and hours loading the new changes, only extract the table you need and load the table only. If you on that situation this tool it's for you:

Split your big database dump on tables https://github.com/kedarvj/mysqldumpsplitter

That will process the mysqldump.sql in small chunks of SQL for each table of your database. then you can take only the part you needed.

MySQL Dumper https://github.com/maxbube/mydumper

When you start FEELING of mysqldump it's not designed for BIG databases because it's very slow and does not show the progress of what happening behind.

This is a mysqldump of the year 3000!

Is a tool used for backing up MySQL database servers much faster than the mysqldump tool distributed with MySQL. It also has the capability to retrieve the binary logs from the remote server at the same time as the dump itself. The advantages of mydumper are:

Features:

  • Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
  • Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
  • Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc

I'm fell in love!

bye bye mysqldump welcome mysqldumper

Note: It comes with the myloader the inverse of the dumper :>

Top comments (0)