Upload & Bypass MySQL Errors

wo^tron · #1 (**permalink**) 05-14-06, 02:18

I am trying to upload a very large dump but it has an error in it. Is there any Script/Program that allows you to upload a sql dump and Bypass any errors? Ive tried MySQL-Front but that just lags my computer out.

dbmab · #2 (**permalink**) 05-14-06, 11:16

If the errors are coming from the mysql server, there is no way to "bypass" them. What errors are you receiving? No one can provide specific help without knowing specifically what the errors are.

Quote:

lags my computer out

What does that mean?

If your mysql server allows remote access, give the mysql administrator a try - http://www.mysql.com/products/tools/administrator/

wo^tron · #3 (**permalink**) 05-14-06, 18:07

The error is in the dump file Im trying to upload theres nothing wrong with the server or the database

Code:

Query:
CREATE TABLE profiletagboard (
id int(11) NOT NULL auto_increment,
msg text NOT NULL,
touserid text NOT NULL,
fromuserid text NOT NULL,
date text NOT NULL,
PRIMARY KEY (id),
KEY msg (msg)
)

Error occured at:2006-05-14 01:58:16
Line no.:39822
Error Code: 1170 - BLOB/TEXT column 'msg' used in key specification without a key length

Thats the error I get. Id fix it if the Dump wasnt some 200MB in size

Quote:

lags my computer out

What does that mean?

When I try to restore it with mySQL front the program freezes and then my computer freezes shortly after.