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.
Aucun commentaire:
Enregistrer un commentaire