Don't forget to allow port 3306 (or whatever port you're server listens on)
through any Windows firewall...
Tim
-Original Message-
From: Carlos Proal [mailto:[EMAIL PROTECTED]
Sent: Friday, June 22, 2007 1:40 PM
Cc: mysql@lists.mysql.com
Subject: Re: How do you allow external
I'm partial to SQLYog. http://www.webyog.com/ -- community and enterprise
editions are available. Former is free, latter is cheap.
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, June 04, 2007 2:17 PM
To: mysql@lists.mysql.com
Subject:
-Original Message-
From: Miguel Cardenas [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 26, 2007 8:21 AM
To: mysql@lists.mysql.com
Subject: Avoiding TIMESTAMP
Hello list
I need to solve a little problem but don't mind how, maybe you could
suggest
something.
I have a database
I can give you a rough estimate:
My /data partition is 67G. The gzipped output of mysqldump is 20G. It
takes about 53 minutes. Extrapolating to 100G would give (50% more) about
78 minutes.
On a Dell 2950 running Xeon 5160/3GHz (4 cores), 8Gb memory, RAID 10 15K rpm
drives (Perc 5/I SAS I
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 7:55 AM
To: Ofer Inbar
Cc: mysql@lists.mysql.com
Subject: Re: expire_logs_days
Hi,
Ofer Inbar wrote:
There's a system variable called expire_logs_days that lets you set a
number
-Original Message-
From: Pete Harlan [mailto:[EMAIL PROTECTED]
Sent: Friday, April 27, 2007 5:15 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: My bin.log directory is getting full
Perhaps the expire_logs_days variable does what you're looking for.
If you google
# cat /etc/cron.mysql/20-purgemasterlogs
#!/bin/sh
/usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
master logs before date_sub(now(), interval 30 day); show master logs;'
/var/log/20-purgemasterlogs.log 21
This purges anything older than 30 days.
HTH,
Tim
-Original
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, April 20, 2007 3:16 PM
To: Michael Higgins
Cc: mysql@lists.mysql.com
Subject: Re: advice for blob tables?
At any rate - based on my experience with the Sybase system I managed, I
would advise you to
-Original Message-
From: John Comerford [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:50 PM
To: mysql@lists.mysql.com
Subject: Millisecond time stamp
Hi Folks,
I am putting together a table to hold log entries. I was going to index
it on a field with a type of
Nobody has any idea(s) on this?
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Friday, April 06, 2007 7:11 PM
To: [EMAIL PROTECTED]
Subject: MySQL slave error when creating view
I ran the following DDL on our master today:
CREATE OR REPLACE VIEW
I ran the following DDL on our master today:
CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE (
IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS
SELECT
0, TDISTRICT_NAME, IORG_UID, IORG_UID
FROM REF_PREFERENCE
;
The master happily created the view. The slave however dies with:
-Original Message-
From: Maciej Dobrzanski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2007 6:46 AM
To: mysql@lists.mysql.com
Subject: Re: Why doesn't the InnoDB count() match table status?
MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
spreadsheet,
FYI - Monday AM, Norton A/V started reporting the uninst.exe and the
sqlyog525.exe files as infected with 'Virus Burst'. This is due to a
NullSoft installer signature problem. SQLyog527 has been released, built
with a newer NullSoft installer, AND the virus definitions from today no
longer
-Original Message-
From: murthy gandikota [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2007 6:05 PM
To: mysql@lists.mysql.com
Subject: What does NOW() return: linux time or something else?
Hi
I tried to look up the time functions specifically for the disparity
between
I don't know if this is optimal or not, but it does work...
DROP TABLE IF EXISTS `x`;
CREATE TABLE `x` (
`id` int(11) default NULL,
`path1` varchar(10) default NULL,
`display` varchar(10) default NULL,
`value` varchar(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into x
I trade between SQLYog and SQL Exporer plugin for Eclipse. The former only
shows 1 result set at a time (boo) while the latter shows more than one
(yeah!) The former doesn't let you sort columns from your own query, only
the table preview. The latter doesn't let you sort the columns.
Neither
I have upgraded to 5.25 today and it is true. Outstanding!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 15, 2007 12:16 PM
To: mysql@lists.mysql.com
Subject: RE: Is there a professional quality mySQL GUI for Linux?
Tim Lucia [EMAIL
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 4:57 AM
To: mysql@lists.mysql.com
Subject: Breaking Up Tables
Hi;
I have an unusual problem. My current production server's OS is corrupt
and I'm building a new one. However, due
I've use MS Visio's Reverse Engineer database feature to find the FK
relationships between tables. I'd bet there are other tools which do
something similar, probably even free ones.
Tim
_
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 2:36 PM
To:
Is mysqlhotcopy still considered beta? We steered clear of it for
production use for that reason.
Tim
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Monday, November 13, 2006 12:39 PM
To: Van
Cc: mysql@lists.mysql.com
Subject: Re: Backing up large dbs with tar
How about
select ID, X, Y, Z from USERS order by ID desc limit 1
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 10, 2006 5:47 PM
To: mysql@lists.mysql.com
Subject: MAX() and GROUP BY question
Hello everybody
Can you explain me please
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@lists.mysql.com
Not quite...
mysql select 'zebra' = 'm' AND 'zebra' = 'z';
+---+
| 'zebra' = 'm' AND 'zebra' = 'z' |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql select 'seal' = 'm'
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 2:43 AM
To: Dan Trainor
Cc: Kaushal Shriyan; mysql@lists.mysql.com
Subject: Re: Incremental Backup
Dan Trainor wrote:
Kaushal Shriyan wrote:
Hi ALL
I would like to know following 2
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, Kaushal Shriyan [EMAIL PROTECTED
-Original Message-
From: Obed Soto Déctor [mailto:[EMAIL PROTECTED]
Sent: Monday, July 17, 2006 7:28 PM
To: mysql@lists.mysql.com
Subject: problem with double data
Hi, i'm sorry for my english, i'm from México and i'm gonna do my best,
i've made a store procedure but i have
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.
-Original Message-
From: Chris White
I've seen whitepapers from MySQL's web site, co-authored with Dell, that
recommend the hardware optimization be:
1. More Memory
2. Faster Drives (15K RPM is better the 10K)
3. Faster CPU.
Based on this, we're spec'ing 2950s with 16Gb, dual 2.8 dual-core Xeons, and
146Gb 15K (times 6) drives.
-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've seen whitepapers from MySQL's web site
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 mysqlhotcopy
requires
-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 considerations, yes.
In my mind neither
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 29, 2006 6:01 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Recommended backup scripts for mysql databases
That's a good thought, Tim - file grep could provide a quick means to
access the data
Hello List,
Has anyone seen any problems using LOAD DATA FROM MASTER on a second slave
using a secondary network interface?
I have:
mysql-master / {172.25.7.20 / eth0, 192.168.7.20 / eth1} / Red Hat EL V.4 /
MySQL 5.0.22
mysql-slave1 / 172.25.1.58 / Windows XP / MySQL 5.0.18
mysql-slave2 /
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 Xeon 3.8
I'm running on a Xeon 3.8 under RHEL V.4. I wanted to try out mysqlhotcopy,
but it says I need DBD::mysql. Cpan gets it for me, but make DBD::mysql
dies with the below error. I am using 5.0.18 standard
(MySQL-server-standard-5.0.18-0.rhel4). Attempting to install
perl-dbd-mysql off the RPMS
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
rsync is a *nix utility that synchronizes two file systems, one local and
one remote (typically). It is used to produce mirrors / backups / etc. You
would not want to use it to synchronize database (raw) files via the file
system.
If you include a timestamp field, you can use that to copy
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 another
Can you run rsync
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:
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
-Original
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:37 PM
To:
PROTECTED]
Sent: Monday, May 08, 2006 4:33 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Connection Pooling
What i meant by implementing connection pooling i meant if i need to do any
code changes other than changes in connection string.
Thanks,
Romy
On 5/8/06, Tim Lucia [EMAIL PROTECTED
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
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:
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
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
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;
: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 18, 2006 11:35 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Document / Image (Blob) archival -- Best Practices
Tim Lucia wrote:
Hi all,
I am considering moving some archival records which largely consist of
blobs
(PDF Image
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
Hi all,
I am considering moving some archival records which largely consist of blobs
(PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this
(not necessarily the Oracle part) who can relate their experience(s)? I can
go with MyISAM or archive storage engine, from the looks
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: Sunday, April 16, 2006 8:33 AM
To: Tim Lucia
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]
Haven't you answered your own question? From my reading of this question,
there are four entity tables (student, module, question, answer) and three
or more relation tables (association tables) student-module,
module-question, question-answer. There are probably two of the last one -
one which
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
54 matches
Mail list logo
