Title: Moving A WordPress Database?
Last modified: May 11, 2020

---

# Moving A WordPress Database?

 *  Resolved [philbertdog](https://wordpress.org/support/users/philbertdog/)
 * (@philbertdog)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/)
 * Hello!
 * I’m trying to learn how to manually move a WordPress site from one host to another.
   I seem to be stuck on moving the database from one host to another. Here’s what
   I’m doing…
 * 1) Backup files and database on old host.
    2) Edit name servers to move the domain
   to new host. 3) Install WordPress in domain on new host. 4) FTP WordPress plugins
   and uploads from old host to new host.
 * So far, so good, got this part.
 * I know how to import a WordPress database using phpMyAdmin. But I don’t how to
   import it so the data is then displayed on the site at new host.
 * I know how to edit wp-config.php. But what credentials do I use? Name,user,password
   from old host? Name,user,password created by new WP install?
 * Do I import the old database in to the new database created by the WordPress 
   install on new host? Do I create a new database on the new host and import in
   to that??
 * What’s the correct method of moving a WordPress database on one host to a fresh
   WordPress install on a new host?
 * Many thanks for any clarification.

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

 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12812238)
 * > I’m trying to learn how to manually move a WordPress site from one host to 
   > another.
 * You may find this article useful:
    [https://wordpress.org/support/article/moving-wordpress/#moving-to-a-new-server](https://wordpress.org/support/article/moving-wordpress/#moving-to-a-new-server)
 *  Thread Starter [philbertdog](https://wordpress.org/support/users/philbertdog/)
 * (@philbertdog)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12813692)
 * Thank you. I’ve read MANY such articles, including that one, and still appear
   to be having problems, which I’ve attempted to specifically identify in the hopes
   of finding a specific answer.
 *  Thread Starter [philbertdog](https://wordpress.org/support/users/philbertdog/)
 * (@philbertdog)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12819953)
 * From the article linked to above…
 * > If database and URL remain the same, you can move by just copying your files
   > and database.
   > If database name or user changes, edit wp-config.php to have the correct values.
   > If you want to test before you switch, you must temporarily change “siteurl”
   > and “home” in the database table “wp_options” (through phpMyAdmin or similar).
   > If you had any kind of rewrites (permalinks) setup you must disable .htaccess
   > and reconfigure permalinks when it goes live.
 * This is why people ask questions on forums. Unless one is already an experienced
   WordPress user much of the above won’t make sense. The author of that article
   assumes I am him, but I am instead me. He says…
 * > you can move by just copying your files and database.
 * I know how to move the files. How do you move the database?
 * > If you want to test before you switch, you must temporarily change “siteurl”
   > and “home” in the database table “wp_options” (through phpMyAdmin or similar).
   > If you had any kind of rewrites (permalinks) setup you must disable .htaccess
   > and reconfigure permalinks when it goes live.
 * Completely worthless information to a novice user.
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12822325)
 * > The author of that article assumes I am him, but I am instead me. He says… 
   > Completely worthless information to a novice user.
 * WordPress is both built and supported for free by volunteers who do this on their
   free time. So *you* must resolve your problem, because nobody here can do anything
   to your site, in any way whatsoever.
 * If you want to try “real time” conversation, jump into the WordPress IRC channel.
   [https://make.wordpress.org/support/irc-support-channel/](https://make.wordpress.org/support/irc-support-channel/)
 * If you can’t do the work yourself, you have the option of engaging a professional
   to assist you. If you want to follow that option and hire someone for this, then
   please try [http://jobs.wordpress.net/](http://jobs.wordpress.net/)
 *  Thread Starter [philbertdog](https://wordpress.org/support/users/philbertdog/)
 * (@philbertdog)
 * [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12824282)
 * > WordPress is both built and supported for free by volunteers who do this on
   > their free time. So *you* must resolve your problem, because nobody here can
   > do anything to your site, in any way whatsoever.
 * This is a forum for technical questions about WordPress. The mods have asked 
   me to focus on technical questions about WordPress, which seems a good plan. 
   So I’ve asked a technical question about WordPress.
 * It would have been entirely reasonable for you to ignore my technical question
   about WordPress. Or to try to answer my technical question about WordPress, should
   doing so interest you.
 * Instead of ignoring or answering my technical question about WordPress you’ve
   used the opportunity to try to change the subject of the thread to your preferred
   learning methodology, and to lecture me, which seems to be one of the themes 
   of this site. And by using your power as a mod to change the topic of my thread,
   you’ve likely made it so no one else will engage the question I’ve asked.
 * If would have been more helpful if you had instead chosen to simply ignore a 
   question which you don’t wish to engage. I have no problem with that, for we 
   agree there is no obligation on your part.
 * Given this thread is not going to be about my question after all, I cede it to
   you for whatever purpose you find enjoyable.

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

The topic ‘Moving A WordPress Database?’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 2 participants
 * Last reply from: [philbertdog](https://wordpress.org/support/users/philbertdog/)
 * Last activity: [6 years ago](https://wordpress.org/support/topic/moving-a-wordpress-database/#post-12824282)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
