Uncooperative Database Of Software...

[Mish]

I recently upgraded to a reseller account, and am attempting to restore a SMF forum (most recent version) on one of the subdomains of one of the domains that has already propogated.

 

And I am REALLY trying to avoid a clean install as if I ever have a problem in the future when the forum is much more busy, I don't want to start from scratch.

 

I tried uploading the backup of the database from the old host; will not connect.

 

I tried creating a new database with the same name (after deleting the old one of course) and importing the information into the database.

 

But the error that is not changing is that it is not connecting. I even downloaded a repair settings file from simplemachines.org and it tells me: "Some settings are not being shown because the MySQL connection information is incorrect."

 

When I try to access the forum itself I get this: "Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

 

I am copying/pasting the the username of the database as well as the database name itself to make sure I am not making a typo.

 

I even went into the PHP files themselves and tried editing the information there as well (again, making sure to use copy and paste).

 

And I am not trying to use the subdomain address...I am attempting to use the directory address, which will still work once the subdomain starts working anyway.

 

Any ideas, or should I go bug SMF support?

[TCH-Bruce]

When you create a database you need to use these settings to connect to it.

 

host = localhost

bdname = cpanelusername_databasename

dbuser = cpanelusername_db-username-you-create

dbpass = password-you-created-for-dbuser

 

Since you are bringing the forum from another host or domain you need to do this.

[Mish]

When you create a database you need to use these settings to connect to it.

 

host = localhost

bdname = cpanelusername_databasename

dbuser = cpanelusername_db-username-you-create <-- you must create a user and add it to the database

dbpass = password-you-created-for-dbuser

 

Since you are bringing the forum from another host or domain you need to do this.

 

That's what I've done, even copied/pasted what cPanel gave me since it renamed stuff slightly...or should I NOT stick with the slightly renamed stuff?

 

For example; with the dbuser I input one thing; say, 'thingy123' for 'domain.com' and after creation it's 'wwwdoma_thingy1'. And if I name the database 'mishmosh123' it ends up being 'wwwdoma_mishmosh123'.

 

I didn't change the name of the database at all from my backup...it looks like cPanel is? Or does it just look like it?

[TCH-Thomas]

Lets assume your cpanel username is example, database user name is thingy123, database name is mishmosh123, it should look like this:

 

host = localhost

dbname = example_mishmosh123

dbuser = example_thingy123

dbpass = password you created for thingy123

 

If I understand this correct, you are trying to restore a database backup?

If so, please upload the backup to the server and ask the techs to restore it.

If it then becomes renamed, ask the techs to look in to it and they will figure out why this happens.

[Mish]

I'm gonna open a ticket to support, I still can't get it to work. I wish I knew what I was messing up.

[Mish]

I'm gonna open a ticket to support, I still can't get it to work. I wish I knew what I was messing up.

 

Just a note to let you know I figured it out and that I should not try and do too much webpage stuff after work and before dinner.

 

Why? I was CREATING the database user but not ADDING the user to the database. And right as I figured it out, in pops into my inbox an email from support. D'oh! I kindly let them know I figured it out...I was afraid that as soon as I gave up and submitted a ticket, I would figure it out. Story of my life!

 

...I should go eat dinner.

[TCH-Bruce]

Yep, and I asked you if you added the user to the database.

 

When you create a database you need to use these settings to connect to it.

 

host = localhost

bdname = cpanelusername_databasename

dbuser = cpanelusername_db-username-you-create

dbpass = password-you-created-for-dbuser

[Mish]

Sorry Bruce, my brain was NOT interpeting ANYTHING correctly last night. I read every word you said, looked in my MYSQL section of my cPanel, and thought, 'Yeah, I did add to the database!' when I in fact did not.

 

What's amazing is that I installed SMF two or three times sucessfully elsewhere with no such problem - one of the times on bravenet's excuse for website administration - but I managed to forget this time.

 

I'm sorry, I never claimed I was running on all thrusters...but I'm not afraid to admit when I'm a dummy.

[TCH-Bruce]

You are not a dummy, it's happened to all of us at one time or another.

[TCH-Thomas]

I´m glad you figured out what was wrong.