Title: SQL Installation Problems #1050
Last modified: August 20, 2016

---

# SQL Installation Problems #1050

 *  [corrozu](https://wordpress.org/support/users/corrozu/)
 * (@corrozu)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/sql-installation-problems-1050/)
 * 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](https://wordpress.org/support/users/govpatel/)
 * (@govpatel)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/sql-installation-problems-1050/#post-2740804)
 * Check tables and see if you already have wp_commentmeta
 *  [southernboyuk](https://wordpress.org/support/users/southernboyuk/)
 * (@southernboyuk)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/sql-installation-problems-1050/#post-2740945)
 * 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.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 3 participants
 * Last reply from: [southernboyuk](https://wordpress.org/support/users/southernboyuk/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/sql-installation-problems-1050/#post-2740945)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics