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?
Thanks.
Best Answer
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.