Got this error please help

netpox Active Member

Messages:: 1,625

Likes Received:: 27

Best Answers:: 0

Trophy Points:: 90

#1

I am transferring a database from one server to another and got this error:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 15, 2007 at 11:29 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `album_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `t_admin`
--
CREATE TABLE `t_admin` (
`nIdAd` int( 11 ) NOT NULL AUTO_INCREMENT , `sUserAd` text COLLATE latin1_general_ci NOT NULL , `sPassAd` text COLLATE latin1_general_ci NOT NULL , `dLastLogin1Ad` datetime NOT NULL default '0000-00-00 00:00:00', `dLastLogin2Ad` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ( `nIdAd` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =4;

MySQL said: Documentation
#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 'collate latin1_general_ci NOT NULL,
`sPassAd` text collate l
Click to expand...