Changed Hosting plan at godaddy, how to get databases back up

[NiceCarvings]

I recently changed from a linux to windows platform at godaddy. I backed up the db's first and reinstated them in the new location, I moved over all my files to the same directory. It looks like I still need to make a few small changes i still need to make.

I think I just need to change this stuff, but I don't know where it's located?

The following is a list of database connection strings to use with various MySQL data providers. Cut and paste the connection string to use within your application. For connection strings that require a password, update the password field to the designated password for the database.

ODBC 3.51:
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=ncforum.db.7085270.hostedresource.com; PORT=3306; DATABASE=ncforum; USER=ncforum; PASSWORD='your password'; OPTION=0;
OLE DB, OleDbConnection (.NET):
Provider=MySQLProv; Data Source=ncforum.db.7085270.hostedresource.com; Initial Catalog=ncforum; User ID=ncforum; Password='your password';
Connector/Net 1.0 (.NET):
Server=ncforum.db.7085270.hostedresource.com; Port=3306; Database=ncforum; Uid=ncforum; Pwd='your password';
For additional information on how to setup your connection string using ASP, please refer to the following help resource references.

Anyone know how I go about making these changes to these strings?

[Hj Ahmad Rasyid Hj Ismail]

Why don't you ask godaddy?

[NiceCarvings]

Why don't you ask godaddy?

wow, nice reply.  I believe these need to be changed somewhere within the installation of my forum, I just don't know where to locate them. The databases are setup and ready at godaddy. Which is why I asked here.

Look at my quote in my original post

The following is a list of database connection strings to use with various MySQL data providers. Cut and paste the connection string to use within your application. For connection strings that require a password, update the password field to the designated password for the database.

ODBC 3.51:
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=ncforum.db.7085270.hostedresource.com; PORT=3306; DATABASE=ncforum; USER=ncforum; PASSWORD='your password'; OPTION=0;
OLE DB, OleDbConnection (.NET):
Provider=MySQLProv; Data Source=ncforum.db.7085270.hostedresource.com; Initial Catalog=ncforum; User ID=ncforum; Password='your password';
Connector/Net 1.0 (.NET):
Server=ncforum.db.7085270.hostedresource.com; Port=3306; Database=ncforum; Uid=ncforum; Pwd='your password';
For additional information on how to setup your connection string using ASP, please refer to the following help resource references.

[N3RVE]

The MySQL connection values are stored in Settings.php; Update those with the new connection strings & things should work again, assuming the database has been restored correctly.

-[n3rve]

[Hj Ahmad Rasyid Hj Ismail]

I was with godaddy for sometimes long time ago. I did some changes like you and godaddy help me with such a thing. Sometimes, hosting company is helpful in this matter but we just simply didn't ask them. Sorry, if that simple ponder bothers you.

[NiceCarvings]

n3erve- Here is my settings.php

Koodi [Valitse] Laajenna

<?php
/**********************************************************************************
* Settings.php                                                                    *
***********************************************************************************
* SMF: Simple Machines Forum                                                      *
* Open-Source Project Inspired by Zef Hemel ([email protected])                    *
* =============================================================================== *
* Software Version:           SMF 2.0 RC3                                         *
* Software by:                Simple Machines (http://www.simplemachines.org)     *
* Copyright 2006-2010 by:     Simple Machines LLC (http://www.simplemachines.org) *
*           2001-2006 by:     Lewis Media (http://www.lewismedia.com)             *
* Support, News, Updates at:  http://www.simplemachines.org                       *
***********************************************************************************
* This program is free software; you may redistribute it and/or modify it under   *
* the terms of the provided license as published by Simple Machines LLC.          *
*                                                                                 *
* This program is distributed in the hope that it is and will be useful, but      *
* WITHOUT ANY WARRANTIES; without even any implied warranty of MERCHANTABILITY    *
* or FITNESS FOR A PARTICULAR PURPOSE.                                            *
*                                                                                 *
* See the "license.txt" file for details of the Simple Machines license.          *
* The latest version can always be found at http://www.simplemachines.org.        *
**********************************************************************************/

########## Maintenance ##########
# Note: If $maintenance is set to 2, the forum will be unusable!  Change it to 0 to fix it.
$maintenance = 0; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
$mtitle = 'Maintenance Mode'; # Title for the Maintenance Mode message.
$mmessage = 'Okay faithful users...we\'re attempting to restore an older backup of the database...news will be posted once we\'re back!'; # Description of why the forum is in maintenance mode.

########## Forum Info ##########
$mbname = 'Sign Forum at Nice Carvings'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://signforum.nicecarvings.com'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie816'; # Name of the cookie to set for authentication.

########## Database Info ##########
$db_type = 'mysql';
$db_server = 'ncsignforum.db.7080270.hostedresource.com';
$db_name = 'ncsignforum';
$db_user = 'ncsignforum';
$db_passwd = '*********';
$ssi_db_user = '';
$ssi_db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 0;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/content/m/j/i/mjindustry/html/signforum'; # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/content/m/j/i/mjindustry/html/signforum/Sources'; # Path to the Sources directory.
$cachedir = '/home/content/m/j/i/mjindustry/html/signforum/cache'; # Path to the cache directory.



########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 0;


# Make sure the paths are correct... at least try to fix them.
if (!file_exists($boarddir) && file_exists(dirname(__FILE__) . '/agreement.txt'))
$boarddir = dirname(__FILE__);
if (!file_exists($sourcedir) && file_exists($boarddir . '/Sources'))
$sourcedir = $boarddir . '/Sources';
if (!file_exists($cachedir) && file_exists($boarddir . '/cache'))
$cachedir = $boarddir . '/cache';

?>

Here is what I am suppose to add... Am I missing something? It don't seem right.

Koodi [Valitse] Laajenna

ODBC 3.51:
DRIVER={MySQL ODBC 3.51 Driver}; SERVER=ncsignforum.db.7080270.hostedresource.com; PORT=3306; DATABASE=ncsignforum; USER=ncsignforum; PASSWORD='your password'; OPTION=0;
OLE DB, OleDbConnection (.NET):
Provider=MySQLProv; Data Source=ncsignforum.db.7080270.hostedresource.com; Initial Catalog=ncsignforum; User ID=ncsignforum; Password='your password';
Connector/Net 1.0 (.NET):
Server=ncsignforum.db.7080270.hostedresource.com; Port=3306; Database=ncsignforum; Uid=ncsignforum; Pwd='your password';

[JimM]

That appears to be correct according to the information provided by your host.  Are you still getting errors?

[NiceCarvings]

Hi Jim, thank you for the reply! Yea I would have hoped to have my forum going by now, but sadly it's still down because of this issue.


Do I just add all of that code in the lower code box to any old where in the settings.php file? I don't get it.   

[Hj Ahmad Rasyid Hj Ismail]

This is just my opinion. Normally it is not an easy task to migrate database from linux server to windows server, whether there are mysql for linux server to mysql or sql for windows server. I am also not sure whether a backup from linux server can be restored in a windows server just like that. May be, there is something have to be done before or after a backup is made, before it is restorable or migratable from linux server to windows server. Well, it is just an opinion.

[JimM]

Hi Jim, thank you for the reply! Yea I would have hoped to have my forum going by now, but sadly it's still down because of this issue.


Do I just add all of that code in the lower code box to any old where in the settings.php file? I don't get it.   

No, as I read it, that contains the information you need to connect to the database.  It tells you the server name, database and database user name.

What error do you get when trying to access you forum?