Unable to import MYSQL database

[1just4help]

Hi can you help???

i am trying to import my database from 1 shopping cart to my new server and new shopping cart,
i have coied all my files over to the new server and dropped all my tabls on the new MY SQL data base and when importing via, Gzip or zip file i get the below error?

Can you advise what i am doing wrong please as i am sooooooo confused

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 14, 2007 at 06:26 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3
--
-- Database: `fr201jus_zc1`
--
CREATE DATABASE `fr201jus_zc1` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci
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 CHARACTER SET latin1 COLLATE latin1_general_ci' at line

[SirBuck]

what are you using to import the DB? what did you use to export and what were those settings?

Also, how big is the database file?

[DrByte]

And what version of MySQL on the new server?

[1just4help]

Hi, I am using phpMyAdmin version 4.0

[1just4help]

the file is 238 kb and i used phpMyAdmin version 4.0 to export to a gzip, zip and a sql file format, i have tried all formats to upload and none work

[SirBuck]

Why don't you just export that without zipping?

[DrByte]

Your server is probably set up to disallow you from creating databases via a .sql import.

So, either edit your .sql file before you attempt to upload it, and put a # before the CREATE DATABASE `fr201jus_zc1` .... line,
or, when you do your export, select your database from the pulldown on the left, so that all your tables are displayed, and *then* click the "Export" tab. This should cause it to skip building the CREATE DATABASE statement.

FAQ: https://www.zen-cart.com/tutorials/i...hp?article=103

[1just4help]

Hi - sorry. i have tried the text only and this has not work either. i have now tried the scond option as i am still very new to all this and do not understand how to edit a sql. database.

The results i recived when uploading the new sql was

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 17, 2007 at 09:11 AM
-- 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'

sorry i'm sure this task is supposed to be easy

[DrByte]

It seems like you're trying to load a MySQL 4 or 5 database onto a v3.23 server.

You never did indicate what version of MySQL is on your server.

[1just4help]

Hi, the database that i am using to upload on to is version 4 but i have the option to create a version 5. the database that i am tansferinf from is a version 4