Sprechen sie sql?

  • tecombs

    (@tecombs)


    10 years ago

    I recently reloaded my OS and everything WordPress.

    I tried to Import the database into myphpAdmin and was assaulted wit the following:

    CREATE TABLE IF NOT EXISTS wp_commentmeta (
    meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    comment_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
    meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    meta_value longtext COLLATE utf8mb4_unicode_ci,
    PRIMARY KEY (meta_id),
    KEY comment_id (comment_id),
    KEY meta_key (meta_key(191))
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

    Do I understand correctly that if I do what it says the site will work locally again?

    To be clear all I get from this is that a table must be created having to do with “wp_commentmeta” nothing else. The thing is that the backed up database came from this exact site and now it can’t be imported back. This is a case for consternation …

    I sure would appreciate anyone who could help me with this.

Viewing 4 replies - 1 through 4 (of 4 total)
  • backup-dropbox

    (@backup-dropbox)

    10 years ago

    Hi,

    CREATE TABLE IF NOT EXISTS wp_commentmeta (

    auf gut deutsch bedeutet es: “erstelle Tabelle, falls diese noch nicht vorhanden wp_commentmeta“.
    Also, du muss checken, ob die Tabelle wp_commentmeta in deiner Datenbank bereits existiert.
    Kann dir empfehlen alle importierenden Tabellen aus deiner Datenbank manuell zu löschen und dann wieder mit Wiederherstellung versuchen.
    That’s it.

    Thread Starter tecombs

    (@tecombs)

    10 years ago

    I should have known better than to joke around on an International site. I hope Google Translate is accurate. Here’s what it said:

    in good German it means “table created, if wp_commentmeta not available yet”. So, you must check whether the table wp_commentmeta already exists in your database. Can you recommend any import tables from your database manually delete and then again try to restore.

    Is that correct? Because from what I read it seemed like a certain table was missing and it wouldn’t import the previous database.

    How might one precisely do that without too much trouble, Freund? In the meantime, I’ll attempt to do what you said.

    Thread Starter tecombs

    (@tecombs)

    10 years ago

    In particular as I begin to try to create a table it now wants to know how many columns. I don’t know. I think I’ll count the entries on the left hand side and put that in to see what happens.

    Thread Starter tecombs

    (@tecombs)

    10 years ago

    Well, I’m progressing like others I imagine. I found my own answer to this inquiry, from this link to a graphic I deduced I needed 4 columns to satisfy the needs of the SQL wp_commentmeta table.

    https://codex.wordpress.org/images/2/25/WP4.4.2-ERD.png

    I imported the database and am happily – mostly – working at home again.

    However, just a plug for my most urgent need, I could still use some help with broken links to the various news articles within my WP site. I’ve deactivated the plugins, changed the theme, stood on hands while I changed the Permalinks – several times. All to no avail. Actually all that bashed my local installation so badly I had to replace it with a saved copy.

    See my member favorites if you can help.

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

The topic ‘Sprechen sie sql?’ is closed to new replies.