Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-12-19 19:15:55

tilunanda
New Member
Registered: 2008-12-18
Posts: 8

Update from MySql4 to MySql5 - database unavailable..what gives?

I have several sites that I need to update. My host has a db widget to transfer contents fro 4 to 5.
Is there something I need to do besides update the config.php file so that the new db is available?
Currently, I get the error “database unavailable”.
Db and tables seem to have transfered ok.
Many thanks!!!

Textpattern version: 4.0.3 (r1188)
Last Update: 2006-09-22 17:02:47/2006-09-22 16:29:34
Document root: /home/ensemble/www/www
$path_to_site: /home/ensemble/www/www
Textpattern path: /home/ensemble/www/www/textpattern
Permanent link mode: messy
Temporary directory path: /home/ensemble/www/www/textpattern/tmp
Site URL: ensemble-pi.org
TZ: America/New_York
PHP version: 5.2.6
Register globals: 1
Server Local Time: 2008-12-19 14:12:57
MySQL: 4.0.27-log
Locale: en_US.UTF-8
Server: Apache
PHP Server API: cgi
Server OS: Linux 2.6.27.6-grsec

.htaccess file contents:
————————————
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.+) – [PT,L]

RewriteRule ^(.*) index.php
————————————

Offline

#2 2008-12-19 21:55:43

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

tilunanda wrote:

Is there something I need to do besides update the config.php file so that the new db is available?

Normally the database name, user and password wouldn’t change when upgrading MySQL, so you wouldn’t have to change your config.php. But whether it has changed or not, be sure to place the config.php in the new textpattern folder.

Currently, I get the error “database unavailable”.

Are you getting this error before or after the TXP upgrade?

Offline

#3 2008-12-19 22:12:38

tilunanda
New Member
Registered: 2008-12-18
Posts: 8

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

I was hoping not to update my textpattern install at this time, so I think the config goes in the same place.
This error occurs after renaming my db to the mySQL5 db name.
:j

Offline

#4 2008-12-19 22:18:48

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

In that case, are you certain that database name and/or user are correct? Lots of hosts add prefixes to those names.

Offline

#5 2008-12-19 22:26:46

tilunanda
New Member
Registered: 2008-12-18
Posts: 8

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

yup, I am sure. I had to update a drupal install on teh same host and that worked fine.
But, it sounds like there is nothing else I have to do, so I will check all again.
merci

Offline

#6 2008-12-20 00:26:08

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

If you look at the html source of the ‘database unavailable’ page, there should be a mysql error message.

Offline

#7 2008-12-20 07:12:17

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

Textpattern version: 4.0.3 (r1188)

Please upgrade your TXP version.

Offline

#8 2008-12-20 14:45:28

tilunanda
New Member
Registered: 2008-12-18
Posts: 8

Re: Update from MySql4 to MySql5 - database unavailable..what gives?

oh, ok.
many thanks.
will try that.

Offline

Board footer

Powered by FluxBB