Code shows some info:

$ cat /etc/*-release | grep VERSION
6:VERSION="12.04.5 LTS, Precise Pangolin"

$ mysql --version
mysql  Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.2

$ mysqldump -uUSER -pPASS DBNAME > dump.sql

$ ll dump.sql
-rw-r--r--  1 root    397M Dec 29 01:13 dump.sql

$ mysql -uUSER -pPASS DBNAME < dump.sql

MySQL don't show any errors but after import i have only first rows in all tables. I've checked with head sql syntax and it seems to be correct.

I've tried also mysqldump -uUSER -pPASS DBNAME | gzip -9 > dump.sql.gz and got same situation.

Why this is happening? And how to fix?



1 Answer 1


I'm using Mac OS (10.10.1) and SequelPro (1.0.2).

This is bug in SequelPro, i think: bug began to appear after upgrading OS to 10.10.1.

See issue #2048 on GitHub.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.