Re: Server-Crash - What to do?

et anywhere with that and the data is valuable, you should consider paid support. --Ludwig Pummer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trouble with read-only

Rod Heyd wrote: Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables indica

Re: mysql for freebsd 6.0

kalin mintchev wrote: hi all... i can't see the mysql 5 version for freebsd 6.0 on the mysql developer site? am i blind or it's on purpose?!?! curious... and actually need it... thanks... /usr/ports/databases/mysql50-server/ /usr/ports/databases/mysql51-server/ I suggest you fa

Re: is this safe against sql-injection?

Jochen Kaechelin wrote: Can somebody give me some general hints how to prevent sql-injection? I always go this way to build my queries: function clean_mysql_string($string) { $clean_string = stripslashes($string); $clean_string = htmlentities(strip_tags(($clean_s

Re: mysql_real_query.... probably asked a lot

Eric Smith wrote: OK, I'll bet you guys get a lot of this one, but I can't seem to find the answer in the archives. I have binary data that I want to store in a longblob. This is just byte data null bytes are possible. So, I use mysql_real_query. How do I format the char* query string?

Re: Help...I am desparate

Logg, Connie A. wrote: I was asked (told) by my security people to use a port < 1024. I am running with 1000 other places, and was running with 1000 on both of these machines. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:25 PM To:

Re: Quotation marks in string causing repace to not work.

Gregory Machin wrote: I tried the following UPDATE temp SET 'file_content' = REPLACE(file_content, '' , ''); but it didn't work, i think thing problem is that the string i need to replace / null has quotation marks .. how can i work around this You need to escape the quotation marks. A

Re: storing php pages with sql queries in a mysql database

Gregory Machin wrote: Hi all. I'm writing a php script to store the contents of html and php pages in a data base, it works well until there are mysql queries in the pages source then give errors such as this one. Query failed: You have an error in your SQL syntax near 'temp' how do stop mysq

Re: Using PHP to select MySQL record

This is not really a MySQL question so much as it is a PHP/HTML question, but it's a quick answer. Replace echo "".$rows['lastname'] With echo "".$rows['lastname'] On the next page, $_REQUEST['person'] contains the selected chairid. Martin Toombs wrote: Sorry if this is simple, but I'm a fairly n

Re: Trying to match on something that is not there

Or without a subquery, SELECT s.questionid, s.userid FROM SurveyAnswers s LEFT JOIN Users u ON u.id = s.userid WHERE u.id IS NULL; Brian wrote: select s.userid from surveyanswers s where s.userid not in (select distinct u.id from users u) On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAI

Re: Mysql, php and unsubscribe or delete

My guess is that since your id field is not auto_increment and you're not specifying a value, all email addresses are getting an id of 0. Since your primary key is composed of both id and email, MySQL isn't complaining. [EMAIL PROTECTED] wrote: However, Problem application is giving me is in ca

Re: MySQL query problem in conjunction with PHP

Thomas Nyman wrote: I found an instruction on the net concerning "Date Arithmetic" and which seems to be exactly what I need to hel me get going..however there seems to be either a mistake on my behalf or on the writers behalf. Can anyone say whats wrong with this query $query2="UPDATE KK_Fatal

Re: [PHP] Plz help quick - mysql/php/web server undefined function all of a sudden

Chip Wiegand wrote: John, Yep, looking at phpinfo.php shows no support for mysql. This is very strange. I know these things don't just happen by themselves. I also know there are only two people with the password to the server, myself and my boss (and he knows nothing about the server to begin

Re: Similar simple query slow down dramatically, by just select one more field, why?

Oscar Yen wrote: create table a ( imgid int not null, parent int, imgtype char(3), img longtext, primary key (imgid), key searchkey (parent, imgid) ) type = innodb; T1) select imgid, parent from a where parent = 10; returns 3357 rows in 0.08 sec. T2) select imgid, parent, imgtype fr

elminating filesort

a table scan? I know I can try to force the use of an index with MySQL 4, but I'd rather not upgrade if I don't have to (USE INDEX doesn't help, btw). Thanks, --Ludwig Pummer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]