Moving Server

[URPG]

I just did upgrade to RC2 and move server. This instruction is still working well. Thanks for the clear instructions!

I upgraded to RC2, then backuped my files and database. Uploaded files and database to new server, used the repair_settings and everything seems fine

[L.G.S]

I cannot seem to find help elsewhere so I will ask here.

I recently changed hosts but kept domain.

- I downloaded my SMF mysql database backup and uploaded it to CPANEL on my new host.

- I upload all my current SMF files to the new host, including a post backup (makde with create_backup.php) and restore_settings.php

- I went to my forum, where I get this message: Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.


I also tried making a new database, installing a new forum, and uploading the posts but nothing happened.

[DeeJay Bet]

hey people... alredy posted here about moving my forum but ive moved it so many times da past few weeks and this should be the last time now if somebody could tell me which files n folders need to be writable.. many are set to 755 but the code i have to use now is 777.. please can someone list me files and folders to be writable?

[URPG]

@Outsider:
Did you upload your Database too? Into a Database of the same Name and Password? check your SMF settings... It should work too if you make a new installation, then upload your old database backup via phpMyAdmin tool

[Fizzy]

many are set to 755 but the code i have to use now is 777.. please can someone list me files and folders to be writable?

Installation guide clarification

[L.G.S]

Urpg, I uploaded my databse yes, but with the CPANEL databse backup, as in PHPMYADMIN I cannot find an import tool, only export

[Stuart]

I've been trying to actually move my forum to another server. As I couldn't figure out how to get the restore_backup.php working properly I tried to move parts. Everything has been moved but I cannot get the messages uploaded as this is about 12 MB. If I try to make chunks of about 2 MB each I get loads of errors. I guess I'm not correctly breaking it into parts, but how do I know I do this in the right way ?

Cheers,
Stuart

[L.G.S]

Please can somebody help me, I really need this

[URPG]

@Outsider
Sorry, i am not an expert and i check in here at most once a day. The Control Panel does only *export* your Database. Click SQL button in phpmyadmin (the one to the left between Exit and ?) then click import files. Select your Database. Click Go.

[L.G.S]

Thanks for showing me where, but I tried this and nothing seems to have happened

[Stuart]

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.

How do I actually split the file correctly ? I just don't get it 

[Aaron]

Each "INSERT INTO" represents an instruction.

1. Open two editor windows, for example 2x Notepad.
2. Open your file with the large amount of queries.
3. Select all text until line X
4. Cut this text
5. Paste it in the other editor, save that to a new SQL file. Then open a blank document.
6. Go back to the large file (which is now a bit smaller, of course), and repeat from step 3 until you're done.

Hope this helps,
Aaron.

[pure]

Forum version: SMF 1.0.5
mysql 4.1

just changed servers but not domain
mirred everything
board worked fine under mysql 4.0

now forum loads fine but cant post or reply
i get "The board you specified doesn't exist" error message

also if i click on an individual "last post" headline
i get
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'new' at line 11"

some dective work reveals that when i watch the url at the botom of the browser
the board topic is ...1.0
but the new topic link is ...1.0.0

what went wrong and how to fix?
repair_settings didn't fix it
thank you

[Nitro]

wouldn't be just easy to backup database and upload it to new location, then... make a new installation of SMF RC2? can i just copy and past the settings files, attachments?

let me know what you think.

[MacGig]

I dont see a dump db feature in smf?

this help file looks great. how to I restore a database if my server dont my myphpadmin?

[Stuart]

Each "INSERT INTO" represents an instruction.

1. Open two editor windows, for example 2x Notepad.
2. Open your file with the large amount of queries.
3. Select all text until line X
4. Cut this text
5. Paste it in the other editor, save that to a new SQL file. Then open a blank document.
6. Go back to the large file (which is now a bit smaller, of course), and repeat from step 3 until you're done.

Hope this helps,
Aaron.

Thanks Aaron, your instructions were very helpfull. At first I thought it didn't work, as I forgot to change the , into an ; at the end of each line (post). I also forgot to put:

INSERT INTO `smf_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, `posterTime`, `ID_MEMBER`, `subject`, `posterName`, `posterEmail`, `posterIP`, `smileysEnabled`, `modifiedTime`, `modifiedName`, `body`, `icon`) VALUES

before the (first) postnumber of the 2nd, 3rd and so on part.
Again, many thanks, as I was able to actually backup and move my forum completely 

[Tamaralas]

My host recently migrated my account to a new server.  I was unprepared and now can't even get in.  Whenever I try to access SMF, I get an email that reads:

There has been a problem with the database!
MySQL reported:



That's all it says.  There's nothing after the :

Anyway, what can I do to fix it?  If you can help, please tell me in baby steps and regular English as I'm no genius with this stuff - obviously.

Thanks.

[RedRum]

Thanks for the tips.  I've also found that backing up and restoring the database on the command line goes off much easier.  The commands look like this:

To backup a database: mysqldump -u(db user) -p(password) (forum database name) > filename

To restore a database:  mysqldump -u(db user) -p(password) (forum database name) < filename

[Lhogan]

I just switched from one server to another and did the following:

• backed up the database from the forum admin page.
• backed up all the files on my desktop via ftpx.
• used phpMyAdmin on the new host and imported the .sql file with no errors.
• uploaded all files to the new server via ftpx.
• downloaded the repair_settings.php file and uploaded it to my server.
• typed in the path to repair_settings.php and put in all my info

When I click Save Settings it pops up and says "Hacking Attempt".
I had no idea I could hack my own server. lol

All the database info is correct and I am pretty stumped. If someone could give me some advice that would be awesome.

[Epimetheus]

I just moved from my linux box at home to a permanent location on a foreign server off my lan. My attachments directory is correctly set, but whenever I go into the admin panel and look at it, it shows it in bold red, as though there's an error. (The error log appears to be devoid of anything relating to this).

Naturally, no attachments show up, nor avatars.

Edit: SMF1.1 RC1