Question

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when du mping table `wp_postmeta` at row: 7237

Posted November 12, 2019 272

Apache

How to solve the below apache error

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when du mping table `wp_postmeta` at row: 7237

By:

bepari662

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×

1 answer

bobbyiliev November 12, 2019

Hello,

This does not look like an Apache error but an error form mysqldump. You could try running your export with the following flag:

mysqldump --max_allowed_packet=1G

Hope that this helps!
Regards,
Bobby

Reply Report

bepari662 November 12, 2019
Output

Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] OR mysqldump [OPTIONS] --all-databases [OPTIONS] For more options, use mysqldump --help
Reply Report
- bobbyiliev November 12, 2019
  
  Note that you still need to specify the other information like your database, username and etc. For example:
  
  mysqldump --max_allowed_packet=1G -u YOUR_USER -p YOUR_DATABASE > YOUR_DATABASE.SQL
  
  Reply Report
  
  bepari662 November 12, 2019
  
  Thanks bobbyiliev
  
  Reply Report
  
  bobbyiliev November 12, 2019
  
  No problem at all @bepari662! Happy to help!
  
  Reply Report

Submit an Answer

Looking for something else?

Ask a new question Search for more help