HELP: moving DB to another server probs :(

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin GPO (kevingpo_at_yahoo.com)
Date: 12/19/04 

Date: Sun, 19 Dec 2004 09:09:15 -0800

I exported my database so that I can move my website to another server
PC. Upon importing into the new MySQL server I get this error messsage.
I had a look at MySQL website but to no avail I still did not know what
it means or how to solve it. Please can someone help me solve this bug.

MySQL said:

#1170 - BLOB/TEXT column 'caption' used in key specification without a
key length

#
# Dumping data for table 'nuke_cpg_exif'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_cpg_pictures'
#
CREATE TABLE nuke_cpg_pictures(

pid int( 11 ) NOT NULL AUTO_INCREMENT ,
aid int( 11 ) DEFAULT '0' NOT NULL ,
filepath varchar( 255 ) NOT NULL ,
filename varchar( 255 ) NOT NULL ,
filesize int( 11 ) DEFAULT '0' NOT NULL ,
total_filesize int( 11 ) DEFAULT '0' NOT NULL ,
pwidth smallint( 6 ) DEFAULT '0' NOT NULL ,
pheight smallint( 6 ) DEFAULT '0' NOT NULL ,
hits int( 10 ) DEFAULT '0' NOT NULL ,
mtime timestamp DEFAULT 'CURRENT_TIMESTAMP',
ctime int( 11 ) DEFAULT '0' NOT NULL ,
owner_id int( 11 ) DEFAULT '0' NOT NULL ,
owner_name varchar( 40 ) NOT NULL ,
pic_rating int( 11 ) DEFAULT '0' NOT NULL ,
votes int( 11 ) DEFAULT '0' NOT NULL ,
title varchar( 255 ) NOT NULL ,
caption text NOT NULL ,
keywords varchar( 255 ) NOT NULL ,
approved enum( 'YES', 'NO' ) DEFAULT 'NO' NOT NULL ,
user1 varchar( 255 ) NOT NULL ,
user2 varchar( 255 ) NOT NULL ,
user3 varchar( 255 ) NOT NULL ,
user4 varchar( 255 ) NOT NULL ,
url_prefix tinyint( 4 ) DEFAULT '0' NOT NULL ,
randpos int( 11 ) DEFAULT '0' NOT NULL ,
pic_raw_ip tinytext,
pic_hdr_ip tinytext,
PRIMARY KEY ( pid ) ,
KEY pic_hits( hits ) ,
KEY pic_rate( pic_rating ) ,
KEY aid_approved( aid, approved ) ,
KEY randpos( randpos ) ,
KEY pic_aid( aid ) ,
KEY search( title, caption, keywords, filename )
)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Inserting an Email Address fails.
    ... 'Position' VARCHAR NOT NULL, ... "You have an error in your SQL syntax. ... corresponds to your MySQL server version for the right syntax to use ...
    (perl.dbi.users)
  • Re: varchar problem
    ... >>>read indicates that text entered into a MySQL table with varchar ... >Heading "Char vs. Varchar" ... about CHAR datatypes - the CHAR datatype PADs with spaces. ... Query OK, ...
    (alt.php)
  • Re: checkbox values stored in mysql
    ... you need to review the MySQL docs concerning the CHAR/VARCHAR data types at: ... There is a table that shows what the difference between CHAR and VARCHAR - read ... Whoever gave you that sage advice obviously should not be designing databases. ... MySQL and PostgreSQL are fine for some ...
    (comp.lang.php)
  • Re: MySQLdb Error
    ... check the manual that corresponds to your MySQL server version for ... You're getting an error back from the database. ... Spoiler alert! ... 'varchar' is a PostgreSQL feature only. ...
    (comp.lang.python)
  • MYSQL - PHP
    ... First of all sorry if this is not the correct newsgroup for this question, ... but I am using PHP with MYSQL and someone here could have an answer and the ... bak_content_title varchar ...
    (comp.lang.php)