non-text data

2006-08-12 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I use SELECT all from * ... and one row is a gif. How do I get that gif to appear as a gif and not text? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: More than 4 CPUs?

2006-08-12 Thread Miles Teg
If you're using 4 or 8 cpus, I highly recommend considering Solaris 10. It's free and it's true threading implementation and fine grained locking increase scalability and even out cpu load on multi-cpu systems much better than my RHEL 4 U2 (Linux 2.6) systems do. Their benchmarks back up my ex

Do I really need a subquery?

2006-08-12 Thread Geoffrey Sneddon
Hi, I've ended up with the following SQL: SELECT `title`, `url`, COUNT(1) AS `count`, CEIL(COUNT(1) / (SELECT COUNT(1) AS `count` FROM `bi_bookmarks` WHERE `date` > NOW() - INTERVAL 86400 SECOND GROUP BY `url` ORDER BY `count` DESC LIMIT 0, 1) * 8) AS `weight` FROM `bi_bookmarks` WHERE `d

Re: Connection Help - Stupid Question, sorry to bother.

2006-08-12 Thread Chris W
By default MySQL uses port 3306 so you need to be sure that port is open on the server, and not blocked by a firewall. You also need to be sure the user you are trying to login as can login remotely. In the MySQL user data base, there is a column for host which is the host that user can login

Connection Help - Stupid Question, sorry to bother.

2006-08-12 Thread Sana Farshidi
Hi, Im sure this is a stupid problem but im a bit confused, and some assistance would be greatly appreciated. Im trying to assist with the maintenance/updating of a php site for a school which uses mysql, and is allready up and running on a remote server. I have the ftp username and password, and

RE: MySQL Replication Binary Logs - How Long to Keep?

2006-08-12 Thread Warren Crigger
> Note that you should not just delete the bin logs. Instead > use PURGE MASTER LOGS. See > http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html > > hth, > mark Sorry, accidently hit Ctrl/Enter :( Anyway, I can't purge with that command: mysql> PURGE MASTER LOGS TO 'mysql-bin.023';

problems with sql-mysql mode of emacs on Windows

2006-08-12 Thread Jieqi Wang
I am using WinXP, GNU Emacs 23, MySQL 5. When I start a mysql process with `sql-mysql' in emacs, no output is displayed in the buffer until I quit or kill the process. After I add the following line into the initialization file of emacs, (setq sql-mysql-options '("-C" "-t" "-f" "-n")) the o