Correcting Magento Migration to local server error

to correct this error on importing the database you need to open the .sql file in a large text editor like Elitepad Lite then remove all occurrences of:

ROW_FORMAT=FIXED

from the file then import,

THE ERROR CODE IS:

ERROR 1031 (hy000) AT LINE XXX TABLE STORAGE ENIGINE FOR ” DOESNT HAVE THIS OPTION