Moving Server

[JayBachatero]

Did that fix the issue?

[blez]

nope

[JayBachatero]

Can you post a link to your phpinfo.php?  It might be host related.
What is phpinfo.php?.

Can you please make a fresh install of SMF in another dir and check if you can upload files.

[blez]

It shoulb be the host. I tried another forum aon a different adress but the same thing you know blabla.atw.hu [nofollow] and the attachment wont work there too.

Is it possible too save the attachemnts to the old host?

[JayBachatero]

You mean host the attachments on another server?  It can be done most likely but not sure how.  My suggestion us that you look for a better host.  That frame they put is very annoying.

[michaelper22]

Here is a little document I wrote to assist people who are moving their installation from one server to another. Simply follow the steps below for an easy, stress free move!

•   Put your current forum installation into maintenance mode (forum settings -> Maintenance mode).
•   Download all the files from your current forum folder onto your computer (using an FTP client).
•   Using with the dump database feature of SMF or phpMyAdmin export the contents of your forum database. (In SMF go Admin menu -> Forum Maintenance -> Dump Database -> Dump all). This should save the ENTIRE database of your forum onto a .SQL file on your computer.
•   You are now ready to upload the contents of the directory on your computer to the new server. Upload the complete contents of the directory to the new server.
•   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.
•   Great! Now you should have the files on the new server and the database imported. However, if you browse to your forum URL you'll notice it doesn't work! This is where the paths recorded in SMF need to be fixed. To do this we have created a nice file called repair_settings.php which can be found in the download section under "Converters and Tools". To use this just upload it to your new forum folder and run it from the browser window by going to: www.yourforum.com/repair_settings.php. After running this file ensure you delete the file off the server to stop others from running it!
•   You should now find everything is working correctly as it was before! If you need to change the web address of the forum (for example moving domain names) ensure you edit Settings.php before you re-upload the files and change $boardurl to point to the URL of the new location.

Thank you for this post, it helped me move my SMF installation from my local machine (with XAMPP running) to my web host's server. I exported the database using the local phpMyAdmin, and when I imported it, it gave me all sots of parser errors. After I read the bullet on exporting it using the Forum Maitainence screen, I immediately did that, and low and behold it worked. Thanks again.

[maviarab]

ok ive spent waaay to long trying to fugure this out

Followed grudges instructions but got stuck on the db import.

installed new forum on new server...and tried to import backed up db...still no luck.

new server is with 1&1 ( think they great company before we start the convo again lol) and using uploaded phpmyadmin does not work...i get error msgs.

if i use phpmyadmin throught the control panel...then click query sql..then import...it appears to do nothing. If i click on the import table section it again appears to do nothing.

i finally found restore_backup.php and thought this was my answer...all went well until i recieved this error msg:-


Some of the queries were not executed properly. Technical information about the queries:
Line #4946: Invalid default value for 'logTime'
Line #4963: Table 'db165546601.smfdiggirl3_log_online' doesn't exist

Restoration process complete!
Congratulations! Your database backup has been restored successfully.

Attempt to fix the database's paths for this server.

Upon going back into my forum there is stil no change

Could someone pls explain to me in obviosuly what i need to be laymans terms  how i get the important stuff from my hard drive upto the new installed forum?

I am using 1.0.7 on both forums.

Any help be appreciated...

Thx in advance.

[maviarab]

so i guess no one can or wants to help then?

[JayBachatero]

Try using bigdump.php.
http://www.hotscripts.com/Detailed/20922.html

[maviarab]

Thx..before i try that though..maybe this wil help you also.

I started again...uploaded the old forum files to the new server...created new db...managed to get the old db imported , ran repair_setings.php...ammended the paths etc...and then tried the forum url...i then got this error

Table 'db166154744.smfdiggirl3_settings' doesn't exist

Any thoughts?

[JayBachatero]

Seems like your backup wasn't complete.  Export the settings table and import it to the new database.

[maviarab]

problem solved

was the prefix on the db causing me the problems with 1&1, they obviously dodnt like it.

soon as was removed the foum sorta came back..more fiddling around changing settings etc and ive got her back up and ship shape.

Thx all for help

[phishinfool]

Ive been trying everything I have read here and I still get nothing. 

im moving my current forum to godaddy, has anyone figured out how to install this on godaddy?

i had it to work for 20 minutes then it blipped out from a fresh upload, then deleted everything and gave up.

Now I uploaded a fresh install of SMF and cant get the install.php to work.
just going to have to start over since i cant get the old forum moved over being untrained and unsuccessful at the move.

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

[JayBachatero]

In GoDaddy the host has to be the IP that they give you not localhost.

[phishinfool]

i did that too. still get errors.

I get a syntax error also when uploading the old forum database file through MySQL also.

[JayBachatero]

what error do you get?

[phishinfool]

some syntax type error, I will try uploading the forum .sql file again and get back to you with the error when i go into the MySQL.

[phishinfool]

i have done both pages of these directions on moving my forum step by step.

both using ftp through internet exploder and using coffee free ftp.

i uploaded the complete_smf_Sql file

Ran the repair_settings.php

did everything step by step and all i get is this

http://washingtonfishingfools.com/forums/

the database name is smf7 not phishisgroovin also.

Found out the FTP program only uploaded the folders, not the files within them.
so I just uploaded everything folder by folder and ran the repair setings & now i get smf cannot connect to the server.

i have my forum installed on mysql***.secureserver.net and hit all the suggested links in repair settings and still nothing.

EDIT: ok, now when i hit my forums addy. all I get is an error and an email saying:
There has been a problem with the database!
MySQL reported:
Table 'smf7.smf_settings' doesn't exist

This is a notice email to let you know that SMF could not connect to the database, contact your
host if this continues.

[phishinfool]

Why does this stuff have to be such a pain in the rear.

Heres the directory paths godaddy's crappy support gave me. I have a year already paid to these guys and I need to use it instead of the crashing all the time evolutionhostinguk.com (JTM Computers.com). I just want to get this running and dump JTM.

----------

MySQL Server Database Connection Settings

Description:


This example describes using PHP to connect to a MySQL Database on a Linux hosting account.

<?php
//Connect To Database
$hostname="mysql127.secureserver.net";
$username="smf7";
$password="your_password";
$dbname="smf7";
$usertable="your_tablename";
$yourfield = "your_field";

mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to database! Please try again later.");
mysql_select_db($dbname);

$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result) {
    while($row = mysql_fetch_array($result)){
        $name = $row["$yourfield"];
        echo "Name: ".$name;
    }
}
?> 

[phishinfool]

i give up.