Re: FreeBSD4.3 && Mysql3.23.40 - problems with start-up

2001-08-15 Thread Jon Cheng
Hello all, I reinstalled mysql3.23.40 server twice on freebsd 4.3, and I am still having the problem that mysqld would not load up just after booting. I ran safe_mysqld& as root, and then it loaded fine. I checked that /usr/local/etc/rc.d/mysql-server.sh exists, but it is not loading for some re

Re: Upgrading

2001-08-15 Thread Jon Cheng
I am also in a similar upgrade situation, but I was thinking that all we need to do to TRANSFER a db is just zip up the db files *.MYD, *.MYI, and *.frm? This method worked for me transporting my db's from one mysql server to another. Is this an "ok" method of transfering db? Or are there some f

re: deleing exactly the same rows from a table?

2001-08-14 Thread Jon Cheng
Hi, I am curious if there is a way to delete exactly the same rows from a table with one query? Or must I do select and delete one query at a time? I accidentally parse an html file twice, and I want to keep the rows that are distinct. Thanks for your help, -Jon