Re: [cobalt-users] MySQL on RAQ2

[David Sexton <david.sexton@xxxxxxxxxxxx>]

Manik Surtani wrote:

> a text dump from his old database.  Some 50, 000 records.  I use a php3
> script to parse this file, and insert the rows in to mysql.  But the
> mysql server crashes after a few minutes ..... the same script works
> fine here on my local Intel based server, also running linux/mysql/php3.

	Did you install from the RPMs on ftp.cobaltnet.com? I installed these
recently and found that they installed the database onto the /var
partition (200Mb). Obviously, this can fill up. I don't know if this is
the cause of you problem but it could be worth a look.

	I don't know how to move an existing database but I was able to
recreate the empty one by modifying two files:

	/usr/bin/safe_mysqld
	Change the value for 'DATADIR'

	/usr/bin/mysql_install_db
	Change the value of 'ldata'

	Then run /usr/bin/mysql_install_db. I would reccommend puting the
database somewhere under /home as there is generally plenty of space
there. I use /home/mysql.

	Does anyone know if I've missed anything out in the above?

	Hope this helps you,


		Dave

-- 
David Sexton

Network Technician
Sapphire Technologies Ltd.
Tel: +44 (0) 1642 702100
Fax: +44 (0) 1642 702119

-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily the company.  This message and any files transmitted with it are confidential and solely for the use of the intended recipient.  If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited.

Sapphire Internet
http://www.sapphire.net