Is my database backup messed up?

Lita · New Member Joined: Sep 29, 2004 Posts: 11

I dropped all the tables in my database, then i click sql tab in phpmyadmin then i click browse and find the saved sql file i made for backup that i did in the phpmyadmin. after i click go i recieve the following error:

Code:
Error

SQL-query :

CREATE TABLE nuke_config(

sitename varchar( 255 ) NOT NULL ,
nukeurl varchar( 255 ) NOT NULL ,
site_logo varchar( 255 ) NOT NULL ,
slogan varchar( 255 ) NOT NULL ,
startdate varchar( 50 ) NOT NULL ,
adminmail varchar( 255 ) NOT NULL ,
anonpost tinyint( 1 ) DEFAULT '0' NOT NULL ,
Default_Theme varchar( 255 ) NOT NULL ,
foot1 text NOT NULL ,
foot2 text NOT NULL ,
foot3 text NOT NULL ,
commentlimit int( 9 ) DEFAULT '4096' NOT NULL ,
anonymous varchar( 255 ) NOT NULL ,
minpass tinyint( 1 ) DEFAULT '5' NOT NULL ,
pollcomm tinyint( 1 ) DEFAULT '1' NOT NULL ,
articlecomm tinyint( 1 ) DEFAULT '1' NOT NULL ,
broadcast_msg tinyint( 1 ) DEFAULT '1' NOT NULL ,
my_headlines tinyint( 1 ) DEFAULT '1' NOT NULL ,
top int( 3 ) DEFAULT '10' NOT NULL ,
storyhome int( 2 ) DEFAULT '10' NOT NULL ,
user_news tinyint( 1 ) DEFAULT '1' NOT NULL ,
oldnum int( 2 ) DEFAULT '30' NOT NULL ,
ultramode tinyint( 1 ) DEFAULT '0' NOT NULL ,
banners tinyint( 1 ) DEFAULT '1' NOT NULL ,
backend_title varchar( 255 ) NOT NULL ,
backend_language varchar( 10 ) NOT NULL ,
language varchar( 100 ) NOT NULL ,
locale varchar( 10 ) NOT NULL ,
multilingual tinyint( 1 ) DEFAULT '0' NOT NULL ,
useflags tinyint( 1 ) DEFAULT '0' NOT NULL ,
notify tinyint( 1 ) DEFAULT '0' NOT NULL ,
notify_email varchar( 255 ) NOT NULL ,
notify_subject varchar( 255 ) NOT NULL ,
notify_message varchar( 255 ) NOT NULL ,
notify_from varchar( 255 ) NOT NULL ,
moderate tinyint( 1 ) DEFAULT '0' NOT NULL ,
admingraphic tinyint( 1 ) DEFAULT '1' NOT NULL ,
httpref tinyint( 1 ) DEFAULT '1' NOT NULL ,
httprefmax int( 5 ) DEFAULT '1000' NOT NULL ,
CensorMode tinyint( 1 ) DEFAULT '3' NOT NULL ,
CensorReplace varchar( 10 ) NOT NULL ,
copyright text NOT NULL ,
Version_Num varchar( 10 ) NOT NULL ,
PRIMARY KEY ( sitename ) ,
KEY foot1( foot1 ) ,
KEY nukeurl( nukeurl ) ,
KEY sitename( sitename ) ,
KEY nukeurl_2( nukeurl ) ,
KEY nukeurl_3( nukeurl )
)

MySQL said:

BLOB column 'foot1' used in key specification without a key length

Is this problem unfixable?! Thanks!

chatserv · Posted: Sun Oct 03, 2004 6:59 pm

Change in that file:

Code:

Version_Num varchar( 10 ) NOT NULL ,
PRIMARY KEY ( sitename ) ,
KEY foot1( foot1 ) ,
KEY nukeurl( nukeurl ) ,
KEY sitename( sitename ) ,
KEY nukeurl_2( nukeurl ) ,
KEY nukeurl_3( nukeurl )
)

to:

Code:

Version_Num varchar(10) NOT NULL default '',
PRIMARY KEY (sitename)
) TYPE=MyISAM;

Lita · New Member Joined: Sep 29, 2004 Posts: 11

Doing as you said I recieved the following error. It appears to be an error from the Coppermine Gallery module? I dunno anything about this stuff...but the initials CPG and pictures after it makes me think this way, if it is and if I need to somehow take out this table and lose the information within then that's fine as long as you tell me how to do it. I can always re upload the pictures. Thanks for the quick response!

Code:

Error

SQL-query :

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( 14 ) ,
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, user1, user2, user3, user4 )
)

MySQL said:

BLOB column 'caption' used in key specification without a key length

chatserv · Posted: Sun Oct 03, 2004 8:30 pm

I suggest removing that table's code along with its insert lines (save these insert lines to another file) from the backup file, once your backup has loaded create that table using coppermine's sql file and then use the insert lines you saved earlier.

Lita · New Member Joined: Sep 29, 2004 Posts: 11

Hey Chatserv, thanks so much for the reply. I really thought I was hopeless and had lost all the files I've been working on the past year. Though, I have one more question if you don't mind. What exactly do the insert lines look like? Is it this "CREATE TABLE nuke_cpg_pictures". Thanks again, and I'll be sure to try the solution as soon as I get home from work!

chatserv · Posted: Mon Oct 04, 2004 8:35 am

They will look something like:

Code:

INSERT INTO nuke_cpg_pictures VALUES ('etc
INSERT INTO nuke_cpg_pictures VALUES ('etc

Lita · New Member Joined: Sep 29, 2004 Posts: 11

Thanks so much, it worked!!! Very Happy