Moving WordPress from MAMP to host — No Luck!!

[Day_Robbie]

I’m having major issues with moving the WordPress site I’ve built locally with MAMP to my host. The domain is http://ipolitech.com Here’s the error the browser is spitting out:

“Error establishing a database connection

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request…”

I’ve followed the steps Chris lays out in his “Moving up with MAMP” screencast. For clarity’s sake, here’s what I’ve done:

1. Downloaded the database (.sql format) from my local PHPMyAdmin.
2. Created a database on my host and uploaded the contents from my local database
3. Changed the “siteurl” and “home” in wp-options to the new domain**
4. Upload all WordPress files via ftp to my root folder in my host
5. Change wp-config.php to reflect the new credentials for the new database
6. NO LUCK — getting the error pasted above in all browsers
**After having no luck with this, I also tried opening the database in a text editor, and using replace-all to replace every instance of “http://localhost:8888” with “http://ipolitech.com”

This is my first time moving from a local environment to a host, and I am wondering if I’m missing something. Could my .htaccess file be causing the problems?

Here’s what my local .htaccess file looks like:

# BEGIN WordPress

RewriteEngine On
RewriteBase /wordpress/
RewriteRule ^index.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /wordpress/index.php [L]


# END WordPress


Here’s what I’ve changed it to on my host:

# BEGIN WordPress

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

# END WordPress


Anyway, I know this isn’t a WordPress forum, but I thought I’d throw it out there just in case someone could help. I have no idea if .htaccess has anything to do with this, especially because the browser says it can’t connect to my database…

Thank you thank you thank you!

Robbie Day

[Senff]

You probably did this, but just making sure… you did create a database user with full access, right?
Only asking because I didn’t see it between steps 2 and 3.

[Day_Robbie]

I didn’t know about this! I didn’t do anything manually to make this happen.. I’m using fatcow as my host and will dig into that right now!

[Day_Robbie]

Yep, the user has all the possible privileges for the database.

[TheDoc]

You’re not connecting to the database properly, so it sounds like you’re missing something important in your wp-config.

[Day_Robbie]

http://pastebin.com/FUgnUt0F

-Here’s my wp-config file that’s on my host. I’ve taken out the database credentials and added “MATCHES DATABASE” .

[TheDoc]

/** MySQL hostname */

define('DB_HOST', 'localhost');

Your host might not use ‘localhost’ for this parameter.

[Day_Robbie]

YOU WERE ABSOLUTELY RIGHT! I went and found that Fatcow uses AcctUsername.fatcowmysql.com and not “localhost”. Everything is up and running now… You solved a problem I’ve been working on for way too long! Thank you very much TheDoc!

[TheDoc]

No problemo!

[Author]

Posts