dimanche 28 décembre 2014

Why MySQL imports only one record for each table?


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