Wordpress/MySQL migration problems

[miovitz]

Hi,

 

First of all, thank you for this service and apologies if this has been asked before (I didn't find anything related to this).

 

My previous webhost went down and I thought about transferring here. I created the account, moved the backup here via FTP and created a MySQL user.

 

However, I couldn't get my old website up and running:

 

I'm getting either "Internal Server Error" or "Error establishing a database connection", so the problem is in the MySQL.

 

This is a screenshot from my wp-config.php:

 

http://i55.tinypic.com/2yy6ttx.png

 

1: Database name

2: Database user

3: Password

4: Database host (the previous was something like "mysql.examplehost.com")

 

I have no idea what to type to the part 4.

 

And even if I knew that, I've heard something about "MySQL root user". What is that and how do I create it? I'm not sure if I need it, but it could be the reason why I can't get my website to work.

 

Thank you for you help!

 

 

 

With Kind Regards,

 

Michael Ovitz

[jje]

Your username and database should be prefixed with your cPanel username then your name. For example, cpanel_test

Your database name is, but your database username is prefixed with miovitz_a6745589_ for some reason, when it should be just a6745589_

 

The hostname should be 'localhost'.

[Wizard]

I believe miovitz is the cPanel username and a6745589 was the username he was assigned with his previous host. Your issue is like jje said, you just have to put in the correct things in config.php and you should be able to use the backup. Create a user and database, upload the backup into that database and then use the user/database you created in config.php.

[miovitz]

Hi,

 

Localhost worked. Thank you very much!

[jje]

Glad your problem got solved.

 

Also, thanks Wizard.