Importing database

[dayjahone]

Trying to update Pixelpost, it got screwed up and everything was gone. It installed a new version and didn't pick up any of the tons of photos already uploaded.

I had everything backed up, so I uploaded all of the files, deleted all of the tables in the database and imported the exported database backup using phpMyAdmin and I get the following error:

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Sep 06, 2008 at 07:07 AM
-- Server version: 4.0.21
-- PHP Version: 5.2.0
SET SQL_MODE =  "NO_AUTO_VALUE_ON_ZERO";


MySQL said: 

#1193 - Unknown system variable 'SQL_MODE'

Please, please help. There were seriously a lot of photos!

[Dkozikowski+]

The export created is not fully compatible....

Put -- before SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

EG: -- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";