Running mysqldump without piping to file such as:
mysqldump -u root -pPASS db
is really slow on windows. If I do
mysqldump -u root -pPASS db > db.sql
it runs fast.
This might not seem like a big deal as I can always pipe to a file. BUT I am using mysqldump from a script and I just want the raw output so I don’t have to load the file in memory or save a temp file.
Linux and Mac there is NOT a difference if I pipe it to a file or just let it output.
Is there a way to fix this? This is for mysql 5.6.x
The full command I run is:
mysqldump --user=$db_username --password=$db_password --tz-utc=false --single-transaction --routines --triggers db
but I have tried a lot of combos and nothing makes it fast.