Trouble uploading post table on new web host.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Nintendo
    Senior Member
    • Apr 2001
    • 178
    • 3.6.x

    Trouble uploading post table on new web host.

    Using phpMyAdmin to upload the post table I get this message when it's done with out showing the text that was upladed.

    'Your SQL-query has been executed successfull.'

    But it doesn't even list the 'post' table on the index.

    When going to the board page I get an error and a E-mail with this message.

    Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS posts FROM post
    mysql error: Table 'vgchatc_vgchat.post' doesn't exist
    mysql error number: 1146

    is there something wrong in the file? This is what it looks like.


    DROP TABLE IF EXISTS post;
    CREATE TABLE post (
    postid int(10) unsigned NOT NULL auto_increment,
    threadid int(10) unsigned DEFAULT '0' NOT NULL,
    username varchar(50) DEFAULT '' NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    title varchar(100) DEFAULT '' NOT NULL,
    dateline int(10) unsigned DEFAULT '0' NOT NULL,
    attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL,
    pagetext mediumtext,
    allowsmilie smallint(6) DEFAULT '0' NOT NULL,
    showsignature smallint(6) DEFAULT '0' NOT NULL,
    ipaddress varchar(16) DEFAULT '' NOT NULL,
    iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
    visible smallint(6) DEFAULT '0' NOT NULL,
    edituserid int(10) unsigned DEFAULT '0' NOT NULL,
    editdate int(10) unsigned DEFAULT '0' NOT NULL,
    PRIMARY KEY (postid),
    KEY iconid (iconid),
    KEY userid (userid),
    KEY threadid (threadid,userid)
    );

    INSERT INTO post VALUES
    (47,21,'Chrono',11,'',987624085,0,'Can I moderate the Super Smash Bros Message
    board?',1,1,'208.247.249.121',0,1,0,0);
    INSERT INTO post VALUES
    (3,3,'NM/De',2,'',987584411,0,'Excellent.
    ',1,0,'142.165.70.20',0,1,0,0);
    INSERT INTO post VALUES (4,4,'Ferry',5,'',987589027,1,'test
    test test...',1,1,'212.127.181.234',4,1,0,0);

    *SNIPED*

    Plus 4.2 megs of more posts.
    Public Domain Content
    Amazon/Webmaster Services
  • Freddie Bingham
    Former vBulletin Developer
    • May 2000
    • 14057
    • 1.1.x

    #2
    Please use the mysql console to restore your forum. phpMyAdmin is very flaky when it comes to doing this taskl.

    Comment

    • Nintendo
      Senior Member
      • Apr 2001
      • 178
      • 3.6.x

      #3
      Ugggg, you don't mean use Telnet do you?? It took me three days just to figure out how to get the backup of the posts!!!! I'm just moving them to a different web host, not restoring them on the same host. Everything but posts has been moved over to the new host.
      Public Domain Content
      Amazon/Webmaster Services

      Comment

      • Nintendo
        Senior Member
        • Apr 2001
        • 178
        • 3.6.x

        #4
        Yep, it's the size of the file that's the trouble. I tried uploading a 12K version of the file and it uploaded fine, except 4.2 megs of the posts arn't there!! I just got to find a way to upload the huge file and every thing will be moved to the new host.
        Public Domain Content
        Amazon/Webmaster Services

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...