moving wp, problems importing db on new server

  • hello,

    I am just moving my wp installation to a new server and I have problems importing the db on the new server running debian 3.1 and the same version of mysql 4.024 log2 if I am not mistaken.

    The error I get is this:

    [code]h898552:~/exports# mysql -h localhost -u root -p****** web3_db1 <
    web3_db1.sql
    ERROR 1064 at line 12: 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 'NOT NULL,
    PRIMARY KEY (id),
    KEY ip (ip(15))
    ) TYPE=MyISAM'
    h898552:~/exports#[/code]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Oh, I think I am having similar problems !!!!!

    Thread Starter Ovidiu

    (@ovidiu)

    I solved my problem:

    here is the sql dump right from the start:

    I just realized this part only concerns one plugin, which I could easily take out from my dump, I will try without that part.

    Quote:
    — MySQL dump 9.11
    —
    — Host: localhost Database: web3_db1
    — ——————————————————
    — Server version 4.0.24_Debian-10sarge2-log

    —
    — Table structure for table bad_behavior
    —

    DROP TABLE IF EXISTS bad_behavior;
    CREATE TABLE bad_behavior (
    id int(11) NOT NULL auto_increment,
    ip text NOT NULL,
    date datetime NOT NULL default ‘0000-00-00 00:00:00’,
    request_method text NOT NULL,
    request_uri text NOT NULL,
    server_protocol text NOT NULL,
    http_headers text NOT NULL,
    request_entity text NOT NULL,
    key text NOT NULL,
    PRIMARY KEY (id),
    KEY ip (ip(15))
    ) TYPE=MyISAM;

    —

    So just change
    Quote:
    key text NOT NULL

    to

    Quote:
    key text NOT NULL

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘moving wp, problems importing db on new server’ is closed to new replies.