mysqldump generating the same file with different size

Question

Good morning, you guys.

I’m having a bizarre problem using the mysqldump, I’ll try to explain as best I can.

I have 4 Databases, and daily a dump is made from each base, generating different files, but one of these generated files varies greatly in size, for example yesterday the file .sql of the main base was the size of 3.2G, and today, the .sql of the same base was generated with a size of 2G, and do not understand what may be happening.

This is the command used:

mysqldump --user=root --password=senha --databases databasetal --single-transaction > database.sql 2> database.log

(I changed some names and password for security reasons)

This command runs every day at 2:00 am, and there are never errors in the generated log, that’s all:

mysqldump: [Warning] Using a password on the command line interface can be insecure.

Who can give a light, I would be very grateful...

Answer 1

Bruno, do you store any kind of log in the bank? It may be that there is some table that is varying in size, you can do the following test, instead of storing it in one file only, you can separate it into several files that are relative to each table and then analyze which table is this difference.

I always use mysql Workbench to export in multiple files, I have not tried to do otherwise.