Title: PhpMyAdmin export & import
Last modified: August 20, 2016

---

# PhpMyAdmin export & import

 *  [rebeccaireland](https://wordpress.org/support/users/rebeccaireland/)
 * (@rebeccaireland)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-export-import/)
 * Hi,
 * I am moving hosts, and need to transfer my wordpress sites.
 * I have exported the DB’s as .sql files, and have followed the wordpress documentation
   on this.
 * I havnt changed the db names, if I do will this affect my website from working
   when I transfer it over? or does it not reference the db name?
 * Thanks.
 * Rebecca

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

 *  [Avinash Bhageloe](https://wordpress.org/support/users/avinashbhageloe/)
 * (@avinashbhageloe)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-export-import/#post-2231823)
 * rebeccaireland,
 * The dn names don’t matter. I can stay the same.
    Note that u must change yout
   path. If ur useing localhost/website than change this 2 your new website url.
   for example [http://www.website.com](http://www.website.com)
 * Mvg,
    Avinash Bhageloe
 *  Thread Starter [rebeccaireland](https://wordpress.org/support/users/rebeccaireland/)
 * (@rebeccaireland)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-export-import/#post-2231830)
 * Hi,
 * So at the moment, in the backed up version, its referencing ‘db89241_circled’.
   But if i try to import this .sql file it gives me the error “#1044 – Access denied
   for user ‘db131044_circled’@’%’ to database ‘db89241_circled'”.
 * the db I set up on my new hosting is called ‘db131044_circled’.
 * So should i replace this in the .sql file im replacing?
 * Sorry for all the questions, I just dont understand how my WordPress site is 
   referencing my DB, and im concerned I might lose it all.
 * Thanks,
 * Rebecca
 *  [Avinash Bhageloe](https://wordpress.org/support/users/avinashbhageloe/)
 * (@avinashbhageloe)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-export-import/#post-2231837)
 * Rebecca,
 * No not only the name of the .sql database.
    Change the name in the database also.
   extract is using winzip an dan open it with dreamweaver or Notepad and in the
   top u must chnage the database username.
 * *always make a backup so that u don’t lose ur data.
 * Mvg,
    Avinash Bhageloe

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

The topic ‘PhpMyAdmin export & import’ is closed to new replies.

## Tags

 * [db](https://wordpress.org/support/topic-tag/db/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 2 participants
 * Last reply from: [Avinash Bhageloe](https://wordpress.org/support/users/avinashbhageloe/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/phpmyadmin-export-import/#post-2231837)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics