Mysql Troubleshooting

  • Mysql error – Got a packet bigger than ‘max_allowed_packet’ bytes

**            In mysql console type the following :**

`set global net_buffer_length=1000000;```

`set global max_allowed_packet=10000000000000;```

and then import as :

mysql -u root -p --max_allowed_packet=1000M < dbdump.sql

  • Cannot load from mysql.proc. The table is probably corrupted

mysql -u user -p mysql_upgrade<br></br>