Bug #31103 1193 - Unknown system variable 'SQL_MODE'

• Submitted: 20 Sep 2007 5:30
• Modified: 20 Sep 2007 8:42
• Reporter: antonio antonio
• Status: Not a Bug
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 4.4.1
• OS: Any
• CPU Architecture: Any
• Tags: Backup, no, sqlmode

[20 Sep 2007 5:30] antonio antonio

Description:
Ok so when i make a database, i make all the tables blah blah blah.

I then create a new database, and import all of the tables into it by dumping them from the first DB (using myphpadmin) and import them to the new one (using myphpadmin)

How ever, when i go to import them, i get this error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: Sep 19, 2007 at 10:13 PM
-- Server version: 4.0.16
-- PHP Version: 4.4.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE' 

If i remove that line from the dump, it imports just fine (i think)

How to repeat:
Make a data base with tables

Export it to a file

Drop that table

and Try ti import it.

[20 Sep 2007 8:42] MySQL Verification Team

SQL_MODE variable is supported only from MySQL 4.1 version:

http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html