• Export  the .sql file with phpmyadmin
• Open the .sql file with a text editor ( notepad++ generally handles well large text files, so it's a good choice for this sort of thing )
• At the top of the file, you will see these comments :

-- phpMyAdmin SQL Dump

-- version x.x.x

-- http://www.phpmyadmin.net

--

-- Host: [your host location]

-- Generation Time: [month/date/year time]

-- Server version: [sever version]

-- PHP Version: [server version]

• Replace them with the following :

-- MySQL Administrator dump 1.4

--

-- ------------------------------------------------------

-- Server version    5.0.27-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;