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 c
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: Ad
> -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 hav
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 belie
> -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
> -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 doe
# 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 2>&1
This purges anything older than 30 days.
HTH,
Tim
> -Origi
> -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 y
> -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
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:
>
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:
07
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 quaran
> -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
> spreads
> -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
>
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 va
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?
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 on
> -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. Howe
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
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:
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 ho
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'
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,
> -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 kno
> -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
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.
>
>
> -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&
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.
The
nded?
Tim
> -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
> -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
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
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 / 19
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
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 dir
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
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
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 across
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
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 Message-
lto:[EMAIL 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 <[EM
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: mysql@l
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 PR
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@lists.mysql.co
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
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
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@list
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
-
From: 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 c
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
unday, April 16, 2006 8:33 AM
To: Tim Lucia
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: Right column type for OLE objects
But what about size. I reffered MySQL manual for 5.0, but didn't find
that what is he maximum size of binary data we can store in such
column.
Please help
Thank
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:[E
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 ho
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
54 matches
Mail list logo
