Moving Server

[FTF]

Sorry guys,

I keep working on this as it time goes on and seem to have got a bit further!

I can now get the main forum body, at www.farmtoysforum.com

But now there are no posts or member lists?

How do I get these returned?

Thanks

[FTF]

I figured out that the last post was due to a faulty database download as all of the entries were empty hence no members.posts etc showing up.

I now am using xtdump to get a copy of my forum database on to my hard drive as the smf backup_database keeps timing out.

All together my total data base in .sql format is around 26mb and in sq.gz its just over 4mb.

Attempting to upload the whole databse at once results in time out so I am now copying each forum table one by one and uploading.

However....

The larger tables with many entries are still timing out, for instance, I can upload smf_attatchments, smf_banned and smf_boards with not problem but when I try to upload smf_permissions, it just keeps timing out.

The file is only around 40kb as a .sql.gz and 900kb as a .sql.

I tried to get around the problem by editing the file as a .sql into smaller chunks so 450kb sections.

But as this is one table, when I got round to uploading the second half it came up with an error.

I then added the commands

drop table etcc to the top of the second half of the file and it worked, but Im assuming this would now overwrite the first half???

This problem of timing out is affecting me on all the large smf tables so is there a general solution to this or is there a way to split the files/tables into chunks so they dont overwrite?

Really need help on this guys!

Many thanks

Andy

[ShannaraAK]

First, I want to apologize if this have been already answered ... Second, I have an issue I want to move my forums from one domain to another. However, I want to keep the database. In other words, I have the database on a particular server with the forum data. Im able to keep that database and everything, but only need to move the forum .. how would I go about doing that, and have the forum point to the already existing database and data?

[Juggler]

Attachments and Avatars.

Just read through the thread but can't spot an answer for my problem. I've moved the contents of the attachments directory into the new one, check the paths so that it's pointing to the right dir. Now when I check the Avatars and Attachments in the admin area the correct names show up but when I click the link all I get is a 404 not found error.

Any thoughts?

[dreamcloud]

I cant find the link to where it says import 

[Juggler]

That looks like you haven't selected the database on the left handside of the window you've screen grabbed. From quickly looking at it that looks like the screen for setting up a new database and until you either set up a new DB or select the one you want to import into you won't have the option.

[dreamcloud]

Ok i got everything to import and forums are working at last but.. since i moved servers and now imported the database i found that the passwords for everyone had been deleted or something. so now everyone has to click forgoten pass to reset theirs :\. Any idea why this has happened or how to fix it?

[[Unknown]]

Juggler, are you still having your problems?  Anything in your error log?

Dreamcloud, what version of SMF are you using?  A server move should not affect passwords in any way, unless you converted from another software previously - did you?

-[Unknown]

[Juggler]

No actual solution as yet. I've decided that as there are not that many attachments (about 100) I'll edit the files and re-upload them as I come across the attachments.

I have posted in another thread about the next issue but I may as well drop it here but all my PM's got screwed in the move. What I found is that the SMF 1.0.5 DB stores them in smf_instant_messages where as 1.1.3 stores them in smf_personal_messages. A simple rename doesn't work (tried that) and the table structure isn't exactly identical. I also noticed that the same thing applies to smf_im_recipients and smf_pm_recipients. So I need to figure out how I transfer the info from the 1.0.5 DB structure into the 1.1.3 structure.

[Stuart]

A couple of days ago I moved my forum to another server.
Basically it all works just fine, though I haven't been able to move a part, which is called: 'INSERT INTO `smf_sessions`

I'm not quite sure if this is a serious problem. The forum seems to work just fine and I'm not having any errors either.

It would be appreciated if someone can actually tell me if it is important that I keep on trying to move that part or that I can just leave it as is and carry one with my forum on my new server.

Cheers,
Stu (Holland)

[septaria]

hello after the server move, it seems that the smileys aren't showing up anymore, the path to it is correct, I checked the folder and saw that the weight of it was 0Ko so I deleted it and uploaded a new folder with the smileys and still got the problem can someone please help me?

[CSPowerhouse]

I was trying to move my forum to another server, but after I restored the whole database on my new server nothing was working right. So I have done a new install and now I want to restore just parts of the database, like the members and boards. I only want those parts of the database restored. How do I go about doing that? Any help on this matter would be great. Thanks for your time

[rojamaia]

thanks for this tutorial! this sure would make things easier


however, i have another question.  if i would use the upgrade.php, would it not disturb the mods that i have installed into my forums?

[xenovanis]

thanks for this tutorial! this sure would make things easier

however, i have another question.  if i would use the upgrade.php, would it not disturb the mods that i have installed into my forums?

There is no need to run upgrade.php if you move servers.

[leen]

It being?

[Motorhead]

I notice further back "meitzi" gave instructions for using the SHELL to move file/folders from server to server...

Being a total newbie to shell I followed the instruction on a server I knew I had shell access to..

they didn't quite work how "meitzi" said for me

he said use tar -gcvf forum.tar.gz forum   where forum is the folder you want to tar

I found this didn't work but tar -cf forum.tar.gz forum did

I found this site which explains ssh pretty well

http://www.webmasterstop.com/61.html

I'm sure "meitzi" way is right but I'm totally new to shell so I guess its me... but the way at the site Ive linked did work form me and I managed to move a folder very quickly

[Motorhead]

Hit a snag, seems my existing host is Windows and I've been told tar wont work...the admin of my exisiting host tells me I can ftp through my linux shell on my new host from the windows server to the linux server..

I've managed to use the "putty" ssh client to let me connect via ftp to my existing host (windows) and can look in folders and even transfer via get & mget commands from that server to my new linux server...

Now the question is there a way of moving whole folders including sub folders..??

mget will move the contents but still a fairly long winded way, having to go into each folder including sub folder to move the contents ??

I'm very new to using straight commands but if its possible with examples I seem to be managing

[Cypher7]

Unfortunatly I have to move to a new server and new domain name...  I'm not worried about moving, I can (hopefully) handle that.

What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.

When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...

Do I have to do that again or can you think of a better way!?

Any input appreciated...!

[xenovanis]

Unfortunatly I have to move to a new server and new domain name...  I'm not worried about moving, I can (hopefully) handle that.

What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.

When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...

Do I have to do that again or can you think of a better way!?

Any input appreciated...!

repair_settings will handle that.

What is repair_settings.php?

[Elissen]

Unfortunatly I have to move to a new server and new domain name...  I'm not worried about moving, I can (hopefully) handle that.

What I'm worried about is if and when I do move... all links to the forum, and links within my boards to different topics will not work as they will have the old domain link.

When I upgraded from Yabb I remember I changed the main yabb .cgi file to be a redirect file, but kept the file name the same, so if anyone visits from an old link (no mater what action is after the filename) will be redirected, which worked...

Do I have to do that again or can you think of a better way!?

Any input appreciated...!

I moved a board once to a different domain and to preserve all links I used phpMyAdmin to replace the old domain name by the new one in the body of all the messages.

UPDATE smf_messages
SET body = REPLACE(body, 'www.olddomain.com', 'www.newdomain.com');

Be sure to test this first though! (and backups of course). And remember that it will change things you might not want it to change (like the topic announcing moving domain ).

Still, putting a dummy index.php at the old location that does a nice HTTP-redirect with the proper response codes (permanently moved?) to the new site is still something you want. Think of search engines and other sites that link to you.

header("Location: http://www.newdomain.com$_SERVER[REQUEST_URI]"); might do the trick