Moving Server

[Sir Perigrin]

Nvm, tried it myself. No need to swap out the Settings.php Files, just make sure you Dont Overwrite the Settings Tables in the SQL in the target install. I just took the Non Settings files from old Forum, Downloaded them, Overwrote them onto the New One leaving the Settings Tables Untouched. Just Another Roundabout way for those who prefer not to play with downloading and uploading your entire forum with FTP, Just WebInstall a new forum, Backup old forums Relevant Non Settings Tables, Overwrite new Forums Tables.

[Johny Bravo]

Hi there!

I got a problem exporting my database (SQL) because my forum is in slovak/hungarian language.. where can i set the encoding or something at exporting?

Thanks!

[warhonowicz]

I've just moved my SMF 1.1.2 with TP from one host to another and one domain to another and on the whole it has been a rather painfree affair.

However I have now run into a problem. I am trying to install a new mod and I get a message saying that the file is not writeable. I've gone through the install doc and c'mod all files/folders listed to 777 but it still does not work.

What's the best way to solve this? Upload a fresh copy of SMF over the old one and try to run upgrade.php?

[sawz]

However I have now run into a problem. I am trying to install a new mod and I get a message saying that the file is not writeable. I've gone through the install doc and c'mod all files/folders listed to 777 but it still does not work.

i believe with packages you chmod the Packages folder and a file in that folder called installed.list to 777

[warhonowicz]

They both are set to 777 ... 

[sawz]

They both are set to 777 ... 

i'm just troubleshooting here, but have a look at this thread and see if it helps.

[jrstark]

I am moving from one host to another.  I uploaded all the files, finally got my large database imported, then ran repair_settings.php.  Everything seems to be correct, not getting any "connection problems" error messages from repair_settings.  $boardurl is correct.

I have not yet transferred my dns, so am using the IP numbers for my path.

When I go to the index page I get:
Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Do I need to do something else?

[metallica48423]

did your database information change with the new hosting by chance?

[jrstark]

did your database information change with the new hosting by chance?

$db_server changed (is not localhost), others are correct.  When I make wrong changes with repair_settings.php, I get the error "Some settings are not being shown because the MySQL connection information is incorrect."

I get the no connection problem on the index when repair_settings is not showing that error.

Aside from the MySQL Database Info, everything is recommended value.

[Lostintranslation]

I have an install problem and am still reading through this post...

I have installed a fresh install of SMF (and MKPortal) on my site, they both installed fine.

I have been given a backup.sql file from a previous installation of the same software on a different server.

To restore the backup.sql file I used phpmyadmin. I dropped all the existing tables in the database created from the fresh install, then imported the backup.sql file, which worked ok and made all the tables etc.

Now I get this error message when trying to access my site:

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

Any ideas what to do next?

EDIT: Sorry, I just realised my problem is the exact same as jstark's above, looking forward to any help you can give

[jrstark]

I have an install problem and am still reading through this post...

LIT, I can't remember exactly what was wrong, but I did have a setting off.  Run repair_settings.php and doublecheck all paths and passwords.  If you don't have a whole list of paths, something isn't set right.

Then once you do get it connected, go through all the admin tabs and make sure all of those are correct.  I'm still finding smaller items that didn't transfer correctly.

[bassbass]

Please help, i am importing my database to a new server, and its giving me an option to chose for "Character set of the file", like ASCII, BINARY, utf8, bog5, etc...  which one should i choose?

okay this is the error i am getting,

Error
SQL query:

# ==========================================================
#
# Database dump of tables in `smf_forum1`
# August 02, 2007, 11:49:32 AM
#
# ==========================================================
#
# Dumping data in `smf_ads`
#
INSERT INTO `smf_ads` (

`ADS_ID` ,
`NAME` ,
`CONTENT` ,
`BOARDS` ,
`POSTS` ,
`CATEGORY` ,
`HITS` ,
`TYPE` ,
`show_index` ,
`show_board` ,
`show_threadindex` ,
`show_lastpost` ,
`show_thread` ,
`show_bottom` ,
`show_welcome` ,
`show_topofpage` ,
`show_towerright` ,
`show_towerleft` ,
`show_betweencategories` ,
`show_underchildren`
)


MySQL said: 

#1046 - No database selected

[bassbass]

here is another error i am getting, this time when i backed up my database i selected the table structure as well, and now i am getting this error,

Error
SQL query:

# ==========================================================
#
# Database dump of tables in `smf_forum1`
# August 02, 2007, 12:44:45 PM
#
# ==========================================================
#
# Table structure for table `smf_ads`
#
DROP TABLE IF EXISTS `smf_ads` ;



MySQL said: 

#1046 - No database selected

now i am importing directly from the backup.sql file not the zipped backup.  i am not sure if this makes any difference.

Thanks in advance.

[bassbass]

I am sorry for posting to many times, but i need to note that i have MODS installed, do i need to uninstall the mods before i export the data?

[metallica48423]

did you actually select a database in the left pane to import INTO before you attempted to import?

[Lorraine Simone]

this link doesn't work
www.yourforum.com/repair_settings.php [nofollow]

[metallica48423]

well, no, it wouldn't.  You need to replace yourforum.com with a link to your forum.

[bassbass]

metallica48423 , i think i did, i used the backup from the Admin> Forum Maintenece then dowmload the backup!  am i doing this right?

[metallica48423]

repair_settings won't restore your database.  you'll need to import it in phpmyadmin. (What is phpMyAdmin?)

1.) Login to phpmyadmin
2.) in the left pane, select your database (if its not there, create it, if your server uses cPanel you'll have to create it with cPanel and create a user for it)
3.) click 'import'
4.) select the file to import from

If your database file is too big for the server to handle you may have to use a script such as bigdump (search google)

[babjusi]

If your database file is too big for the server to handle you may have to use a script such as bigdump (search google)

.....or the restore_backup.php tool. Here bassbass will find where to download those files and a description of how to use them

Restore_backup.php tool created by Unknown, which can be found attached this post

Upload the restore_backup.php tool to the same directory where your smf files are,point your browser to it and follow the instructions.

i.e. www.yoursite.com/forum/restore_backup.php

Note that ''forum'' stands for the directory where your smf files are located. If your smf files are located to same other directory, then replace ''forum'' while pointing your browser with the name of that directory.
Or if your smf files are in the root directory, then point your browser to:
www.yoursite.com/restore_backup.php

BigDump: Staggered MySQL Dump Importer