On Tue, 30 Jan 2007, Marie Mooney wrote:
>Hi.
>I am an extremely (completely) new user to BASE, and I was tasked with
>migrating from Base 1.2.14 to BASE2. Unfortunately, it seems, I started by
>installing BASE2, and doing all the other system upgrades necessary for
>that, which included updating MySQL from 4.1 to 5.0.27. When I did this, I
>had stopped the 4.1 version, which I had problems restarting. However, to
>do the migration in BASE, I apparently have to update to 1.2.17 first,
>then do the migration to BASE2, and to do the first upgrade, I need to
>stop the old version of BASE 1.2.14 (Does all this sound correct so
>far?), which won't stop on this error:
Hi, I comment what a system administrator would do in your situation:
(1) Keep the working 1.2.14 as it is on, say, machine A.
(2) Install and test 1.2.17 on another machine by importing data
from 1.2.14. After you are completely satisfied with the
performance of 1.2.17, you may shutdown 1.2.14.
(3) Install and test BASE2 on the machine A by importing data from
1.2.17
># stopBase.php
>PHP Warning: mysql_pconnect(): Can't connect to local MySQL server
>through socket '/var/lib/mysql/mysql.sock' (13) in
>/usr/local/base-1.2.14/include/drivers/mysql.inc.php on line 86
>mysql_pconnect() failed: Can't connect to local MySQL server through
>socket '/var/lib/mysql/mysql.sock' (13)
>Could not connect to database 'base' at host 'localhost' as user 'apache'
>BASE appears to be running, but connecting to the database failed.
>My question then is whether there is a way to stop BASE without having
>access to the old version of MySQL, or is there a way to make BASE 1.2.14
>run on the new version of MySQL without stopping it?
>I tried changing the 'base' db BaseControl table to have startscripts = 0,
>as mentioned in the forums for after someone else had a problem where
>MySQL went down before BASE was stopped, but this didn't give me any
>different results.
>Any suggestions from anyone would be greatly appreciated.
The procedure to shutdown BASE service as said in the BASE documentation
is: stop BASE, Apache, and MySQL in that order. To start up BASE service,
reverse the order.
Because MySQL was stopped, you have to kill the BASE process manually.
In my opinion, it wasn't a good idea to update MySQL on the working
1.2.14. Just wish that your database is still intact, or you have a
backup somewhere.
Regards,
Zong-Pei
-------------------------------------
Dr Zong-Pei Han
UNIX Systems Administrator
Computational Biology Research Group
University of Oxford
http://www.compbio.ox.ac.uk/
-------------------------------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
The BASE general discussion mailing list
basedb-users@lists.sourceforge.net
unsubscribe: send a mail with subject "unsubscribe" to
[EMAIL PROTECTED]
