Syntax errors when creating HEAP tables and using IF NOT EXISTS

We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the q

Syntax errors when creating HEAP tables and using IF NOT EXISTS

We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the q