Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Upload & Bypass MySQL Errors

    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.

  2. #2
    Join Date
    Apr 2006
    Denver, Co. USA
    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.

    lags my computer out
    What does that mean?

    If your mysql server allows remote access, give the mysql administrator a try -

  3. #3
    Join Date
    May 2006
    The error is in the dump file Im trying to upload theres nothing wrong with the server or the database

    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

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts