I figured out why the test site failed! I had to edit my MYSQL my.cnf and comment out the following line:

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

restart mysql

then the import worked just fine.