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 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:

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'

[falko]

Try
SET sql_mode = "NO_AUTO_VALUE_ON_ZERO";

instead.