Залить все таблицы из tar.gz в mysql

Если каждая таблица задамплена отдельно можно отдной командой залить все

find . '*.sql.gz' | while read line; do gunzip < $line | mysql -u root -p 7min ; done

mytop через brew в os x install_driver(mysql) failed: Can't load '/usr/local/Cellar/mytop/1.6/libexec/lib/perl5/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/usr/local/Cellar/mytop/1.6/libexec/lib/perl5/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle, 1): Library not loaded: libmysqlclient.18.dylib

Если получаем ошибку при старте или копиляции нужно сделать симлмнк

Ошибка:


mytop
install_driver(mysql) failed: Can't load '/usr/local/Cellar/mytop/1.6/libexec/lib/perl5/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/usr/local/Cellar/mytop/1.6/libexec/lib/perl5/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle, 1): Library not loaded: libmysqlclient.18.dylib
Referenced from: /usr/local/Cellar/mytop/1.6/libexec/lib/perl5/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle
Reason: image not found at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.

at (eval 13) line 3.
Compilation failed in require at (eval 13) line 3.

Perhaps a required shared library or dll isn't installed where expected

at /usr/local/Cellar/mytop/1.6/libexec/bin/mytop line 235.

Создаем симлинк:

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

Mysql подсказки

Развернуть из gz сразу в  MySQL:

time gunzip < db.sql.gz |mysql -uroot -pPASS dbName