Moving Server

[heavyccasey]

•   You now need to import the database back into the new server. To do this you will need phpMyAdmin installed on the server, this is often installed for you and is part of cPanel if you have this installed. If using cPanel this can normally be found under "MySQL Databases" then scroll to the bottom and find a link to "phpMyAdmin". From phpMyAdmin select Import and then select browse and browse to the .SQL file you download earlier. Hit OK and the import will begin. Note that on large databases this process may time out. If this is the case open up the .SQL file in an editor and split it up into smaller chunks of around 2MB each. The only thing you must be aware of is that the file must be split at ends of lines (do not split at a part line). In addition if you need to split the file ensure that you import each split file in the correct order.

There should be an automatic file splitter. (My database is 130 MB.)

[eronkid]

this is very helpful... thank u

[dragon042]

Thank you!!! This article saved me a LOT of trouble and cleared up a lot of headaches!

Thank you for writing this up!

[KolaKube]

Hi, just been pointed over to this thread to help me move my SMF forum.

Im stuck on step 2 "  Download all the files from your current forum folder onto your computer (using an FTP client)."

Where is my current forum folder?  I originally took advantage of the chartered member offer where SMF was installed for me to share my joomla site database if I remember correctly.

I don't need the Joomla site anymore and now want to copy this site to an SMF only (no joomla) forum site.

Hope this info helps me get the answer I need as I really haven't a clue what Im doing here.

[babjusi]

Hi, just been pointed over to this thread to help me move my SMF forum.

Im stuck on step 2 "  Download all the files from your current forum folder onto your computer (using an FTP client)."

Where is my current forum folder? 

Your current forum folder is whatever folder your smf files are uploaded. i.e. if your forum urs is www.yoursite.com/forum-path/ then the name of the ''forum-path'' is the folder you need. Does it make any sense to you?

[KolaKube]

Hi babjusi, yes it makes sense mate.

My forum is http://www.1stkontact-lanevents.co.uk/smf-forum/ [nofollow]

So, your saying anything related to SMF in the smf-forums folder.

I used cuteFTP to access this folder and it says its only 4k in size? Is this correct?  We have over 8000 posts?

[babjusi]

Yes, all your smf files are in that folder, ''smf-forums''. Now, are you switching hosts or you want to have your forum at the root directory, i.e. http://www.1stkontact-lanevents.co.uk instead of the current url: http://www.1stkontact-lanevents.co.uk/smf-forum/

[KolaKube]

Sorry for late reply babjusi.  Working last night and just got up after it.

I want to copy my forum from here http://www.1stkontact-lanevents.co.uk/smf-forum/ [nofollow]

and make an exact copy here
www.1stkreative.com


I have allready installed SMF with fantastico on 1stKreative.  Should I delete this install?

[greyknight17]

You will need to backup your database and then import it to the new server.

Migrate the SMF files over to the new server via CuteFTP (copy everything from the SMF folder on your old server and copy it to the new one).

Then use repair_settings.php and make sure that the database information is correct. Then click on the Recommended values. Save the changes. That should restore your forum back to working order. Delete the repair_settings.php file once you are done.

[KolaKube]

Hello greyknite

Do I need to import the database over to the new site first or after I have cute FTP'd the stuff there?

Also, does this need to be done to a clean directory or one with SMF allready set up?

[babjusi]

Hello greyknite

Do I need to import the database over to the new site first or after I have cute FTP'd the stuff there?

Also, does this need to be done to a clean directory or one with SMF allready set up?

Have a look at the very first post on this topic, and you will find the answers to your questions there

[KolaKube]

doh!  Never thought of that.

Can I just clarify my SMF folder is only 4k in size??  This seems very small for an 8000 post forum?

[babjusi]

Yes, that seems kinda odd

[KolaKube]

4k isn't even a word doc. 

Im wondering I think my SMF forum shares its database with my Joomla website (or at least I think this is how it was set up via the SMF customer support team)  Would this mean my posts are else where?

[babjusi]

4k isn't even a word doc. 

Would this mean my posts are else where?

No, they should be at the same database that you used while installing smf. Anyway go to the phpmyadmin and make a backup of your database and see if everything appears as it should there. And how mb is your backup file btw?

[KolaKube]

5.5mb

[KolaKube]

OK, on trying to upload the file 'kolahost' with PHPadmin I saved via following the SQL dump tutorial.

I get this error

Error

SQL query:

--
-- Database: `le_joom1`
--
CREATE DATABASE `le_joom1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'kreative'@'localhost' to database 'le_joom1'

I understand I need to grant something permission but can you explain what or who and how I go about doing it? 

Id be most greatful.

[Dannii]

after following the steps above to importing the database, I get a message #1046 - No database selected .  Do I need to create a database before doing the import? or what?

[metallica48423]

if the dump doesn't have a create database line in it, then yes, you will need to create it first