moving sql database to new server (wordpress) problems...

Discussion in 'MySQL' started by BigJonnyB, Sep 27, 2007.

0
  1. #1
    Hi,
    Please bear with me, and if anyone needs anymore information please ask. I am trying to move a wordpress site from one server to another (domain will stay the same). I have uploaded all the ftp files. There are two databases, one of which has imported okay. However, when I try and import the second I get this error message:

    CREATE TEMPORARY TABLE `COLUMN_PRIVILEGES` (
    `GRANTEE` varchar( 81 ) NOT NULL default '',
    `TABLE_CATALOG` varchar( 512 ) default NULL ,
    `TABLE_SCHEMA` varchar( 64 ) NOT NULL default '',
    `TABLE_NAME` varchar( 64 ) NOT NULL default '',
    `COLUMN_NAME` varchar( 64 ) NOT NULL default '',
    `PRIVILEGE_TYPE` varchar( 64 ) NOT NULL default '',
    `IS_GRANTABLE` varchar( 3 ) NOT NULL default ''
    ) ENGINE = MEMORY DEFAULT CHARSET = utf8;

    MySQL said: Documentation
    #1163 - The used table type doesn't support BLOB/TEXT columns

    I have tried doing it by the file, and by copying the text in from notepad. The latter works until about half way through the file, when it gives the same error message. Does anyone know what the problem is (it is most likely something I am doing/not doing). If someone with itrader can fix this so the site works ok I am willing to pay...but I kind of want to learn myself at the same time.

    Thanks.
    JB
     
    BigJonnyB, Sep 27, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try it without the TEMPORARY :
    
CREATE TABLE `COLUMN_PRIVILEGES` (
`GRANTEE` varchar( 81 ) NOT NULL default '',
`TABLE_CATALOG` varchar( 512 ) default NULL ,
`TABLE_SCHEMA` varchar( 64 ) NOT NULL default '',
`TABLE_NAME` varchar( 64 ) NOT NULL default '',
`COLUMN_NAME` varchar( 64 ) NOT NULL default '',
`PRIVILEGE_TYPE` varchar( 64 ) NOT NULL default '',
`IS_GRANTABLE` varchar( 3 ) NOT NULL default ''
) ENGINE = MEMORY DEFAULT CHARSET = utf8;
    Code (markup):
     
    maiahost, Sep 27, 2007 IP
  3. BigJonnyB

    BigJonnyB Peon

    Messages:
    325
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi,
    Thanks for the reply...it was me being dum afterall and I have managed to sort it (there were two databases on the old server and I was trying to upload them both...but the one that wasn't working wasn't anything to do with the site lol).
    wooh glad that got sorted anyway...time for a drink!
    JB
     
    BigJonnyB, Sep 27, 2007 IP