Mysql dump is not full
I have installed fresh ubuntu 16.04 with apache2.4 and php7.0 on it and then installed mariadb. Here is version:
mysql Ver 15.1 Distrib 10.0.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2.
After this fresh installation I noticed that I can't create normal mysql dump of some bases from any sources including phpmyadmin export, MysqlWorkbench and mysqldump command in shell. The file that is created is very small and most of tables does not contain INSERT query although there are data in tables.
As the result I got 600kb large dump file of 300mb database. I have tried to change max_allowed_packet is set to 2gb so it cannot be the case. As for --no-data argument then it is set to false and event if it would not be - it's very strange that only some tables contain INSERT with data and other are not. User privileges are also fully set for database i'm trying to dump. I'm trying to fix this for almost 3 days with no result and i would really appreciate some help. Thanks.