Moving Server

[KG4ONJ]

I am having trouble after a server move.  I copied all the files from one server to the other, downloaded the dbase, imported it onto the new server and ran repair_settings.  When I go to the URL for the forum (www.sullivaneastalumni.com/1993/forum) I get this error page:

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

When I run repair_settings I get this error in red at the top of the page:

"Some settings are not being shown because the MySQL connection information is incorrect."

Furthermore, I only have three paths at the bottom:
Forum URL
Forum Directory
Sources Directory

I figure that either my paths are screwed up or that I imported the database improperly.  Any suggestions?  I'm using v. 1.0.5

Thanks!

Either you username, password, or database name is wrong.  Use repair_settings to fix that.

OK.. I have re-checked my username/password but I am using the setting that "repair_settings" suggests.  Is there something that I'm missing?  Where would I find my correct username and password info?

Thanks in advance for any help!

[heplo]

Where can i get repairsettings.php?? I did not find it in downloadpage...

Plz help me fast.

[xenovanis]

Where can i get repairsettings.php?? I did not find it in downloadpage...

Plz help me fast.

http://www.simplemachines.org/download.php/repair_settings.php

[heplo]

http://nipanet.worldfreeweb.com:2082/frontend/x/files/showfile.html?dir=/home/nipanet/public_html/heplo&file=repair_settings.php [nofollow]

When i go to repairsettings.php i got these text. Can anyonne help me??


Edit: Should I run the repairpaths.php?? But I get this error message http://nipanet.worldfreeweb.com:2082/frontend/x/files/showfile.html?dir=/home/nipanet/public_html/heplo&file=repair_paths.php [nofollow]
I have tried to chmod both files.

[xenovanis]

What text? How are you trying to run repair_settings? All you need to do is upload it to your forumlocation and run it from there: http://www.yourdomain.com/repair_settings.php.

Please be careful with posting links to this file in a public forum, as it reveals your accountdetails!

[heplo]

What text? How are you trying to run repair_settings? All you need to do is upload it to your forumlocation and run it from there: http://www.yourdomain.com/repair_settings.php.

It does not work...

[Oldiesmann]

When I try it, I get an internal server error message. Make sure that file is chmodded to 755 or higher.

[heplo]

When I try it, I get an internal server error message. Make sure that file is chmodded to 755 or higher.

I have chmodded it to 777...

[Oldiesmann]

It's working for me now, but at the top of the page it says "Some settings are not being shown because the MySQL connection information is incorrect", so you will need to fix that.

[MysticBrewing]

I have a question... not really about moving servers, but moving the forums from one folder to another on the same server... if I simply copy the files over to teh new folder and the run the repair_settings.php file... would that be all that's needed??

[Oldiesmann]

Yes, that's all you'd need to do.

[MysticBrewing]

great...now to make the time to do the move... lol...

[legolas]

I downloaded the backup database via phpmyadmin and transferred it to the new server via bigdump.php. I am getting this error:-

Error at the line 531: ) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=1 ;

Query: CREATE TABLE `smf_banned` ( `ID_BAN` mediumint( unsigned NOT NULL auto_increment, `ban_type` varchar(30) NOT NULL default '', `ip_low1` tinyint(3) unsigned NOT NULL default '0', `ip_high1` tinyint(3) unsigned NOT NULL default '0', `ip_low2` tinyint(3) unsigned NOT NULL default '0', `ip_high2` tinyint(3) unsigned NOT NULL default '0', `ip_low3` tinyint(3) unsigned NOT NULL default '0', `ip_high3` tinyint(3) unsigned NOT NULL default '0', `ip_low4` tinyint(3) unsigned NOT NULL default '0', `ip_high4` tinyint(3) unsigned NOT NULL default '0', `hostname` tinytext NOT NULL, `email_address` tinytext NOT NULL, `ID_MEMBER` mediumint( unsigned NOT NULL default '0', `ban_time` int(10) unsigned NOT NULL default '0', `expire_time` int(10) unsigned default NULL, `restriction_type` varchar(30) NOT NULL default '', `reason` tinytext NOT NULL, `notes` text NOT NULL, PRIMARY KEY (`ID_BAN`) ) ENGINE=MyISAM DEFAULT AUTO_INCREMENT=1 ;

MySQL: 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 'DEFAULT AUTO_INCREMENT=1' at line 21

[Oldiesmann]

I don't know what that DEFAULT is doing in there, but I think that's what it's complaining about. Try editing the .sql file directly on your computer (extract it to your computer then open it in notepad) and removing that DEFAULT, then re-uploading the .sql file...

[Miyuki-chan]

So far I've been able to move all of my smf directory to a new server and I can make it run, however I have been unsuccessful migrating the database. Every time that I've tried it comes out corrupted. It's about 10 megs in size. I've had problems running the export and can only make it work if the yabbse_messages table is not included. In the past I was able to make good SQL dumps with create_backup.php, however the hosting company has enabled php safe mode and create_backup will no longer run for me. (no surprise that I'm moving, huh?) Any help would be appreciated.

[legolas]

I tried using the backup "create_backup.php" & "restore_backup.php", but I get this message:-

Line #1: Query was empty   

BTW I should have mentioned that the original Server had MySQL 4.1.13 installed whereas the server I am shifting to has MySQL 4.0.23 installed.

[Oldiesmann]

Don't know why the create_backup.php and restore_backup.php files wouldn't work, but I'm thinking that the error message you posted earlier could be due to the difference in MySQL versions. MySQL 4.1.13 is newer than 4.0.23, so queries exported from that version might not work properly in MySQL 4.0.23.

[heplo]

When i go to the repair_settings.php I got top of the screen this message:  Some settings are not being shown because the MySQL connection information is incorrect.

The rest of the page is normal, but when i trying to save settings smf do not do that. I did not got any error messeages after that, only the message top of screen:  Some settings are not being shown because the MySQL connection information is incorrect.

Any ideas??

[xenovanis]

Either your

database server
database name
database username
database password

are incorrect.

[heplo]

Either your

database server
database name
database username
database password

are incorrect.

Ok no error anymore and i got more paths to repair, but i cannot save setings, when i click it it oly appears the same settings