ost:3306?"
>
> Thank you in advance!
>
> rruth
>
>
>
>
>
> Sent via the WebMail system at ruthgirls.com
>
>
>
>
http://www.adobe.com/go/6ef0253
If you have any more problems, ask them at th
;
it might be best to ask this in the cf forums, however did you try to
separate the statements with a ; ? I haven't tried 2 query statements
for MySQL in cfquery...yet ;-) Also I believe MySQL 3.23+ supports
@@identity
HTH, Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as why this thing is
blocking connections, that'd be great. I've been running around
through mysql's documentation and mailing list archives, and googling
for a week now, and I'm no closer to fixing it. Thanks.
Tim
--
MySQL General Mailing List
For list archives: http://
nt to install, will it
communicate with my current version on A?
Thanks in advance.
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he service will start automatically) or go
into Services and start it manually.
Make sure you configure the my.cnf file and place it in the c:\
directory as appropriate.
Hope this helps.
Cheers
Tim
> Hello,
> This post pertaining to a previous one on the same subject.
That i
the service.
Good luck!
I am running on Windows XP professional by the way, cannot confirm
whether it is a problem under the the home edition.
Cheers
Tim
> Hi, I'll try that. Re:
>
> "Make sure you configure the my.cnf file and place it in the c:\
directory
> as appr
>Description:
Following installation I am unable to run the my_install_db script.
>How-To-Repeat:
Follow steps for binary install, tarball untarred, symbolic link mysql
created, run the my_install_db script and it crashes
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Ori
a library not installed but I have no clue as to which it
is. Thanks for the help
-Tim
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL
Does anyone know if there is any 16 bit code at all in mySQL. Ever since
installing mySQL for evaluation I've had a rash of NTVDM.EXE's running
around my machine and twice have had so many it brought it to almost a
stand still. I didn't have this problem before the installation
I am trying to use MyODBC and getting a connection
error to a remote linux server.
S1000[TCX][MyODBC]Access denied for user.
I have read manual and read other postings but can
figure this out.
I had added the user to database and also added the
host name, which is 45+ characters long as a user.
some time redesigning the databases, you'll find your problems
are not as complex...
Good luck!
- TIM FRASER
> Please forgive the relatively basic nature of this question. I'm new at
> this. I have the DuBois MySQL book and the O'Reilly one as well, so please
> feel free to po
ation/mysql/bychapter/manual_Reference.html
- TIM FRASER
> Hi,
>
> I am a newbie to Mysql.
>
> I would like to know how to create a table with
> variable length records?
>
> i have an object with following variables:
> varchar v, int a, int b, int c.
>
> and i
Is there any way to redirect the output of a 'Show' command to a text
file?? I know you can do this with a SELECT sql statement...
-TIM
-
Before posting, please check:
http://www.mysql.com/manual.php (
Why would you want to manually set an AUTO_INCREMENT column?? You might
as well use an integer column if you want to be able to change its
values...
- TIM
> >Description:
>
> On some releases of mysql, after you manually set an AUTO_INCREMENT
> column to a nega
Check out the 2nd bullet under 7.21.1 of the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT_SELECT
You could do this by creating a temporary table out of MaterialSubwall and
using that to select rows for the insert.
- TIM
> What does this mean? It
is wrong ??
>
> Thanks
> Ana Elisa Martinez
>
>
>
>
--
-TIM
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
this:
select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id
is the same thing as:
select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id = tbl2.id
- TIM
> Hi,
>
> unfortunately my provider still runs My SQL version 3.22.32 on his server.
> Ap
The "access denied" message is most likely occurring because you are not
supplying the password option (-p) to the mysql command.
- TIM
> Using the source command on the command line, I am getting "access
> denied" (to
> the file, I am guessing).
>
> I
Also, I don' think "-00-00" is a valid Date. You might want to use
something else as a default.
- TIM
> Hello-
>
> I'm just beginning to teach myself MySQL with the help of Michael Widenius'
> book "MySQL". I've entered the create table
Did you try taking out one of the 'last_name' field definitions?? It
looks like you have two there...
- TIM
> Hello-
>
> I'm just beginning to teach myself MySQL with the help of Michael Widenius'
> book "MySQL". I've entered the create table s
Put quotes around the Customer_No:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
- TIM
> Here is the full error I am getting when running the query included:
>
> Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
> 1054 : Unknown colu
Ok, in your PHP code, do this:
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
This will add quotes around the variable...
-TIM
On Mon, 18 Jun 2001, Shrout, Ryan wrote:
> Thanks for the suggestions, but this is actually a variable that is p
L+2 bytes, where L < 2^16
MEDIUMBLOB, MEDIUMTEXTL+3 bytes, where L < 2^24
LONGBLOB, LONGTEXTL+4 bytes, where L < 2^32
L is the max length, and +1, +2, +3, +4 records the size of the record.
HTH,
Tim
-Original Message-
From: C K [mailto:[EMAIL PROTECTED]
Sent: S
into some document management system. If you've done
anything like this, I'd like to hear about it as well.
All input appreciated (to the list, please ;-) )
Tim
care ;-) on March 9th.
Right now, some of our DBs are about 35-40Gb, of which half or slightly more
consists of archive blobs. This archive feature is increasingly popular and
so we're looking to move it out of the main database(s) and onto a separate
server.
Tim
-Original Message
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
-Original Message-
From: David T. Ashley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 11:15 AM
To: Jay Blanchard; Shaun; mysql@lists.mysql.com
Subject
In this case, the result set is not editable. It needs to have some way to
uniquely identify the row(s) under edit so it can perform an update.
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, April 24, 2006 11:42 AM
To: J.R. Bullington; mysql
Read these
http://en.wikipedia.org/wiki/Longitude
http://en.wikipedia.org/wiki/Lattitude
And no, you cannot drive my yacht ;-)
-Original Message-
From: Gmail User [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 9:05 AM
To: mysql@lists.mysql.com
Subject: RE: Calculate LONG/LAT f
http://dev.mysql.com/doc/refman/5.0/en/blob.html
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
-Original Message-
From: Tommy Nordgren [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 1:27 PM
To: mysql@lists.mysql.com
Subject: Datatype MEDIUMTEXT
do MySQL store
Invert the problem ;-)
Sort descending by the time_stamp field and limit the result to 1, i.e.
SELECT * FROM table_xyz ORDER BY time_stamp DESC LIMIT 1
Tim
-Original Message-
From: Brian J. Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 1:37 PM
To: mysql
How about this?
CREATE TABLE `test`.`test` (
`x` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`y` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`Z` INTEGER UNSIGNED NOT NULL DEFAULT 0,
UNIQUE `Index_1`(`x`, `y`, `Z`)
)
ENGINE = InnoDB;
Tim
-Original Message-
From: Scott Purcell [mailto:[EMAIL
I don't hear "you need to implement connection pooling". Maybe, but I think
you might still have errors under load, as you approach the maximum
connection count in the pool.
Tim
-Original Message-
From: romyd misc [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 2:
I would be
surprised, however, if you had to do anything special, other then connecting
via a pooling connection string. In the Java case, connection.close() is
overridden to simply return the connection to the pool (and .open() borrows
one, ...)
Tim
-Original Message-
From: romyd misc [mai
When I do this, the query browser pops up with a select * from table query
which is executed on my behalf revealing my data. All I have to do is press
the edit button (assuming the result set is editable, of course.)
Can you be more specific about 'nothing shows up'?
Tim
-Origin
There may be a clue at the bottom of every message ;-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
across all
records that are newer then the last time you uploaded, or, greater then the
most-recent date in the main database.
Tim
rsync(1) - faster, flexible replacement for rcp
DESCRIPTION
rsync is a program that behaves in much the same way that rcp does,
but has
Ask our mutual friend, Google. It has lots of answers for you.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 10:09 AM
To: 'Tim Lucia'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to anothe
You want a LEFT (OUTER) JOIN, which will return nulls for the columns if no
match on the join expression.
-Original Message-
From: Paul Nowosielski [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 4:44 PM
To: mysql@lists.mysql.com
Subject: Join help
Dear All,
I'm working on a
RPMS directory on the RHEL V.4 installation media
complains about a missing client library and points me off to a 4.1 rpm,
which I do not want.
Anyone have this same problem? Or clues how to fix this?
Thanks,
Tim
Here's the error:
gcc -c
-I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-th
Solved --
After upgrading to 5.0.22, DBD::mysql builds without any problems.
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 4:17 PM
To: mysql@lists.mysql.com
Subject: Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64
I'm running on a Xeo
es noting the master log position(s).
Have I discovered a bug? Google and searching the lists.mysql.com don't
reveal this exact scenario...
Thank you for your time,
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t? I
accidentally deleted student Tim Lucia... can you get him back"). Mysqldump
is slower to back up, slower to restore, but allows for selective restores.
Are those the only things to consider? I know that piping mysqldump into
gzip results in disk space savings of the dump file, whereas my
> -Original Message-
> From: Dan Buettner [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 29, 2006 9:26 AM
> To: Tim Lucia
> Cc: mysql@lists.mysql.com
> Subject: Re: Recommended backup scripts for mysql databases
>
> Hi Tim - those are all important consideratio
If it were so cut-and-dry, I would know which one to choose ;-) Obviously
it's not.
I'm leaning towards the mysqlhotcopy because it is way faster, and now I
know how to selectively restore. I have a slight concern with the
self-professed beta nature of it -- is that unfou
15K (times 6) drives.
The plan is to RAID then 2 x RAID1 for the o/s (/boot, /, /var, and some
working space for dumps and restores), and 4 x RAID10 for /data. Anyone
have any feedback on this?
Tim
> -Original Message-
> From: Chris White [mailto:[EMAIL PROTECTED]
> Sent: Wednesda
> -Original Message-
> From: Chris White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 12, 2006 5:15 PM
> To: mysql@lists.mysql.com
> Subject: Re: I don't understand why SCSI is preferred.
>
> On Wednesday 12 July 2006 01:13 pm, Tim Lucia wrote:
> > I&
s and binlogs and data together?
TIA,
Tim
> -Original Message-
> From: Tim Lucia [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 12, 2006 5:41 PM
> To: 'Chris White'; mysql@lists.mysql.com
> Subject: RE: I don't understand why SCSI is preferred.
>
>
ric-type-overview.html which
says: "A double-precision floating-point number is accurate to
approximately 15 decimal places." If I counted right, the "errant 1" at the
end is in place 15, so that is accurate to approximately 15 places.
Tim
> i don't know what i
t; filesystem, you have to stop mysql from running so you don't corrupt
> anything which means your whole database system can't be used.
>
For MyISAM files, mysqlhotcopy of the slave is a workable solution. It's
fast, it locks the tables only while copying, and you end up
http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
> -Original Message-
> From: Kaushal Shriyan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 7:45 AM
> To: Tim Lucia
> Cc: mysql@lists.mysql.com
> Subject: Re: Incremental Backup
>
> On 7/18/06,
------+
| 1 |
+-+
1 row in set (0.00 sec)
mysql>
'zz' will probably do the trick, though.
Tim
> -Original Message-
> From: Paul Nowosielski [mailto:[
You want cascade deletion via foreign keys.
http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-foreign-keys.html
is one such place to learn more.
Tim
> -Original Message-
> From: Chris W. Parker [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 07, 2006 9:11 PM
> To: mysql@lis
Hello All:
I am most familiar with mysql thru RH 9.0 and win XP.
I have set up a slackware partition (ver 10.0) with
mysql ver 4.0.20.
Are there any special instructions for Post-Installation Procedures?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-in
;t clear as to whether
or not I should run mysql_install_db. Looks like I should, 'cuz
slack doesn't use RPM.
Cheers
tim
> 4.0.20 is rather old, use the latest release (4.1.12).
>
>
>
> Tim Johnson <[EMAIL PROTECTED]> wrote:
> > Hello All:
> >
Hi all,
Is there any reason why I shouldn't increase the size of the allowable
user names in mysql to var(32) instead of the default var(16) ???
Couldn't really find much on it, but wanted to ask if anyone knows of
any troubles this may cause...
Thanks,
Tim.
--
MySQL Gener
ime was:
"""
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
"""
And I'm sorry to say, but I don't know what that means.
Again, advice and clarification of these instructions are welcome.
Than
mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-
Thank you for your help so far.
Further support greatly appeciated. :-)
Further pointers to docs invited!
Regards
Tim
> > Using 4.0.20 on Slack 10.0
> >
> >
to override the default location of the socket for the
> server,
> you will also need to add an entry for the client.
>
> [mysql]
> socket=/var/lib/mysql/mysql.sock
... of course ...
That's what I needed.
(the my.cnf was copied from a RH 9.0 partition with
mysql
Good Afternoon:
I have rebuilt by web / database server from bare metal this morning.
The computer is running Fedora Core 3, and is fully patched and up to
date.
The MySQL version is 4.1.12-1, and I have installed the following
components
- Server
- Client
-
rective in the my.cnf file to read
> >datadir=/home/mysql
> >when I do this however, mysql fails to start - it waits for a period
of
> >time and gives me a failed error.
> >Can someone please explain to me what is going wrong, and what I can
do
> >to fix it. - I am not i
have access to Webmin, the command line and physical access to the
console if necessary - anyone who can help -- PLEASE?
TIM
Timothy A. Holmes
IT Manager / Webmaster / Science Teacher
Medina Christian Academy
A Higher Standard...
Jeremiah 33:3
Jeremiah 29:11
Esther 4:14
--
MySQL General M
with that name on either of
my linux partitions. The library developer is primarily a
windows programmer and has told me that this file should
be included with the distribution.
Can anyone clarify this matter for me? Do I need a symlink?
If so to what?
thanks
tim
--
Tim Johnson <[EM
* sol beach <[EMAIL PROTECTED]> [050723 09:15]:
> I suspect a case problem
Hello sol:
I'm using a case insensitive seach.
i.e.:
[EMAIL PROTECTED] tim]$ locate -i libmysql.so
[EMAIL PROTECTED] tim]$
same results as root
thanks
tim
--
Tim Johnson <
* Tim Johnson <[EMAIL PROTECTED]> [050723 10:42]:
> * sol beach <[EMAIL PROTECTED]> [050723 09:15]:
> > I suspect a case problem
> Hello sol:
> I'm using a case insensitive seach.
> i.e.:
>
> [EMAIL PROTECTED] tim]$ locate -i libmysql.so
>
areas.
>
> Except for those areas that it doesn't.
> [/snip]
The best situation might be a combination of both.
But wait! That's what I have. Boot up linux, then
start windows in it's own desktop. Best of both
worlds!
And lately, I've been using MS-Access
cket
'/var/lib/mysql/mysql.sock' (13)
What works:
mysql -u tim -p
Enter password: * # works
---
Problems unencrypting password:
SET PASSWORD FOR 'tim'@'localhost' = OLD_PASSWORD('**')
ight be provided to him to upgrade and what caveats
might be cited?
Thanks very much for the pointer to the docs.
regards
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e that I have a problem with permissions.
Can anyone point me to the solution?
Many Thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lib/mysql/. Most
> likely, user mysql is not set as the owner of /var/lib/mysql/, in which
> case you need to
>
> chown -R mysql:mysql /var/lib/mysql/
>
> as root.
Bingo! That worked and I learned *two* things. :-)
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]
successfully back up this database?
Thanks!
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-0001 Office
(516) 908-4185 Fax
http://www.meitech.com/
smime.p7s
Description: S/MIME cryptographic signature
Shawn,
Thanks. I should have included the switches I was using to make the
backup.
I'm using "--opt --quote-names", and according to the manual, "--opt"
includes "--quick".
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-
No, max_allowed_packet is 100 megabytes, and the maximum data field in the
database is 50MB right now, and most are well below 10MB.
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-0001 Office
(516) 908-4185 Fax
http://www.meitech.com/
-Original Message-
From
> I believe it's the size of the row, not the size of a
> single field, that matters. Is it possible you have a
> row which exceeds max_allowed_packet size?
No. There is one blob fields (always less than 50MB) and like 10 other fields,
all integers.
smime.p7s
Description: S/MIME cryptographic
the day (when the server is actually much more active) and the backup
completed successfully. That one table took about 5 hours to back up
though - I'm not sure if that is normal or not. Then last night's
automated (unattended) backup completed successfully for the first time
in a f
Hey all
Can anyone tell me the best way to ignore leading whitespace on
orderings?
Thanks
Tim McIntyre
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
y
part of a cron job that runs at 1AM UTC.
Can anyone offer some suggestions as to what's causing this, and what I
might be able to do to fix it? Is there any way to maybe split the
backups into 3 or 4 pieces so that no one .sql file is so big and no one
run against the database is so
customers happy.
Tim Hayes
MYdbPAL - www.it-map.com
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 22 September 2005 09:02
To: mysql@lists.mysql.com
Subject: Re: good database design
> I need links about good database design information for high loaded
y you should start worrying abt the DB Tuning and harware
requirements.
sujay
-Original Message-
From: Ian Sales (DBA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 2:17 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: good database design
Tim Hayes wrote:
>I
t database
to update it and put it back in synch.
Tim Hayes
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 05 October 2005 23:25
To: Claire Lee; mysql@lists.mysql.com
Subject: Re: compare tables from two systems
- Original Message -
From: "Claire Lee" &l
Do you have any log messages associated with it?
(not sure for win / os x for linux look in /var/lib/mysql/.err)
Hi.
For clarity, I'm running mysql 4.0.20
And I did start the mysql daemon.
Luke Vanderfluit wrote:
Hi.
I have a database that is used with wordpress blogging software.
Yesterda
flate 0x1420 /usr/local/lib/libz.a(deflate.o)
Again, 4.1.8a built without such errors, but every later release fails.
--
Tim Evans, TKEvans.com, Inc.|5 Chestnut Court
[EMAIL PROTECTED] |Owings Mills, MD 21117
http://www.tkevans.com/ |443-394-3864
http://www
Evan Borgstrom wrote:
The same way the kernel deals with them; int(10) unsigned. To convert a
dotted quad string into int(10) use the following:
Using 192.168.10.50:
192 + (168 * 2^8) + (10 * 2^16) + (50 * 2^24) = 839559360
This is real handy if you're doing low level socket stu
local/bin/mysql is chowned root:wheel, is that correct?
Is there a log my startup errors should be dumping to?
Is there somewhere else I should be checking permissions?
Is there anything the problem might be, that I can check?
Thanks.
--
Tim DeBoer
http://www.freebsd-geek.com
Just once, I'd
that file somewhere else, and then re-start mySQL?
Is this possible, or am I stuck having my database server off-line for
hours while the backup/restore procedure happens?
Thanks for any help you can give!
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-0001 Office
(51
table variable or anything like that, it's just code.
I'm not nearly as familiar with mysql as I would like to be, so I have no
idea how to proceed from here. Can some kind soul point/handhold me in the
right direction?
Thanks. :-)
--
Tim DeBoer
http://www.freebsd-geek.com
Just once, I'd like it if someone called me "Sir".
Without adding "You're creating a scene".
Alternatively, you could try something like this :
SET @rownum = 0;
SELECT @rownum := @rownum + 1 AS rownumber_column,
some_real_columnnames
FROM your_table
LIMIT 100
-Original Message-
From: Clyde Lewis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 25, 2006 3:14 PM
To: [EM
me value where Account.city matches City.ID.
I need the most efficient way to do this: examples, keywords, and
URLs to relevant documentation are all welcome.
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For li
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [060223 09:09]:
> Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM:
> > I need the most efficient way to do this: examples, keywords, and
> > URLs to relevant documentation are all welcome.
<>
> First o
CREATE TABLE `test`.`A` (
`X` INTEGER,
`Y` INTEGER,
`Z` INTEGER,
UNIQUE `unique_x_y_z`(x,y,z)
)
ENGINE = MYISAM;
insert into a (x,y,z) values (1,2,3);
insert into a (x,y,z) values (1,1,3);
insert into a (x,y,z) values (1,2,3);
3 Duplicate entry '1-2-3' for key 1 #1062
-Original Mes
y
question(s). I.e., only the fact record is necessary if you must answer at
least one question to be "interesting".
Seems almost like a text book example ("The solution is left as an exercise
for the reader" ;-)
Have I missed something?
Tim
-Original Message-
Fr
Would you not lock tables on the slave? The idea of catching it up implies
this is way it is done. Catching up means once replication can proceed once
the tables are unlocked (on the slave).
At least that is the way I read it...
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto
x27;localhost' (using
password: YES)
Can someone give me a nudge/push/drag me kicking and screaming in the right
direction?
Thanks everyone :)
--
Tim DeBoer
Since MySQL is one of our tools, we would like to have
a logo that we can use at our website. And we will use
it to link back to the MySQL site.
Can someone point me to MySQL logos that I can legitimately
use?
Thanks
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
8
format before putting it into MySQL - the problem is some of these csv's
are several hundred mb a piece so I'd much rather simply import than go
this route.
Any thoughts?
TIA,
-Tim
|
t could totally be implemented as a
configurable option, something like a simple my.cnf setting that says
"slave_pass_upadtes_to_master" or something.
Has anyone suggested anything like this before? Any thoughts/comments/flames?
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t..
e server problem, not an application problem.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
raphically redundant.
So yeah, maybe lots of custom-written software handles the read/write split
configuration well, but there's lots more that doesn't. I don't know of a
single open source application that does.
So again, I go back to my original statement: replication is a data
ation that I'd like
to see in mySQL. If you don't like my idea, don't use the feature if and when
it ever comes into being.
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
t...@soe.ucsc.edu
831-459-5354
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
n read-heavy environments. As I mentioned
before, my main goal here is geographic redundancy, load balancing and the
ability to use applications that aren't really designed to be used with
master/slave replication (Drupal, WordPress, etc) without having to modify
those applications.
Hello,
I am importing CSV data from a proprietary database into a table in MySQL. Due
to a flaw in the proprietary software's export tool, currency values (floats)
are always exported with a '$' prefixed to them. This causes a problem where
the matching float field in the MySQL table being se
1 - 100 of 585 matches
Mail list logo
