Re: MySQL not starting at boot-Fedora Core 3

Michael Stassen wrote: Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/ser

RE: stored procedure

Actually you can do it, it is tricky though. Below is my example, I have used similar in many procedures when I want to variabl-ize (made up word I know) table names. The same holds true for setting field values or order/group by. delimiter // DROP PROCEDURE IF EXISTS TestSelect // CREATE procedu

Fw: Access denied-phpMyAdmin

Hi Mark: First of all, have you commented out the line "Allow networking" in the /etc/mysql/my.cnf?. If not, put a "#" before this line. Probably this error is because of this directive. Second, assuming that you have created the phpMyAdmin database with the script provided, and assuming that you

Fw: A picture perfect problem

Another option is to create a field where you store the url of the picture, and store the pictures in a especific folder. You can do this very easy with phpMyAdmin. If this solution do not helps you, use the BLOB type as Dan Nelson said. Both options are OK, I think. Hope this can help you. Alva

Re: Relative Numeric Values

On Sat, 16 Apr 2005, David Blomstrom wrote: > >--- Kim Briggs <[EMAIL PROTECTED]> wrote: >> David, >> >> In reading through miscellaneous database design >> text on the web, I >> read just the other day that you should not try to >> include meaningful >> data in your key values. I assume there w

Re: Relative Numeric Values

On Sat, 16 Apr 2005, David Blomstrom wrote: >I think my question is more oriented towards PHP, but >I'd like to ask it on this list, as I suspect the >solution may involve MySQL. > >I'm about to start developing an enormous database >focusing on the animal kingdom and want to find a key >system mo

Re: Can't read database

[EMAIL PROTECTED] wrote: I'm working on a database crash recovery. Wanting to repair the tables (check table zf_forums), in 'mysql' mode as root user I get the following respons: mysql> use zforum Can't read dir of './zforum/' (Errcode: 13) Database changed mysql> use zforum Database changed mysql>

Migration / import

I'm trying to rescue my MySQL data from a crashed disk (... I know ... backup ... which I normally do, but ... ...). I managed to retrieved the complete database structure as it is normally stored under /var/lib/mysql under "Linux Fedora 2". Following up on the advise in the posting http://lists.ev

Can't read database

I'm working on a database crash recovery. Wanting to repair the tables (check table zf_forums), in 'mysql' mode as root user I get the following respons: mysql> use zforum Can't read dir of './zforum/' (Errcode: 13) Database changed mysql> use zforum Database changed mysql> check table zf_forums;

COUNT(DISTINCT R1,R2) within an IF statement?

Hi, I have a query which looks like this... SELECT BLEAH, COUNT(DISTINCT R1,R2) FROM T1 WHERE FK = 1 GROUP BY BLEAH ; Lets say that over 10 rows where FK = 1 it counts 5 distinct R1-R2 pairs in a single 'BLEAH' group BLEAH = 'Y'. Now I want to search the table for all FK's with the

Blocking connections

I'm having an issue with MySQL 4.1.11 on Netbsd 2.0.2. I had MySQL running 4.0x running under NetBSD 1.6.2, and when I upgraded to the new NetBSD, I went ahead and upgraded mysql as well. For some reason, mysql will only allow one connection at a time and blocks all other connections. Ne

Re: MySQL not starting at boot-Fedora Core 3

Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other

Re: MySQL bottleneck

> So is karma :) It might be me - but: 1) the OP hi-jacked an existing thread 2) you guys keep on quoting everything in this thread 3) even the original (existing) thread gets quoted Please don't do that. -- Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Starting a thread (Was Re: MySQL bottleneck)

[EMAIL PROTECTED] wrote: Hi Wiley, About posting: Just make Sure you create a new Subject line when starting a new thread or topic. That should do the trick and nobody gets confused. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan Changing the Subject line is

RE: Relative Numeric Values

Wouldn't creating completely unique keys for every animal be a waste of good indexing? It doesn't matter if you 30 or 3000 animals start with the same 3 letters if your using a 3 letter key for speed. As long as you avoided searching through 30,000,000 records. The method you described is of no

Crash db repair

I'm trying to rescue my MySQL data from a crashed disk (... I know ... backup ... which I normally do, but ... ...). I managed to retrieved the complete database structure as it is normally stored under /var/lib/mysql under "Linux Fedora 2". Following up on the advise in the posting http://lists.ev

Re: book advice

Thanks all for the advice. It seems that no-one is recommending the book I mentioned. I've now got Paul DuBois' book (unfortunately, it's the second edition, but hope that's still okay). Looks rather large! But it also looks very clear. David -- MySQL General Mailing List For list archives: htt