SQL Installation Problems #1050

  • corrozu

    (@corrozu)


    14 years, 1 month ago

    When I try to import my database I get this error.
    Whenever I try to upload my exported database to the server I get this error message…

    SQL query:

    —
    — Database: test
    —
    — ——————————————————–
    —
    — Table structure for table wp_commentmeta
    —
    CREATE TABLE wp_commentmeta (
    meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT ‘0’,
    meta_key VARCHAR( 255 ) DEFAULT NULL ,
    meta_value LONGTEXT,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
    MySQL said:
    #1050 – Table ‘wp_commentmeta’ already exists

    I am still very new to wordpress… I’ve wiped and rewiped the server multiple times to try different orders on installing…I’m on bluehost and feel like i’m very close but still just a few things holding me back…

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

    (@govpatel)

    14 years, 1 month ago

    Check tables and see if you already have wp_commentmeta

    southernboyuk

    (@southernboyuk)

    14 years, 1 month ago

    Well I have just spent a glorious 12 hours trying to load my site with major loading problems. I actually find WP a great piece of software ,it’s just the upload and back up that needs some work on, even with all the plug in’s.

    I am no expert, in fact brand new to WP and I’m sure some of the techics will answer you on this but I had issues uploading the SQL files, even after following all the advice. The only way I got to another stage was to go to my SQL panel, ‘select all’ then empty the new SQL datase and then import one from the Xampp.

    This solved the problem.

    The only issue I now have left is that all my photographs have dissapeared whilst viewing the site (with Xampp off), the Gallery library does not display them with but does the details of each photo, but they are there, if I press edit they appear for editing. The URL routing is correctly allocated on every photo in the Media library.

    The bizzaire thing is that if I turn my Xampp local host on, they appear and when you click on to them to expand the view the URL is shown as my local host folder and file name, YET no where in the media library or gallery is this shown, as I said above they show the correct server URL.

    try to download notepad ++ open the SQL file and the lines will be numbered , you can then check files, it’s a useful addition

    I hope this helps, if not it was worth a try.

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

The topic ‘SQL Installation Problems #1050’ is closed to new replies.