Home / server / Questions / 885547
Accepted
Alex
Asked: 2017-11-29 08:12:33 +0800 CST

Bandwidth limiting for import of a large SQL file

  • 772

I am trying to import a large MariaDB dump file in a running MariaDB instance (production) without any performance issues. In order to do so i am trying to use cpipe, for a throughput speed limit as below:

/usr/bin/mysql -uuser -ppass -h host DBname | /usr/bin/cpipe -vr -vw -vt -s 512 -b 1 < /path/to/dump.sql

It is worth mentioning that the above line is part of a simple bash script, where I specified login credentials + host.

I am receiving contents of dump.sql on screen (with the provided limitations) but nothing is actually imported in the MariaDB instance.

What am i doing wrong here?

mysql

1 Answers

  1. Best Answer

    You inverted the pipe...

    /usr/bin/cpipe -vr -vw -vt -s 512 -b 1 < /path/to/dump.sql | /usr/bin/mysql -uuser -ppass -h host DBname
    • 2