Title: Restore Problem with myPHPadmin
Last modified: August 20, 2016

---

# Restore Problem with myPHPadmin

 *  Resolved [david](https://wordpress.org/support/users/dskirk/)
 * (@dskirk)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/restore-problem-with-myphpadmin/)
 * This is my first post here and I tried to follow guidelines. Feedback is welcome.
 * I am restoring to a different server with my BackupWordpress plugin’s backup 
   file. I already had a sandbox WP file on a server and uploaded the backup files,
   replacing the ones there. I used myPHPadmin via cpanel to import the database.
   My understanding is that I’ll need to do a search/replace of URLs prior to use,
   but I’m not that far yet. So far, I’m getting error message that WP can’t interact
   with database. I did not have access to the mySQL info on host server, just FTP,
   so I don’t know how to specify appropriately so WordPress on new server will “
   see” the database.
 * In myPHPadmin I created a new database and then imported the sql file. Received
   successful import message.
 * I’ve read a number of articles saying ‘enter your database name and user name’,
   but I don’t know PHP or mySQL. I found this text in the wp-config.php file and
   I ‘named’ the database that but it didn’t work.
 *     ```
       // ** MySQL settings - You can get this info from your web host ** //
       /** The name of the database for WordPress */
       define('DB_NAME', 'cic1204304404073');
       /** MySQL database username */
       define('DB_USER', 'cic1204304404073');
       /** MySQL database password */
       define('DB_PASSWORD', 'Dq8Ngr4o');
       /** MySQL hostname */
       define('DB_HOST', 'cic1204304404073.db.5534544.hostedresource.com');
       /** Database Charset to use in creating database tables. */
       define('DB_CHARSET', 'utf8');
       /** The Database Collate type. Don't change this if in doubt. */
       define('DB_COLLATE', '');
       ```
   
 * I’m seeking advice on what to do so WordPress will talk to the database. They’re
   both there, as best I understand. I think I’m close, but I’m at a standstill.
   There’s no link to my site because nothing shows, just the error message “Error
   establishing a database connection”. Thanks,
    david

Viewing 1 replies (of 1 total)

 *  Thread Starter [david](https://wordpress.org/support/users/dskirk/)
 * (@dskirk)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/restore-problem-with-myphpadmin/#post-3497883)
 * Okay, I managed to resolve the issue. Since I don’t know PHP or mySQL I needed
   to see what should be in wp-config.php to tie WP to the database. So I took the
   easy way out: I installed a second copy of WP in a different directory and after
   the install I copied the database info from the new wp-config.php file to my 
   original wp-config.file. Then I used myPHPadmin to drop all the tables in the
   new database and imported my backup database into it. And login was successful!!!
   I then ran the velvet blue plugin to search and replace my URL entries. I had
   a couple of bumps in that and had to edit/save my pages, but the site is now 
   on its new server. This was actually a test for me as I didn’t know if my backup
   was good unless I knew how to restore it. Now I do. It’s too early for a glass
   of wine, but maybe I’ll celebrate with an oreo cookie.

Viewing 1 replies (of 1 total)

The topic ‘Restore Problem with myPHPadmin’ is closed to new replies.

## Tags

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

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 1 participant
 * Last reply from: [david](https://wordpress.org/support/users/dskirk/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/restore-problem-with-myphpadmin/#post-3497883)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics