Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: ktm - huhtikuu 15, 2006, 09:04:56 IP

Otsikko: Installing SMF1.1RC2 and loading a 1.0.7 SQL backup database
Kirjoitti: ktm - huhtikuu 15, 2006, 09:04:56 IP
When upgrading from 1.0.7 to 1.1RC2 some things went wrong. Can I delete everything in my forums directory, install 1.1RC2, and load my .sql backup database from my 1.0.7 forums? Can somebody give me a step-by-step procedure for this? Thanks.
Otsikko: Re: Installing SMF1.1RC2 and loading a 1.0.7 SQL backup database
Kirjoitti: Kindred - huhtikuu 15, 2006, 11:05:52 IP
copy all of the RC2 files to your server via ftp. (including upgrade.php from the upgrade package)

retore your 1.0.7 database.

configure your settings.php to reflect the correct information, or run repair_settings.php.

run upgrade.php

Otsikko: Re: Installing SMF1.1RC2 and loading a 1.0.7 SQL backup database
Kirjoitti: ktm - huhtikuu 15, 2006, 11:14:26 IP
It says "problem connecting to the database."

I ftp'd my .sql database file. Is this what you meant by "restore your database?"

My settings.php script has these instructions regarding the database:

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'smf';
$db_user = 'root';
$db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;


My database name is [some_long_name_with_date_attached].sql. I tried renaming it to smf.sql and it didn't work -- I still go the "cannot connect to database" error. What should I do to fix the settings file, and should I rename my .sql database file?
Otsikko: Re: Installing SMF1.1RC2 and loading a 1.0.7 SQL backup database
Kirjoitti: Kindred - huhtikuu 15, 2006, 11:30:41 IP
if you have access to the root...

1- create a database called smf in your Cpanel.

2- go to your shell access

3- cd your way to whatever directory you ftped the SQL file to.

4- type mysql username_smf <filename.sql
where username is the username prefix that the server usually assigns to the  databases, and filename is thename of the sql file that you uploaded.

5- the db_user is not normally root... it's normally a database user which you set up with access to your smf database in Cpanel.

6- I assume you just blanked out the db_password... because that is definitely going to be required information for the installation.