Importing Database

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 from the "web" directory, deleted all of the table in the database and imported the exported database backup using phpMyAdmin and I get the following error:

Code:

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' 

 

Try

Code:

SET sql_mode =  "NO_AUTO_VALUE_ON_ZERO";

instead.