lamollner

danwpc, thanks for the information you posted about your experience upgrading to Yosemite and the latest version of MAMP. Back when I originally posted, I was working on a website as a volunteer so I had a couple of people who helped figure things out – thanks to all the information and suggestions in the posts from others in this thread. I was never able to sort out all the issues on my own, as I was a bit behind on the tech side of things, but you’ve now inspired me to try to sort through things again so I can learn the entire process. As I mentioned above, everyone who has posted was very thorough, patient, and knowledgeable. I will just start again at the beginning and work on learning about the processes described in the thread. So, thanks again, everyone for your help.

I’m guessing I should I mark the topic as “resolved” now (even if I personally was not able to sort things out entirely). Or do I leave it open for others to comment?

So here’s another update…I was able to install another version of WP and I am now able to login and view the theme I had been using. I can get to the dashboard just fine. Some of the CSS changes I had made are appearing but none of the content (like the page heading, main nav, and sub pages I had created) are showing up. I have a feeling that this information is lost forever but I still have a little hope because of the CSS updates that are showing up currently. Can anyone help me with what kinds of files to look for when trying to retrieve the content changes I had made? I have so many WP sites/folders now from all the work trying to get things working again that it is now really hard for me to figure out which folders are in fact the “important” ones. Thanks in advance for help/advice/ideas…Leslie

Latest update:

I am able to get to the HTML version (with no CSS) of the home page content at localhost:8888 but I am not able to login to the database. I’m getting an error message that indicates that there is a problem connecting to the database. I have been able to get to the login screen but, as I wrote earlier, that didn’t work. Also, I’m not able to get to a WP dashboard to try the resaving of the permalinks.

Here is the code from wp-db.php that seems to indicate that I’m not connecting to my database correctly. I’m not sure what it all means unfortunately but maybe those of you who have been helping me will recognize something in the code:

* Connect to and select database
*
* @since 3.0.0
*/
function db_connect() {

$this->is_mysql = true;

$new_link = defined( ‘MYSQL_NEW_LINK’ ) ? MYSQL_NEW_LINK : true;
$client_flags = defined( ‘MYSQL_CLIENT_FLAGS’ ) ? MYSQL_CLIENT_FLAGS : 0;

if ( WP_DEBUG ) {
$error_reporting = false;
if ( defined( ‘E_DEPRECATED’ ) ) {
$error_reporting = error_reporting();
error_reporting( $error_reporting ^ E_DEPRECATED );
}
$this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
if ( false !== $error_reporting ) {
error_reporting( $error_reporting );
}
} else {
$this->dbh = @mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
}

if ( !$this->dbh ) {
wp_load_translations_early();
$this->bail( sprintf( __( “
<h1>Error establishing a database connection</h1>
<p>This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at %s. This could mean your host’s database server is down.</p>

• Are you sure you have the correct username and password?
• Are you sure that you have typed the correct hostname?
• Are you sure that the database server is running?

<p>If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.</p>
” ), htmlspecialchars( $this->dbhost, ENT_QUOTES ) ), ‘db_connect_fail’ );

return;
}

$this->set_charset( $this->dbh );

$this->ready = true;

$this->select( $this->dbname, $this->dbh );
}

So, I guess another description would be that I have WP installed with an altered HTML home page showing my previously designed home page. However, no CSS or other parts of the Canvas theme are working. I have also entered a support ticket on the Canvas theme site. Somehow I am not pointing to the correct database or folder is what it seems to me.

I’ve been able to access the PHPmyAdmin tool. However, I just don’t understand the next steps. I’m looking at the wp-config.php file in Coda and I see that the db name is localwp. I guess what it might be is that I don’t have an official backup of my WP database. I have several different files that contain all the WP site files but they must not technically be backups. I think I’m really close to understanding what to do, I just can’t figure it out.

Ok, I figured out how to reinstall wordpress so things are working in this regard. Now I just need to tackle restoring the database so I’ll be looking at the instructions posted by michalzuber.

Ok, 2by2host. I will back everything up and the try a new install. Then I will try and figure out how to reimport the DB. I don’t know any developers who can help me but I’ll see what I can figure out. I don’t work at a web design studio or anything (yet, obviously!) So, thanks again for your help. I’ll post my results after a new install.