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

[GleamPlay.com]

After changing, do I upload the Settings back to old host, and download the Database information from phpmyadmin, and upload to new host?

[GleamPlay.com]

Is moving the smf to another host a really complicated thing or did I just messed up the whole thing ?

[Kindred]

change them on the NEW site....

[GleamPlay.com]

sorry, but I don't really understand

this is my understanding, is it correct or:
1) Download all files from old site and upload to new site
2) Change the Setting.php
3) How about the database? What I need to do?
4) Is it complete in Step 4?

my english is not really good, sorry for misunderstanding

[Kindred]

1) download all files froim old site
2) upload all files to new site
3) export/download database from old site
4) import/upload database to new site
5) find out values for settings on new site (database name, username, password, and host and also the path to files)
6) Change Settings.php with those values (on the new site)
7) Run repair_settings.php to correct thigns like themes directories, etc
check any mods which you have which may also specify directories/paths (media gallery, downloads, mod, etc)

[GleamPlay.com]

thanks,
but in step 3(download) and 4(upload), I faced difficulties.

I don't know if my download step or upload step is wrong, probably the download step.

it shows

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'

[Kindred]

I thought we alreayd covered that....

on your new host
create a database using the standard hosting tools.
Go into phpmyadmin
select "import"
choose the previously acquires export file of your old database

[GleamPlay.com]

yes, but on my new host phpmyadmin, when I import the database from old host, it shows that error


also, when I am dowqnloading the database, I followed the steps mentioned in http://wiki.simplemachines.org/smf/Backup
and I am struck in step 9( Under "View dump (schema) of database", you'll see "Export". )

I can't find the word View dump (schema) of database

[Illori]

if your sql file has a line like

Code Select Expand

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

remove it, your new server can not create that database.

[GleamPlay.com]

after removing it, it says
#1044 - Access denied for user 'u416690382_user'@'localhost' to database '1435449_string'

[Storman™]

Similar to what I said above, have granted user 'u416690382_user' access to the 1435449 database ?

Go into cPanel and the database section.

Click on "MySQL Databases".

Scroll down and find "Add User To Database".

Under user you want u416690382_user and under database you want 1435449 from the dropdowns. Select them and then click "Add". Now you need the give that user PRIVILEGES. Select ALL PRIVILEGES for now and click "Make Changes" to save.

Now go back and try importing the SQL file again ...

[Illori]

that will only work if that user exists on the server, i have a feeling that is left over from the old host. how exactly was the database backup done?

[Kindred]

It is sounding like the user used some sort of backup from the host rather than the export function in phpmyadmin.... Since export does not take the database name or user....

[GleamPlay.com]

so I messed up the whole thing...?

[Sir Osis of Liver]

Is your forum still running on the old host?

[GleamPlay.com]

my old forum is gleam.co.nf
my new is gleam.cu.cc

[I did nothing to the old forum]
[my new forum is empty]

[GleamPlay.com]

I cannot find Add User To Database and my page MySQL Databases is very short, cannot scroll

[GleamPlay.com]

It is sounding like the user used some sort of backup from the host rather than the export function in phpmyadmin.... Since export does not take the database name or user....

I used the export in Phpmyadmin 3

[Sir Osis of Liver]

New forum appears to be running correctly with scratch database.  You need to export your old database from old host using phpmyadmin, then import it to your new db on new host using same.  phpmyadmin is accessed via your host control panel in the MySql database section.  As long as you haven't trashed the db on your old host, you're ok.

[GleamPlay.com]

I used phpmyadmin, and the errors I mentioned appearred