Поиск по тегам

Как импортировать большую базу данных MySQL

Вот описание
http://kedar.nitty-witty.com/blog/mydumpsplitter-extract-tables-from-mysql-dump-shell-script

GitHub

git clone https://github.com/kedarvj/mysqldumpsplitter .
chmod +x mysqldumpsplitter.sh

./mysqldumpsplitter.sh --source domain_statistic.sql --extract ALLTABLES --decompression none  --compression none

и видим в папке out базу разделенную по таблицам. Она очень хорошо импортируется по частям



Загружаем медленно в базу, можно и удаленную.
mysql -h host -u root -p domain_statistic < a_count_statistic.sql
mysql -h host -u root -p domain_statistic < all_stat.sql
mysql -h host -u root -p domain_statistic < as_count_statistic.sql
mysql -h host -u root -p domain_statistic < as_list.sql
mysql -h host -u root -p domain_statistic < cname_count_statistic.sql
mysql -h host -u root -p domain_statistic < domain_count_statistic.sql
mysql -h host -u root -p domain_statistic < domain_history.sql
mysql -h host -u root -p domain_statistic < domain.sql
mysql -h host -u root -p domain_statistic < mx_count_statistic.sql
mysql -h host -u root -p domain_statistic < ns_count_statistic.sql
mysql -h host -u root -p domain_statistic < providers_like_statistic.sql
mysql -h host -u root -p domain_statistic < registrant_count_statistic.sql
mysql -h host -u root -p domain_statistic < regru_providers.sql
mysql -h host -u root -p domain_statistic < regru_stat_data.sql
, , ,