Moving my SMF Database to new host, help!!!

[GleamPlay.com]

Hi, I am trying to move my whole website/forum to another host. From biz.nf to neq3.com.
I downloaded the public_html and uploaded it.
Then I download the database and upload to another host, but it says my MySQL database name and username is different and don't work.
What should I do?

[kat]

Change them, so they work?

Sorry, if that seems a bit flippant. But, this isn't, really, a problem with SMF.

You know the database name and the password. We don't.

You could try this:

http://wiki.simplemachines.org/smf/Repair_settings.php

But, if you don't know the correct password, there's absolutely nothing that we can do, to help, I'm afraid.

[GleamPlay.com]

I know the password and username.
The username for my old database is uXXXXXX_string [X represent a number]
and the username for my new 1 is XXXXX_string
I don't think they allow me to change the front numbers 

what does repair_settings do? I read that wiki, but I don't really understand, does it help to change username and password?

[kat]

If you know what they are/should be, yeah. Give it a go and see how you get on.

[GleamPlay.com]

but I don't think I can change the database username

also, what will repair do?

how can I move my database to new host?

[emanuele]

You don't have to change the database name and password of the *database*.
You have to pick the new database name, username and password and change them in the SMF's configuration.

[GleamPlay.com]

it says:

CREATE DATABASE  `1435448_string` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation

#1044 - Access denied for user 'u416690382_user'@'localhost' to database '1435448_string'

[Storman™]

Do you have a control panel for your hosting like cPanel ?

If so then I think you need to grant yourself access to that database which you can do in your hosting control panel.

[GleamPlay.com]

i have cPanel, but how to grant?

[emanuele]

it says:

CREATE DATABASE  `1435448_string` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation

#1044 - Access denied for user 'u416690382_user'@'localhost' to database '1435448_string'

According to your post above, 'u416690382_user' is the username of your *old* database, so you have not yet changed the username in Settings.php using repair_settings.php.

[GleamPlay.com]

I downloaded repair_settings and uploaded it to my old host.
I changed the username, database name and password, anything else I need to change?

After changing, what should I do?

[GleamPlay.com]

my repair_settings.php shows:
Fatal error: Call to undefined function db_fatal_error() in /srv/disk2/1435449/www/gleam.co.nf/Sources/Subs-Db-mysql.php on line 106

did I break the forum 

[emanuele]

how to use repair_settings?

Reading this:

You could try this:

http://wiki.simplemachines.org/smf/Repair_settings.php

my repair_settings.php shows:
Fatal error: Call to undefined function db_fatal_error() in /srv/disk2/1435449/www/gleam.co.nf/Sources/Subs-Db-mysql.php on line 106

did I break the forum 

At least now the password is correct.

When do you get this error?
Just loading repair_settings page?
Or when you save?

[GleamPlay.com]

Nevermind, the are no more problems now.

Do I need to change MySQL Database Info only, or MySQL Database Info and Paths & URLs?

[GleamPlay.com]

I get this error every time I press Save Settings

[kat]

"This error" being...?

[emanuele]

You have to change *any* field that has changed during your host transfer, so, off the top of my head:
* mysql user
* database name
* database password
* board path
* sources path
* themes paths
* attachments paths

[GleamPlay.com]

but everytime I press Save Settings, it says
Fatal error: Call to undefined function db_fatal_error() in /srv/disk2/1435449/www/gleam.co.nf/Sources/Subs-Db-mysql.php on line 106

do I need to upload the Subs-Db-mysql.php again or?

[emanuele]

Then open your ftp account (or use the file manager of your host), open Settings.php and manually change the paths with the new ones...
Which those are...I think your host should be able to tell you (probably even from within the administration panel, cpanel or alike).

[GleamPlay.com]

I change the Settings in my old forum(many things there) or new forum(empty)?

So I don't need to use repair anymore?

Thanks emanuele