Restore Problem with myPHPadmin

  • Resolved david

    (@dskirk)


    11 years, 9 months ago

    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

    (@dskirk)

    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.