Unknown system variable 'SQL_MODE'

[kavery327]

I have installed a backup of Joomla to my localhost which has Coppermine installed in a sub-directory "gallery". There is no bridge installed. Joomla works just fine on the localhost, and all that appears to be missing is the Coppermine database which Joomla Cloner doesn't backup and restore. So, I manually backup the Coppermine database, but get the following message when I try to manually restore it:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 10, 2008 at 01:10 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
MySQL said: 

#1193 - Unknown system variable 'SQL_MODE'

Any advice you can provide would helpful.

[Nibbler]

Remove that line. Not related to Coppermine.

[kavery327]

Thank you for your patience, I realize this is not a Coppermine problem now that I have been playing with it. I did what you suggested prior to your response and now it generates:

MySQL said: 

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=11' at line 27

Obviously this is not a Coppermine issue. I am using phpMyAdmin to create the backup script. Is there something better? I am not really up on MySQL and i just want an easy way to backup the database.

Thanks again for your help.

[Nibbler]

When you export from phpmyadmin, select the compatibility option for MySQL 4.0