problem with import

[knightlost]

Hi people, first sorry with my english, i'm spanish.

 

My problem is when import my oscommerce from a db mysql 4.x to my new server with mysql 5.x. The error is:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Servidor: 213.xx.xx.xx
-- Tiempo de generación: 16-12-2008 a las 17:51:00
-- Versión del servidor: 4.1.22
-- Versión de PHP: 4.3.10
-- 
-- Base de datos: `ac8655`
-- 
-- --------------------------------------------------------
-- 
-- Estructura de tabla para la tabla `address_book`
-- 
CREATE TABLE `address_book` (
`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) NOT NULL default '',
`entry_company` varchar( 32 ) default NULL ,
`entry_firstname` varchar( 32 ) NOT NULL default '',
`entry_lastname` varchar( 32 ) NOT NULL default '',
`entry_street_address` varchar( 64 ) NOT NULL default '',
`entry_suburb` varchar( 32 ) default NULL ,
`entry_postcode` varchar( 10 ) NOT NULL default '',
`entry_city` varchar( 32 ) NOT NULL default '',
`entry_state` varchar( 32 ) default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id` ( `customers_id` )
) ENGINE = MYISAM AUTO_INCREMENT =37DEFAULT CHARSET = latin1 AUTO_INCREMENT =37;

MySQL ha dicho: Documentación
#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 '`address_book_id` int(11) NOT NULL auto_increment,
 `customers_id` int(11) NOT ' at line 1

[♥geoffreywalton]

This code works

 

DROP TABLE IF EXISTS address_book;

CREATE TABLE address_book (

address_book_id int NOT NULL auto_increment,

customers_id int NOT NULL,

entry_gender char(1) NOT NULL,

entry_company varchar(32),

entry_firstname varchar(32) NOT NULL,

entry_lastname varchar(32) NOT NULL,

entry_street_address varchar(64) NOT NULL,

entry_suburb varchar(32),

entry_postcode varchar(10) NOT NULL,

entry_city varchar(32) NOT NULL,

entry_state varchar(32),

entry_country_id int DEFAULT '0' NOT NULL,

entry_zone_id int DEFAULT '0' NOT NULL,

PRIMARY KEY (address_book_id),

KEY idx_address_book_customers_id (customers_id)

);

 

You might want to remove ` and try again