welcome to the joys of being a DBA ... :)
That's why restorable backups, tst and dev environments are so so important.
And yes, this kind of thing has kept me (and many others) busy more than once
after a too speedily executed SQL statement.
regards
Rob
-Original Message-
From: Dave
OK, I'm getting closer to a resolution of the problem
I've had with mysql and postfix. I've got it narrowed
down to an access problem on the database. As a
relative novice to mysql, I thought I had things set
right for the database access by the 'postfix' user
account. Following are the user
Haven$B!G(Bt been following your thread, but I thought I'd make a stupid
(Bsuggestion ...
(B
(B At startup, the computer says something about starting a MySQL server.
(B Could it be that the startup item is still trying to start mysqld even
(B though it no longer exists and in the process
Arthur,
trying to strip down your output to the very basics:
mysql select * from user;
| localhost | postfix | | Y
mysql select * from db;
| localhost | maildb | postfix | Y | N
# mysql -u postfix maildb
ERROR 1045: Access denied for user:
'[EMAIL
Hello mysql,
When I execute this SQL:
update table1 as a, table2 as b set a.field1=b.field1
where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4
I received this error execute failed: The table 'a' is full
What is the meaning of this?
My server version: 4.0.12
Hi all,
(BI've got a java application running with MySQL 3.23.39 on a Win2K server.
(BNo other application uses this MySQL server.
(BAnd yesterday it just shut down without any reason. This is the second time.
(BThe first time was a few months back and I didn't pay attention to it.
(BDoes
Hello,
I have a MySQL Database with two instances running. They were both working
100% normally, until yesterday. When we connect to one instance we get the
following error:
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries
Hello mysql,
We make updade of database from 3.23.49 to 4.0.12
Before update we can see host of connections /see Example1/.
After update every connections looks like they made from local host
/see Example2/, but they did not.
Any explanation of effect?!?
Example1:
mysql show processlist;
On Wed 2003-04-02 at 13:32:22 +0300, [EMAIL PROTECTED] wrote:
Hello mysql,
We make updade of database from 3.23.49 to 4.0.12
Before update we can see host of connections /see Example1/.
After update every connections looks like they made from local host
/see Example2/, but they did not.
Any
I'm trying to learn to create database-driven websites on the Macintosh
using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina
great book published by the recently-defunct Glasshaus, Dreamweaver MX:
PHP Web Development.
I'm in the next-to-the-last chapter, trying to complete an
On Wednesday 02 Apr 2003 12:06 pm, Stephen Tiano wrote:
I'm trying to learn to create database-driven websites on the Macintosh
using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina
great book published by the recently-defunct Glasshaus, Dreamweaver MX:
PHP Web Development.
Need
Hello,
When I execute this SQL:
update table1 as a, table2 as b set a.field1=b.field1
where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4
I received this error execute failed: The table 'a' is full
What is the meaning of this?
This means that the table is full ;-)
Hello,
We make updade of database from 3.23.49 to 4.0.12
Before update we can see host of connections /see Example1/.
After update every connections looks like they made from local host
/see Example2/, but they did not.
Any explanation of effect?!?
mysql show processlist;
Hello Stefan,
Wednesday, April 02, 2003, 2:27:40 PM, you wrote:
Here is table status:
It seems
The client had been sleeping more than wait_timeout or interactive_timeout
without doing any requests.
From: Al Caponi [EMAIL PROTECTED]
To: MySQL Mailing List [EMAIL PROTECTED]
Subject: MySQL 3.23.39 shuts down by itself on Win2K
Date: Wed, 2 Apr 2003 18:12:51 +0800
Hi all,
I've
Hello,
Here is table status:
+---+++-++-+-+--+---+-+-+-+-++-+
| Name | Type | Row_format |
Cool!. That solved my problem; I don't understand why
doing a grant all didn't fix the permissions but here
is my ant output now:
[EMAIL PROTECTED] cvebrowser]$ ant test
Buildfile: build.xml
init:
build:
jar:
test:
[echo] Testing using the following classpath:
I've seen a strange replication problem with MySQL v4.0.12.
mysql LOAD DATA LOCAL INFILE '/home/andrew/upload' into table andrew FIELDS
TERMINATED BY ',' lines terminated by '\n';
Hi,
This bug is fixed in MySQL 4.0.13 (not released yet).
Until then a patch for this is :
=
On Wed, 2 Apr 2003, Shamit Verma wrote:
The replay on the webpage says that:
Nope. That would be a really slow search since mysql cant use any
indexes and a table scan would be the only way to find it.
Then even LIKE operator should suffer from the same performance drawback,
how does LIKE
Dear All
Hope you are all fine and doing well.
I would like to know the status of unicode support for mysql.
I will appreciate if someone share his/her experience regarding data
manipulation in unicode on mysql.
Best Regards,
Tariq Murtaza
--
MySQL General Mailing List
For list archives:
hi,
i am quite new to mysql. i want to implement some sort of archiving tool
for archiving(not backup) past database records and later on retrieving
them. database records are periodically deleted according some date
constraints by a deamon.that is why i want to archive current database
records
Hello,
We run a large on-line books database which is searched a lot. We are using
MySQL but we are seriously running into optimisation problems because the
searches are becoming slower and slower as the database grows.
Simplifying our situation, visitors need to search for author and/or title
The contents of the user file are attached. The user name is testit and
there is no password. This is server version 3.23.52, the version that came
with the Red Hat 8 distribution.
I entered mysql -utestit then USE mysql; and got
ERROR 1044: Access denied for user: '@local host' to database
X-Mailer: Microsoft Outlook, Build 10.0.2616
your MUA wrap-mutilates quoted text.
# [EMAIL PROTECTED] / 2003-04-02 02:34:01 +0200:
1. If a column is a primary key, there is no need to declare it a
unique.
Thank you, I was doing that for every table since I
Hello all,
I am putting multiple address book (trees) into a MySQL database.
These address book are made of directories and persons.
It gives something like that for the tables :
Directory
--
ID
Name
ID_father (the reference to the father directory)
Person
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard Hyatt wrote:
| If an application uses autoReconnect but disables autoCommit, then the
| jdbc driver will fail to reconnect with the database. This can be
| demonstrated by setting the wait_timeout on mySQL to 30 seconds, open a
| connection
Steven Nakhla wrote:
Why? Well, we have our reasons. Particularly because
we want an efficient way to handle millions of
messages, plus the ability to search/manipulate/data
mine through them using specific applications.
I hate to disappoint you, but mail storage as raw files is probably
Hi all,
The best thing that happened to me today is finding this list on the web. I am in deep
problem. I am trying to build database for my site and just discovered that my hosting
server uses mySQL and i am not use to it. I don't know where to start. don't know how
to create table or
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming
You may be able to do something with SquirrelMail. It's an email front
end written in PHP, so you may be able to customize it for your needs.
I actually have a need to store all emails in a database also, mainly
to link emails with people for followups.
I actually do this right now, but I have
PHP? www.php.net (click links-tutorials)
PHP/perl/MySQL? www.devshed.com
Others will add quite a few too.
devshed.com is pretty good.
B.
At 10:10 02-04-2003 -0500, [EMAIL PROTECTED] wrote:
Hi all,
The best thing that happened to me today is finding this list on the web.
I am in deep problem. I
http://www.mysql.com
There's a great manual that got me started. I'd also look on WebMonkey for
some basic tutorials.
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.
-Original Message-
From: [EMAIL PROTECTED]
I suggest using the tutorials on the www.mysql.com website. That's how I
learned the basics.
Craig Pyter, CCNA CCDA MCSE
mc.net
720 Industrial Drive, Suite 121
Cary IL 60013
847.594.5111 ext.5733
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Thank you for your explanations, after 4 interventions I now know much
more about the difference between primary, unique, index and I've learnt
that foreign keys exits in my sql ;-)
And from this page:
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
I understand it is rather recommended
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Todd O'Bryan wrote:
| I've managed to get mysql up and running again (I don't know how) but
| JDBC won't connect to it.
|
| Here's my little simple code:
|
| import java.sql.*;
| import java.io.*;
|
|
No. You check for empty. update, check again to make sure you now own it.
The userid is either going to be you OR someone else. not both. It it's you
then you own the record. If it's someone else then someone slipped in and
grabbed it from you.
=C=
- Original Message -
From:
Ben Edwards wrote:
Sorry everybody. I assumed that as it had been out for a long time (2
years?) it was stable. I should of chequed.
We are also running 3.23.xx because of long-standing stability. We have
arranged 4.x installations for customers as necessary, but at this
point, only
I've been trying to install MySQL (3.23.55) as a named NT service and using a
specified defaults file and I can't get it to work.
The source code has the example:
mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini
in it. The results in a service ImagePath of
David Brodbeck wrote:
I know a lot of people who refuse to use Yahoo Groups because of Yahoo's
very open and ever-changing privacy policy.
Most of the other combination web discussion board/mailing list systems I've seen are not very good at doing mail. They're web chat boards with mail
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200:
And from this page:
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
I understand it is rather recommended NOT to use foreign keys, at least
until mysql integrates it more fully.
which part of that page makes you say that?
--
I mean, at least that's how I reacted upon reading..
For MyISAM tables, you can work around the lack of ON DELETE by adding
the appropriate DELETE statement to an application when you delete
records from a table that has a foreign key. In practice this is as
quick (in some cases quicker) and much
[EMAIL PROTECTED] wrote on 02.04.2003 17:10
Hi all,
Hello Jef,
The best thing that happened to me today is finding this list on the web. I am in deep
problem. I am trying to build database for my site and just discovered that my hosting
server uses mySQL and i am not use to it. I
I'm not sure if this is a feature or not so i'll just report it as a possible bug.
I couldnt find anything in the documentation.
How to repeat:
create table t1(id int);
insert into t1 set id=0;
select @a:max(id)+1 from t1;
insert into t1 [EMAIL PROTECTED];
Result on master:
mysql select *
Thanks,
but I think the lik you provided won't help. I know how to create pk/fk
contraints, and do in our schema, when the foreign key is completely
specified. for example, if my original table was instead:
create table Example (
id int not null auto_increment primary key,
fk_id int
Hi,
I have two alternative suggestions.
1. Test your code. Simple test cases will ferret out these problems before they hit a
production environment.
2. Peer review. Let someone else look at your code before you migrate it to a
production environment. This, in my experience, is an effective
On Wednesday 02 April 2003 16:17, Tariq Murtaza wrote:
Hope you are all fine and doing well.
I would like to know the status of unicode support for mysql.
I will appreciate if someone share his/her experience regarding data
manipulation in unicode on mysql.
Unicode is supported since 4.1
On Tuesday 01 April 2003 23:34, Pratchaya Chatuphian wrote:
I use MDK 9.0 and use MySQL installed with RPM Package
How can i change or set new charset on mysql .
Caz , i want to use tis620 charset ..
I live in thailand and must use charset that i can sort my data correctly
on my MySQL
On Wednesday 02 April 2003 18:10, Webmanhouse at aol dot com wrote:
The best thing that happened to me today is finding this list on the web. I
am in deep problem. I am trying to build database for my site and just
discovered that my hosting server uses mySQL and i am not use to it. I
don't
On Wednesday 02 April 2003 04:04, Daevid Vincent wrote:
Is this a bug or just not implemented in 3.23.56-Max?
mysql SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS
alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date),
alarm_date_format) AS contact_name,
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record )
BUpdates
BReads ( and owns record )
Now What?
Cal Evans wrote:
No. You check for empty. update, check again to make sure you now own it.
The userid is either going to be you OR someone else. not
Hi,
I am kinda new to this mysql thing, so please forgive the basic question.
What i need to do is, list my records on a table with a checkbox for each.
After we choose several of the records, we click a button and i want to be
able to delete the ones selected. Is there a simple mysql
last man wins.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record
Yes, but both men think they have the record.
So 'A' looses bigtime.
My version catches this.
Cal Evans wrote:
last man wins.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:10 AM
Hi,
...the sysntax it's not quite normal.You should try :
select @a:=max(id)+1 from t1;
To test if the variable @a is loaded with what you expect, you can do:
select @a;
...if the result is NULL something is working wrong.
Anyhow, i wonder how it works on the master ?
Regards,
Gelu
Scott Wong writes:
I'm not sure if this is a feature or not so i'll just report it as a possible bug.
I couldnt find anything in the documentation.
How to repeat:
create table t1(id int);
insert into t1 set id=0;
select @a:max(id)+1 from t1;
insert into t1 [EMAIL PROTECTED];
Jeff,
We faced a similar challenge in an application: Each child record must have
a parent in one of two tables, TabA or TabB, but not both. We solved it
by adding a foreign-key field for each possible parent in the child
table. Each column can have the FK constraint. We were using Sybase,
I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir
How can i change charset sir ?
i want to use tis-620 .. sir
Any one can help me sir ... ?
Just mean change the my.conf ? ( my-small.conf , my-medium.conf , )
to add
[client]
default-character-set=character-tis620 ? just do
Hi!
Pag wrote:
If i was too confusing, maybe this helps: How can i delete the
records whose num field is 4,78,34 and 23, all in one command?
Something along delete * in 'table' where num=1 and num=13 and num=34
etc.
DELETE FROM table WHERE num=1 OR num=13 OR num=34
or better:
I noticed that there are several mirrors for this ML. Do any of
them implement a better search than the fairly rudimentary search
available at the main site?
--
Helge Moulding
mailto:[EMAIL PROTECTED]Just another guy
http://hmoulding.cjb.net/ with a weird name
Delete from table where num in ( 1,13,34) ;
Pag wrote:
Hi,
I am kinda new to this mysql thing, so please forgive the basic
question.
What i need to do is, list my records on a table with a checkbox
for each. After we choose several of the records, we click a button
and i want to
On April 1, 2003 07:50, Klepetka, Tom wrote:
Hi -
I would like to access a mysql database server from a NUMA-Q Sequent
platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity
products (Connector/ODBC, Connector/C++) run under this platform/OS?
I am afraid that I don't know.
Just noticed this thread.
Here is another method, still using the 'userid' method, but slightly
differently; it claims a job immediately. You then have to run a select by
your own 'userid' to find out what you claimed:
Assumptions:
This assumes that the following table exists, and that
I like this solution. Gonna cogitate on it for a while.
=C=
- Original Message -
From: GERST, MICHAEL (SBCSI) [EMAIL PROTECTED]
To: 'Cal Evans' [EMAIL PROTECTED]; gerald_clark
[EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:59 AM
Subject: RE: How Many
Attempting to run the makefile for test_libmysqld.c
-I am linking against
/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/lib/libmysqlclient.a
$ make
gcc -g -W -Wall -I/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include
-D_
THREAD_SAFE -D_REENTRANT -static
test_libmysqld.c -L
Please consider the following two tables:
mysql select * from os_table;
+---+--+
| os_id | os_name |
+---+--+
| 1 | mac os |
| 2 | win 95 |
| 4 | win 98 |
| 8 | win nt |
|16 | win 2000 |
|32 | win me |
|64 | xp home |
| 128 | xp
On 2 Apr 2003 at 12:51, Helge Moulding wrote:
I noticed that there are several mirrors for this ML. Do any of
them implement a better search than the fairly rudimentary search
available at the main site?
I haven't found any mirrors that have a useful search function.
Fortunately, the group
Description:
Any connection to mysqld over network socket results in segmentation fault and
mysqld restarting. The log records:
= begin log extract ==
bin/mysqld_safe: line 320: 12974 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults
When you don't specify a hostname (and 'localhost' doesn't count, use
'127.0.0.1') to the mysql commandline client, it uses Unix domain
sockets to connect to the server.
JDBC has to use TCP/IP, because Java doesn't have support for Unix
domain sockets.
What happens if you do:
mysql -h 127.0.0.1
My advice is to consider an alternate storage approach.
Instead of storing parent id's, store the trees using the Nested Set
model.
http://www.dbmsmag.com/9603d06.html
About halfway down the article he presents a model where you never store
the parent id, but you do store two columns (LEFT and
Please don't take these suggestions as sarcasm. Relying on your tools to catch
anything other than syntax errors is a bad idea. It builds in a false sense of
security.
I couldn't possibly disagree that Q/A is a good idea, but so is
defense in depth. That's why we train drivers AND install
I am trying to load a table from a test delimited file. This worked in the
previous version. Any advice on how to accomplish this?
D. H. Craig, CSM
Have a grateful day!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jeff,
Thaks for the reply, let me sum up. Normal order if by CaseID, However,
we have a need to order it by FileNumber (Keeps all the Assignments for One
person together). Assignments for one person may come in over the course of
Months so I can't order it by CaseID. The reason I want
Eldon,
It looks like you have left in the records with a blank username for
localhost and for UtilServer.
The following description is taken from
http://www.mysql.com/doc/en/Connection_access.html and my own
experimentation to validate that this works on Windows, too.
The authentication system
mysql select solution
- from os_table os, solutions_table solutions
- where os.os_id = solutions.os_code
- and os.os_id = 8;
-ms
-Original Message-
From: John Hoskins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:41 AM
To: [EMAIL PROTECTED]
Subject: select
I'm getting 100 messages a day on this newsgroup. While I love to help, I
don't like having to read each message to figure out if it's something I can
help with.
Here are examples subject lines from the past 24 hours:
How many
Help MySQL Beginner please.
Have a problem
HI there, I'm running Solaris9X86 and trying to compile version 4.0.12 from
source.
I'm using the suggested flags and configure options from the reference
manual. However I'm not really sure which of the compile options I can
add/remove/tinker with as I've never really done any c programming.
Not quite that simple, Plese read the last of the original post. I need
all solutions that have the 4th bit on, so 8,15,24,31...255 all have the
4th bit in combination with other bits.
On Wed, 2 Apr 2003, Michael Shulman wrote:
mysql select solution
- from os_table os, solutions_table
You can't use a JOIN on an insert, only on a SELECT.
The (simplest) syntax for INSERT is
INSERT INTO tablename (col1, col2, col3) VALUES (val1, val2, val3)
You can also INSERT as a result of a SELECT, but that's not what you want.
Unfortunately, you will need to create multiple INSERT
thanks for the advice Stephen. I'll admit though I am somewhat loathe to
adding an artifical row in the other tables, but it may not be a bad way
to go. In the past, I've written triggers to do this kind of check, but
mysql doesn't yet support triggers.
what I ended up doing is carefully
so then the next obvious question to ask is... is this just not
implemented yet, or is it not even on the radar as a 'feature'?
Out of curiosity, do other SQL implementations (RDBMS) allow this
syntax?
On Wed, 2003-04-02 at 08:06, Egor Egorov wrote:
On Wednesday 02 April 2003 04:04, Daevid
No problem. Use mod(m,n). To get the records where the 8 bit is set, use
and mod(os.os_id,8) = 0;
mysql use test
Database changed
mysql create table t (i integer);
Query OK, 0 rows affected (0.18 sec)
mysql insert into t values (1);
Query OK, 1 row affected (0.10 sec)
mysql insert into t
John,
Looks like I'm first with the wrong answer again.
This time for sure.
How about:
AND os.os_id 8 = 8
Where 8 is the value that you're looking for.
-ms
-Original Message-
From: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:38 AM
To: 'John
Hello,
I'm trying to perform UPDATE with a PHP form , but the UPDATE query doesn't work
anyway, returningCan't perform the update, according to code below. It doesn't
return any error at PHP nor at Mysql, I have tested the variables and they are beeing
sent properly.Could someone help me???
On 02-Apr-2003 Pag wrote:
Hi,
I am kinda new to this mysql thing, so please forgive the basic
question.
What i need to do is, list my records on a table with a checkbox for
each.
After we choose several of the records, we click a button and i want to
be
able to
On Wed, 02 Apr 2003 11:10:04 -0600
gerald_clark [EMAIL PROTECTED] wrote:
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record )
BUpdates
BReads ( and owns record )
Reality says to do it more like this
A Write lock on table
B Tries to write
I attempted to use the limit and offset features in some of my select
statements when using mysql-connector-java-3.0.6-bin.jar. I recieve the
following error :
java.sql.SQLException: Communication link failure: java.io.IOException,
underlying cause: Unexpected end of input stream. I attempted
Hi,
On Wed, Apr 02, 2003 at 05:01:48PM -0300, Sibusy wrote:
I'm trying to perform UPDATE with a PHP form , but the UPDATE query doesn't work
anyway, returningCan't perform the update, according to code below. It doesn't
return any error at PHP nor at Mysql, I have tested the variables and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Lane wrote:
| I attempted to use the limit and offset features in some of my select
| statements when using mysql-connector-java-3.0.6-bin.jar. I recieve the
| following error :
| java.sql.SQLException: Communication link failure:
This one worked. Thank you.
On Wed, 2 Apr 2003, Michael Shulman wrote:
John,
Looks like I'm first with the wrong answer again.
This time for sure.
How about:
AND os.os_id 8 = 8
Where 8 is the value that you're looking for.
-ms
-Original Message-
From:
Stefan Hinz wrote:
The query I used looks like this:
SELECT files.file_id, filename FROM access, files WHERE
directory_id=0 AND lang_id=1 AND ( files.file_id=access.conn_id AND
access.group_id IN (1) AND access.class_id=4 AND class_tbl=file )
group by file_id order by filename;
Just a short
Here's The Deal :)
To Pass a username and Password via JDBC, you should pass it in the
'url' string...
Try this :
DriverManager.getConnection(jdbc:mysql://localhost:3306/test?user=[user
]password=[pass]);
I Find it's about the most reliable Way to go :)
pre
_/_/_/_/ _/_/_/_/ +---Research
Hi all,
I'm wondering if there is some way to setup privileges in the grant
tables such that a user can create or drop any arbitrary table in
databases that user is associated with, but be unable to create or drop
the databases themselves. I was hoping the tables_priv table would come
to my
I was wondering if anyone on the list has attended any
of the training listed on the mysql.com site. If yes,
was it worth the costs in your opinion? I'm trying to
justify the costs to my management.
Thank you, Rachel
=
__
Do you Yahoo!?
The replication now work fine.
I've deleted from my.ini on MASTER
binlog-do-db=database_name
I've tried to insert in my.ini on SLAVE
replicate-ignore-table=db_name.table_name
Without result.
If i insert any option (replicate-ignore-table or binlog-do-db) the
replica is stopped!!
:-/
A
I should have been more specific: we're looking at the
Using and Managing MySQL training. Opinions
appreciated.
~RR
--- Rachel Rodriguez [EMAIL PROTECTED]
wrote:
I was wondering if anyone on the list has attended
any
of the training listed on the mysql.com site. If
yes,
was it worth the
I should have been more specific: we're looking at the
Using and Managing MySQL training. Opinions
appreciated.
~RR
--- Rachel Rodriguez [EMAIL PROTECTED]
wrote:
I was wondering if anyone on the list has attended
any
of the training listed on the mysql.com site. If
yes,
was it worth the
How would I do this:
I have a date range (start date and end date) supplied by the user
and I also have information in a table that has start dates and
end dates. I want to select everything in the table whose date range
overlaps in any way with the date range given by the user.
Thanks,
Hi Rachel,
I attended a MySQL weeklong training last October -- 2002. It was 2 days of
querying and data manipulation and 3 days of administration. I did not have a
very significant history with MySLQ before the training, but I had read the
entire manual, so the first 2 days were very
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between 2003-01-01 and 2003-01-31
or end_date between 2003-01-01 and 2003-01-31
No?
Matt.
On Wed, 2003-04-02 at 16:32, Sarah Heffron wrote:
How would I do
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone have any idea what would cause that?
mike
--
MySQL General Mailing List
For list
1 - 100 of 123 matches
Mail list logo