mysql_select_db(books);
$query = SELECT * FROM books WHERE .$searchType. LIKE
'%.$searchTerm.%';
$result = mysql_query($query);
$num_results = mysql_num_rows($result); //This is where I am getting the
error actually: Warning: mysql_num_rows(): supplied argument is not a
valid
MySQL
Yes this is the same issue I've reported previously. Unless literally
'select' the database, the query is never written to the binary log.
- Original Message -
From: Ross Davis - DataAnywhere.net [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 12, 2003 12:38 PM
Subject:
No, I've been ignored on this problem for 18 months now, for some reason.
Quite peculiar.
- Original Message -
From: Ross Davis - DataAnywhere.net [EMAIL PROTECTED]
To: 'Jason Brooke' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 13, 2003 9:16 AM
Subject: RE: Replication
Are you using 'replicate-wild-do-table = DBName.%' ??
Thanks for the reply.
That's a client-only option, we're not actually having any troubles with
clients ignoring anything in the binary log - the problem I'm describing is
that when a database is not first explictly selected, the master
The problem with this idea is that mysql replication doesn't always work so
you'd end up with data missing from the backup. If you don't explicitly
select or 'use' a database, the sql query is never written to the binary log
and thus the slaves don't pick it up.
- Original Message -
I have a test case that says otherwise.
I just connected to my master, inserted a record into a table (never
having done a USE), and then checked a slave. It was there as
expected.
I have an array of test cases that says otherwise.
I just connected to one of my masters, inserted a record
mysql Ver 11.18 Distrib 3.23.53a, for pc-linux-gnu (i686) (and pretty much
any other version from the past 12 months or so)
Speaking from the view of using mysql primarily via Php 4.2.3 (and other
versions) with either bundled libraries or linked against the above version
of MySQL:
It appears
Maybe you could try insert delayed
- Original Message -
From: Wilfred Li, Ph.D. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 9:17 AM
Subject: dropping auto_increment PK/Index
Hi,
Is it possible to drop an auto_increment column index or primary key to
database,sql,query,table
Is there a reason why I can't use Mixed_Case column names? Or is there a
reason why I should use lower_case names?
TIA
Barry
No
jason
-
Before posting, please check:
Hi,
How could I retrieve data from MySQL and put it to data array? here is
example
Table Sale
Field1 -- Date
Field2 -- Sale Amount
---
Date Sale Amount
1/1/2001 1000
1/2/2001 2000
1/3/2001 3000
$data_array=array (
array('1/1/2001',1000),
array('1/2/2001',2000),
I just installed my first Master/Slave setup Tuesday ... followed the
instructions in the Manual
(http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad
ministration.html#Replication).
It was a snap!
Gerald Jensen
How's it going for you - is it in production use yet,
My linux is Hed Hat and I have a problem with my
database: when I tried to connect with mysql, this
message appear:
can't connect to local mysql server through socket
/var/lib/mysql/mysql.sock (111).
Please, someone help me.
Thanks.
Cristiana.
This could be because mysql is not
and not others?
- Original Message -
From: Jason Brooke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 7:17 PM
Subject: replication
Why, when doing replication, would some queries to a replicated database
get
logged to the binlog, but not others
Ask it and see...
EXPLAIN SELECT
Jeremy
mysql exlain why youre not writing all (non-select) queries to the binary
log when replicating databases;
ERROR 1064: You have an error in your SQL syntax near 'exlain why youre not
writing all (non-select) queries to the binary log when rep'
Why, when doing replication, would some queries to a replicated database get
logged to the binlog, but not others? Is replication still very beta, or is
it considered to be stable now?
The slave of course falls behind because of the queries that don't go to the
binlog
versions 3.23.42 and
Hi,
Could somebody tell me what is this?
SQL select * from users limit 0,25 failed : Got error 127 from table
handler
TIA
Alex
http://www.mysql.com/doc/manual.php?search_query=Got+error+127+from+table+ha
ndlersubmit=Searchdepth=0
jason
Hi
Can anyone tell me how do i see all the system tables (default
tables)
used by mysql. To see the databases i know that there is a showdatabases
command. How do i see the system tables ?
thanx in advance
regards
Nilesh
What system tables are you talking about? The permissions
To Whom it may concern,
I've noticed a bug with the Billionium. Now that we have hit 1 Billion
seconds since the beginning of the Epoch mysql will NOT work properly with
a
MIN clause involving seconds before the Billionium.
To clarify, I have a script that keeps track of the seconds of
You should probably reply to the correct email - according to your email
body, it appears that it was me who made the claim that there was a mysql
bug when I was simply replying to the person who actually did make the
claim.
jason
On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote:
To Whom
There is also a famous document about reply-to:
http://www.unicom.com/pw/reply-to-harmful.html
Here's another point of view as well:
http://www.metasystema.org/essays/reply-to-useful.mhtml
As little as it has to do with databases, just for the record I'm on a bunch
of lists - some munge
Is there any reason why a replicating master won't write some incoming
write-queries to the binlog for slaves to pick up?
I have a php script which dynamically builds an sql string and sends it to
mysql - the query works fine, the data is inserted, but it's never written
to the binlog as long as
CREATE TABLE MSJOURNL (ACCT INT(3),
DESC CHAR(29),
DTE DATE)
This query fails when MySQL encouters DESC. Changing DESC to DESCRIP
causes
the query to work. I'm wondering if filtering for the reserved word
DESCRIBE
causes DESC not to be legal for use in field names?
desc itself is a
We're having problems with connecting to our MySQL database after making
some changes to our system. Unfortunately, we had to reassign it's IP
address and, at the same time, our customer wanted to change the domain
name for the system. Changing both seems to have been a bad thing.
Now, with
you probably forgot to do any one of the things described in the manual which
are required for permissions changes to take effect
- Original Message -
From: Meital Issers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 14, 2001 6:04 PM
Subject: Access is denied
Hello,
I
Hi,
got a problem as mysql does not allow writing but 127 entries to a
database, any idea how to correct this abnormality?
Jari Mäkelä
You probably created an auto-increment field of type tinyint - check the data
specification for tiny int in the online manual to see whay it's happening
How can I tell which user on the system is responsible for the lag?
Ideally there would be a command like 'top' that would show which
databases are being accessed most frequently, or taking the most time to
access.
-
Yes it's possible and quite easy no matter which one you install first, but
this is a mysql mailing list. You can find everything you need at
http://www.linux.org
jason
- Original Message -
From: johnd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 27, 1999 11:57 PM
Hi Everybody!
Installing Mysql on a sparc sun solaris 2.7 machine.
The manual from msyql.com mentions adding "user" and
"group."
What's the purpose of this?
Thanks for your help!
My guess would be to have mysql running under it's own uid/gid in the event
someone uses it to gain
Did you try using % for the host instead?
I'm trying to set it up so that I have only 1 entry per user in my
mysql user table. My users will have the same privileges regardless
of what host they come in from. There's only 1 database they'll be
working with. There are 2 users, user
Add a date/time column and dump the current time into it when you do an
insert
jason
- Original Message -
From: "chris" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 11:26 AM
Subject: time and date
Is there a way to store the time and date that a record was
Escape it with a backslash - insert into table (field1) values
('sbie\'2000')
This is covered in the manual http://www.mysql.com/manual.php
jason
- Original Message -
From: "Elaine Silva" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 22, 2001
Like pretty much all software, it quite possibly has security flaws.
A big bonus though, is that it binds port 3306 by default so you don't need
to run it as root. Create a completely seperate user and group for it and
run it under that uid/gid. Ensure none of your root system scripts interact
Try the manual contents, linked from the documentation page
http://www.mysql.com/documentation/mysql/bychapter
OK. I went to the documentation at www.mysql.com and typed in
DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
rules that may be used (I'd like December to
The from field is the original sender, not the list. Try to: and cc:
jason
What's wrong with creating a filter? Most e-mail programs of today allow
for filters!!
Just create a filter based on the from field where it equals
[EMAIL PROTECTED]
34 matches
Mail list logo