At a guess, I'd set the default value to 1000 so the first record you insert
has 1000 as it's value, then it will continue on from there.
- Original Message -
From: "Mike Doanh Tran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 5:15 AM
Subject: setting auto
> 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
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]&g
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
> 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 refus
> 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 reco
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 -
From:
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 t
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 k
Similar thing happens with alter table/drop table. alter table isn't logged
to binary log, but drop table is.
- Original Message -
From: "Dr. Frank Ullrich" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 31, 2001 10:55 PM
Subject: Replication problem (with temporary
> 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:
http:
> 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
> 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 u
> 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(
> 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 r
are logged 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
> lo
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 3.23
> 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
ndler&submit=Search&depth=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 permiss
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 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
> 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 r
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,
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
> 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
S
> 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 un
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 "d
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
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, 200
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
wi
What sort of queries are you doing on this large table? I notice you only have
a couple of the fields indexed
jason
- Original Message -
From: "chchen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 6:35 PM
Subject: Speed of mysql
hi,all
i have a strange
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]
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
You'll have to go through the script step by step printing out debug in
order to determine what's going on - it's a normal process of elimination
when troubleshooting
jason
> I had this query site working and showing the DB info depending on the
> Category.
> For some reason it just stopped wo
38 matches
Mail list logo
