How to fix SQL Error 1146

I'm trying to change web host servers from 0 0 0 hosting to hosting 24 and when I exported my SQL database from my old house and when I try to upload the database. SQL I am granted with this error I'm not sure how to fix this I am sorry for the lack of knowledge hopefully you guys can help me out here I'm really struggling with this thank you very much have a good one

--
-- Database: a4093589_forum


--
-- Table structure for table phpbb_acl_groups

CREATE TABLE phpbb_acl_groups (

group_id MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
forum_id MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
auth_option_id MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
auth_role_id MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
auth_setting TINYINT( 2 ) NOT NULL DEFAULT '0',
KEY group_id ( group_id ) ,
KEY auth_opt_id ( auth_option_id ) ,
KEY auth_role_id ( auth_role_id )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

This is a Microsoft SQL Server forum, you may not find people here who know MySQL well enough to solve this for you.