1. K

    How to increase max_allowed_packet in mysqldump?

    You can increase the max_allowed_packet in my.cnf file. You have to edit my.cnf file and add below line in my.cnf file. First you have to find [mysqldump] section in /etc/my.cnf file and then add below code : [mysqldump] max_allowed_packet=268435456 You can add value according to your choice.
  2. K

    Crashed mysqldump error 1194 table

    You would have received an error by saying “mysqldump error 1194 table is marked as crashed”. It says you to repair the crashed mysqldump error 1194 table! You might knock with the multiple reasons for the occurrence of error mysqldump. Most probably it will in and around the server crash. The...
  3. K

    Steps to take backup and restore with mysqldump

    First take backup of your database with below command: #mysqldump -u username -p[username_password] databasename > /path_to_your_db/databasename_backup.sql Here you have to use your user name in place of “username”, your databasename and path of your database. You have to use below command to...