The Ultimate Guide to High Availability with MariaDB

Mysql dump is not full

Hello, 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.

Answer Answered by Ian Gilfillan in this comment.

Make sure max_allowed_packet is changed on both the client and the server. See max_allowed packet for the server option and the same option for mysqldump.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.