Title: Problems transferring .sql
Last modified: August 24, 2016

---

# Problems transferring .sql

 *  [haleyosborne](https://wordpress.org/support/users/haleyosborne/)
 * (@haleyosborne)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problems-transferring-sql/)
 * I’m moving my host from localhost to my live server at Fatcow and am having problems
   moving the MySQL db to Fatcow. They say they can’t help — it’s a wp issue.
 * Lots of impossible-for-me-to-understand error messages when I try to upload my
   backup .sql file to Fatcow.
 * I read the wp help doc on this but it doesn’t help:
    [http://codex.wordpress.org/Moving_WordPress](http://codex.wordpress.org/Moving_WordPress)
 * – I exported my db on phpmyadmin
    – I set up a new db, db username, and db password
   in Fatcow – I edited the following 4 lines in my wp-config.php file to match 
   the info I set up in Fatcow admin and FTP’d it to my /wordpress/ dir on fatcow:
 * define(‘DB_NAME’, ‘***I put the new name here***’);
 * /** MySQL database username */
    define(‘DB_USER’, ”***I put the new name here***’);
 * /** MySQL database password */
    define(‘DB_PASSWORD’, ”***I put the new name 
   password here***’);
 * /** MySQL hostname */
    define(‘DB_HOST’, ”***I put new the hostname here, copied
   from fatcow admin***’);
 * When I try to upload my .sql backup file in fatcow I get the following error 
   message:
 * —————
    Error SQL query:
 * —
    — Dumping data for table `wp_bwg_gallery` — INSERT INTO `wp_bwg_gallery` (`
   id` , `name` , `slug` , `description` , `page_link` , `preview_image` , `random_preview_image`,`
   order` , `author` , `published` ) VALUES ( 1, ‘Haley Makeup Portfolio’, ‘makeup’,”,”,”,‘/
   thumb/vanessa_tribal.jpg’, 1, 1, 1 ) ;
 * MySQL said: Documentation
 * #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
 * ———
 * Help!
 * Haley

Viewing 1 replies (of 1 total)

 *  [pluspt2001](https://wordpress.org/support/users/pluspt2001/)
 * (@pluspt2001)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/problems-transferring-sql/#post-5986015)
 * it happens because you might have already got some data in wp_bwg_gallery table…
   so may be you remove the previous data or change the id of the new imported data
   orther then one … you can not have multiple data on row 1 …. error says it very
   clearly

Viewing 1 replies (of 1 total)

The topic ‘Problems transferring .sql’ is closed to new replies.

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 1 reply
 * 2 participants
 * Last reply from: [pluspt2001](https://wordpress.org/support/users/pluspt2001/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/problems-transferring-sql/#post-5986015)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics