Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#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
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