0

Having trouble creating a database backup on shared hosting where I do not have control over mysql config.

The error I'm receiving is:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `wp_postmeta` at row: 870

Is there a workaround or a script I can use to dump the DB in a more optimal state?

Jon Lachonis
  • 911
  • 1
  • 8
  • 18
  • possible duplicate of [MySQL Error 1153 - Got a packet bigger than 'max\_allowed\_packet' bytes](http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes) – worpet Apr 02 '15 at 18:46

1 Answers1

0

You can increase 'max_allowed_packet' value like this

shell> mysql --max_allowed_packet=512M

For detail info see documentation.

Oleksandr Mosur
  • 1,148
  • 8
  • 17