Title: Restoring Database
Last modified: August 20, 2016

---

# Restoring Database

 *  Resolved [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * (@webmistressofthedark)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/)
 * I have done this before but never across servers only the same database to a 
   hacked blog, after removing the fake user from the database… etc.
 * The old server was GoDaddy (UGH I know) and so the file is named like ivo1234123123.
   sql.zip
 * There was an old URL and old Admin email, Username and Password as well.
 * I tried uploading, and then altering those things, but still I can’t get the 
   blog to show up.
 * Can someone tell me what else I have to do to import this file? I see it in the
   DB, it’s the right file, as I recognize the content…
 * At wit’s end.. My PHP Admin is a mystery to me but I’ve been able to use it before….

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

 *  [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/)
 * (@swansonphotos)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595328)
 * Edit [wp-config.php](http://codex.wordpress.org/Editing_wp-config.php) and maybe
   even [.htaccess](http://codex.wordpress.org/Using_Permalinks)
 *  Thread Starter [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * (@webmistressofthedark)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595329)
 * I’m not sure what I would be editing it for or why?
 *  [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/)
 * (@swansonphotos)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595342)
 * I am sure it would take more than two minutes to read and understand the links.
   If you do not, you could [hire someone who does](http://jobs.wordpress.net/).
 *  Thread Starter [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * (@webmistressofthedark)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595348)
 * I simply need to know how to make the DB I have backed up flow into the new install
   on the new server. I have obviously fiddled with that a zillion times. I have
   edited the DB in MyPHPAdmin to match but it won’t work.
 * Obviously the old DB had a different name, username, password.. but I just don’t
   know how to change it.
 * You’re sending me on a dead end.
 *  [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/)
 * (@swansonphotos)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595363)
 * Please read the info at links.
 *  Thread Starter [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * (@webmistressofthedark)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595364)
 * I have managed to get the old DB into the SQL and to rename it to what it should
   be (xyz_123).
 * I had previously in the Cpanel created:
 * DB: xyz_123
    Username xyz_johndoe Password (matching the old DB) Added Username
   to DB xyz_123 with full permissions.
 * I have adjusted the config file to match.
 * Doesn’t seem to work with either the new or the old password. I am still not 
   able to make the blog show up with the new (old) data.
 * I am missing one more step. What is it?
 *  [Pioneer Web Design](https://wordpress.org/support/users/swansonphotos/)
 * (@swansonphotos)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595403)
 * Check with your Web Host for the proper db address:
 *     ```
       define('DB_HOST', 'yourdbhostnamehere');
       ```
   
 *  Thread Starter [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * (@webmistressofthedark)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595406)
 * Um it’s ‘localhost’. And it’s one of the four things that are configured in the
   Config file which I said I already knew how to do…
 * And I got it working… after gleaning bits of info from other helpers in closed
   threads.
 * All that was needed was, creating the DB, changing the name of the old DB, uploading
   the old one to the existing one in PHP Admin, deleting the old URLs in three 
   places (after doing a search for them as a value), logging in with old U/PW, 
   change to new U/PW… and voila… data is in a basic theme, and all is well.
 * Three of those things were never mentioned as required steps… but I sweated for
   four hours and finally figured it out.. thanks… er… nevermind.

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

The topic ‘Restoring Database’ is closed to new replies.

## Tags

 * [myphpadmin](https://wordpress.org/support/topic-tag/myphpadmin/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 8 replies
 * 2 participants
 * Last reply from: [webmistressofthedark](https://wordpress.org/support/users/webmistressofthedark/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/restoring-database-7/#post-2595406)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics