You might have faced an issue when exporting mysql database from server to localhost/phpmyadmin.
One of the reason for this issues is the compatibility between the versions of PHP and MYSQL used at both ends.
Fortunately this can be fixed in 2 easy steps when exporting database from server to localhost environment.
Step 1: Select Custom Export Method
Step 2: Select Format Specific Options as listed below
