Title: Sprechen sie sql?
Last modified: August 31, 2016

---

# Sprechen sie sql?

 *  [tecombs](https://wordpress.org/support/users/tecombs/)
 * (@tecombs)
 * [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/)
 * 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](https://wordpress.org/support/users/backup-dropbox/)
 * (@backup-dropbox)
 * [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/#post-7288606)
 * 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](https://wordpress.org/support/users/tecombs/)
 * (@tecombs)
 * [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/#post-7288626)
 * 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](https://wordpress.org/support/users/tecombs/)
 * (@tecombs)
 * [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/#post-7288629)
 * 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](https://wordpress.org/support/users/tecombs/)
 * (@tecombs)
 * [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/#post-7288677)
 * 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](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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [tecombs](https://wordpress.org/support/users/tecombs/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/sprechen-sie-sql/#post-7288677)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics