See more

mysqldump: unknown option '--max_allowed_packet 512M'

Updated April 06, 2018 19:50

Applicable to:

Plesk 12.5 for Linux
Plesk 11.x for Linux

Symptoms

An attempt to create database dump fails with the following error:
```
mysqldump: unknown option '--max_allowed_packet 512M'
```
The /etc/my.cnf has the following option:
```
[mysqldump]
max_allowed_packet 512M
```

Cause

Incorrect syntax in /etc/my.cnf , the option name and the value should be separated with '=' symbol.

Resolution

Edit /etc/my.cnf , you can use the
```
vi /etc/my.cnf
```
command for example.The max_allowed_packet requires '=' symbol before size number, so it should look like:
```
[mysqldump]
max_allowed_packet=512M
```
Restart mysql :
```
service mysql restart
```

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request