# Pmm mysql backup

**URL:** https://forums.percona.com/t/pmm-mysql-backup/30788
**Category:** Percona Monitoring and Management (PMM)
**Created:** [June 4, 2024, 2:10am UTC](https://forums.percona.com/t/pmm-mysql-backup/30788 "2024-06-04T02:10:25Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![pmmChobo](https://avatars.discourse-cdn.com/v4/letter/p/5f8ce5/32.png) [@pmmChobo](https://forums.percona.com/u/pmmChobo)
#### Post date: [June 4, 2024, 2:10am UTC](https://forums.percona.com/t/pmm-mysql-backup/30788/1 "2024-06-04T02:10:25Z")

</div>

## Description:

[Detailed description of the issue or question]

Mysql binary log increases when performing Mysql full backup using PMM.  
As far as I know, mysql binary log is created when mysql is restarted,  
When I checked with systemctl status mysql, mysql was not restarted.  
I wonder why mysql binary log is newly created every time I do a full backup with PMM

thank you

## Steps to Reproduce:

[Step-by-step instructions on how to reproduce the issue, including any specific settings or configurations]

## Version:

[Insert the version number of the software]

2.40.1

## Logs:

[If applicable, include any relevant log files or error messages]

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/f/3/f3b358d4a642c3e6b0c31b5554918d446515fca0.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/6/1/611787292aebfb41332471340c30bd5fc63271a3.png)

## Expected Result:

[What the user expected to see or happen before the issue occurred]

## Actual Result:

[What actually happened when the user encountered the issue]

## Additional Information:

[Include any additional information that could be helpful to diagnose the issue, such as browser or device information]

---

<div class="post-metadata">

### Author: ![Aibek\_Bukabayev](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aibek_bukabayev/32/16752_2.png) [@Aibek\_Bukabayev](https://forums.percona.com/u/Aibek_Bukabayev)
#### Post date: [June 4, 2024, 9:09am UTC](https://forums.percona.com/t/pmm-mysql-backup/30788/2 "2024-06-04T09:09:35Z")

</div>

Hi @ pmmChobo,  
Xtrabackup does not copy all binlogs, it copies only the last binlog file. To copy a smaller last binlog `FLUSH NO_WRITE_TO_BINLOG BINARY LOGS` is executed as part of the backup, this is why a new binlog is being created.

I hope I could answer your question,