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.
$ fgrep LIMIT dump.sql
returns no rows.$ head -50 dump.sql
: gist.github.com/TrogWarZ/34bb292c38e2916350cb