#mysql Bugs : #43326 : #spatial key index prefix needs documentation in 5.1 upgrade docs
▻https://bugs.mysql.com/bug.php?id=43326
Before MySQL 5.0.40, mysqldump displays SPATIAL index definitions using prefix lengths for the indexed columns. These prefix lengths are accepted in MySQL 5.0, but not as of MySQL 5.1. If you use mysqldump from versions of MySQL older than 5.0.40, any table containing SPATIAL indexes will cause an error when the dump file is reloaded into MySQL 5.1 or higher.