Import from Test Server error

Hi Guys,

I have done a few successful transfers from my test server to the deployment sever when exporting the database and then importing it (except correctin image paths, which is a different post I have launched).

I have a new project that when I go to import the SQL export from my test server in PHPMyAdmin, I get the following error:

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.9.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2008 at 12:17 AM
-- Server version: 4.1.22
-- PHP Version: 5.2.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'

Do you have any idea how I fix this?

Regards,

Benedict