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

[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 reason.  Here are the contents of
/usr/local/etc/rc.d/mysql-server.sh:

#!/bin/sh

case $1 in
start)
if [ -x /usr/local/bin/safe_mysqld ]; then
/usr/local/bin/safe_mysqld  /dev/null   echo -n
' mysqld'
fi
;;
stop)
/usr/bin/killall mysqld  /dev/null 21  echo -n '
mysqld'
;;
*)
echo 
echo Usage: `basename $0` { start | stop }
echo 
exit 64
;;
esac

Notice that I took out the -user=mysql  It didn't work with it in there or
not.

Any help would be appreciated,
thanks,
-Jon


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Upgrading

[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
flaws/risks/incorrectness involved as opposed to dumping?

Thanks,
-Jon

- Original Message -
From: Grigory Bakunov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 15, 2001 5:47 AM
Subject: Re: Upgrading


 Date |Wed, 15 Aug 2001 03:26:55 -0700
 From |Ralf R. Kotowski [EMAIL PROTECTED]

 Hello!

 RRK Hi,

 RRK I'm currently runnig RH 6.2 and I'm considering upgrading to RH7.1
 RRK I'm planning on whiping the HD's completely and start from scratch
 RRK and then install the latest RPM's from MySQL's site.

 RRK The question is what would be the best way to port my existing
 RRK MySQL databases? do a data dump? or just copy the MySQL files?

 RRK Thanx in advance for any advice on this.

 You need to dump databases with 'mysqldump' command.
 It's a safe way.
 read about it in mysql documentation.
 ___
 For technical support contracts, visit https://order.mysql.com/
 This email is sponsored by SWSoft, http://www.asplinux.ru/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
 /_/  /_/\_, /___/\___\_\___/
___/   www.mysql.com


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: deleing exactly the same rows from a table?

[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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php