Thanks, that did it!
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2008 11:57 AM
> To: Jeff Mckeon
> Cc: mysql@lists.mysql.com
> Subject: Re: delete query question
>
> Jeff,
>
> >Table2.ticket = t
> -Original Message-
> From: Ian Simpson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2008 11:27 AM
> To: Jeff Mckeon
> Cc: mysql@lists.mysql.com
> Subject: Re: delete query question
>
> If the tables are InnoDB, you could temporarily set up a foreign ke
I think this is possible but I'm having a total brain fart as to how to
construct the query..
Table2.ticket = table1.ID
Table2 is a many to 1 relationship to table1
I need to delete all records from table1 where created <
unix_timestamp(date_sub(now(), interval 3 month))
And all rows from table
DUH!!!
LOL, I'm an idiot..
Gonna go flush my head down the toilet now.
Thanks guys.
From: William Newton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 1:29 PM
To: Jeff Mckeon; MySql
Subject: Re: Error: No query specified
I'm guessing you are addi
y body has tried this
> > >
> > > On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati <
> > > [EMAIL PROTECTED]>
> > > wrote:
> > >
> > > > Yes, Is it possible or not
> > > >
> > > > -Krishna Chandra Prajapati
> >
When I run a "Show slave status \G" I get a message at the bottom that says
"Error: No query specified"
I don't recall ever seeing this before and can't find anything online about
it. Anyone know what it means?
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Repli
-Original Message-
> From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 05, 2007 8:09 AM
> To: MySql
> Subject: REPLICATION
>
> Hi,
>
> I am working on production and thinking of implementing chain
> replication
> A->B->C. A is replicated to B. B is bei
> -Original Message-
> From: Marcus Claesson [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 03, 2007 7:49 AM
> To: mysql@lists.mysql.com
> Subject: Help with SQL query construction
>
> Hi!
>
> I have a "SQL query construction" question that I hope someone can help
> me with. After c
> -Original Message-
> From: Osvaldo Sommer [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 01, 2007 8:23 AM
> To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com
> Subject: RE: backup InnoDB db to another server
>
> Jeff:
>
>
> -Original Message-
> From: js [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 01, 2007 8:11 PM
> To: Jeff Mckeon
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> You might want to use --single-transaction
> -Original Message-
> From: David Campbell [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 30, 2007 11:29 AM
> To: mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> Jørn Dahl-Stamnes wrote:
> > On Friday 30 November 2007 17:12, Jef
> -Original Message-
> From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 30, 2007 11:16 AM
> To: mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
> > Ok, s
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, November 30, 2007 11:06 AM
> To: Jeff Mckeon
> Cc: mysql list
> Subject: Re: backup InnoDB db to another server
>
> On Nov 30, 2007 10
I'm trying to use mysqldump to backup an innoDB based db from one server to
an sql file on another. It doesn't seem to be working however...
Here is the command I'm using on the source server
mysqldump DB1 -uroot -ppassword | mysql --compress -h 10.10.0.1 -uroot
-ppassword DB1 > /DATA/DB1backup.
Hey all,
I've got a new server set up, with dual Intel quad core processors, 4 gig of
ram, OpenSuse 10.3 (64bit) and MySql 5.0.45.
The majority of the tables are MyISAM with a few InnoDB here or there. I'm
using the huge-my.cnf as the base for my config.
Can anyone suggest some tweeking to th
Excellent Dan!
Thanks!
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thu 6/29/2006 4:35 PM
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Mysqlhotcopy and replication
Jeff, that is i
> -Original Message-
> From: Nathan Gross [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 08, 2005 13:58
> To: mysql@lists.mysql.com
> Subject: Optimize: 14 hours and still running!
>
>
> On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
> I have an Innodb table with over 20
> "Jeff" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:47:52 AM:
>
> >
> > > Jeff wrote:
> > > >
> > > > Ugh...
> > > > mysqladmin -uroot -ptelaurus processlist | grep -c
> "Sleep" And it
> > > > returned 200 sleeping connections, all persistant
> > > connections
> > > > from our app servers and
laves are
> up to 4.1.13.
>
> If you can - upgrade the master server.
>
It's in the plans but that is our main production server so it's not
something we can just do at any time. I've upgraded the slaves first
because generally you can replicate from an older version
> Jeff wrote:
> > Had problem with our database this weekend, apparently an
> app did an
> > insert query that was huge size wise and this totally boogered up
> > replication downstream. Also I cant read past that point in the
> > binlog using mysqlbinlog on the master server. It complains that:
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 21, 2005 08:55
> To: mysql@lists.mysql.com
> Subject: Timezone setting wrong?
>
>
> I've got a RHEL3 server I just installed with mysql 4.0.16.
>
> The hardware clock and system clock are both set t
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 16, 2005 11:55
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Circular Replication
>
>
> Jeff wrote:
> >
> > Am I correct in this setup process:
> >
> > Server A exists
> > Server B to be
Yes, that's the way we currently do it but we were looking for more
options.
Jeff
> -Original Message-
> From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 16, 2005 11:26 AM
> To: Jeff McKeon
> Cc: mysql@lists.mysql.com
> Subject: Re: Backing
Anyone using any third party products like Arkeia that enable you to do
a live backup of MySQL database?
I'm searching for a backup solution for our new data center and would
like to here what other people are using for MySQL.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http:
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
> -Original Message-
> From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 03, 2005 2:24 PM
> To: Jeff McKeon; mysql@lists.mysql.com
> Subject: R
Hello,
Anyone here run mysqlhotcopy? I've read the docs on it but they are
basicly just a howto and don't go too in depth. I've got a DB that is
the back end to a 24/7 application. I ususally do backups from a
replicated db by shutting down the Replicated DB then doing a tar are
all the db file
-
> From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 18, 2005 2:16 PM
> To: Jeff McKeon; mysql@lists.mysql.com
> Subject: RE: Restoring a database from binlogs
>
>
> Dump the binarylogs into a text file greping all the log data
> in order of oldest to
Hey all,
I've got a big problem. Seems one of our programmers decided to write a
script that deletes all records from a log table older than 3 months.
Problem is, we need old data from this log to reconcile our customer
accounts.
Our backups only go back 2 weeks. What I do have however is rep
April 25, 2005 4:36 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: RE: Query question
"Jeff McKeon" <[EMAIL PROTECTED]> wrote on 04/25/2005
04:08:29 PM:
> Thanks all but I don't have a mysql versi
3.23.
no control over this right now or i'd upgrade, believe me!
jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:43 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re:
Peter,
I'm unfamiliar with the "@d := " section you describe. Is this psudo
code or real syntax?
thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:17 PM
To: Jeff McKeon
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 25, 2005 4:01 PM
> To: Jeff McKeon
> Cc: mysql@lists.mysql.com
> Subject: Re: Quer
I have a table that contains records that link back to a main talbe in a
many to one configuration linked by table1.id = table2.parentid
Table1 (one)
Table2 (many)
I want to pull the latest records from table2 for each record in table1
where certain criteria applie.
So, if record 100 in table1 l
Yeah I thought of that but was hoping not to have to use a temp table.
Thanks!
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 05, 2004 9:25 AM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Update query help
Break it down into two
I have two tables. One has a list of customers. The other has a record
of customer transactions including unix datestamps of each transaction.
I've added a field to the customer table called "First_Transaction"
I want to update this field with the datestamp of the first transaction
for each cust
Hello all,
We had a power outage this morning and before we could shut down our
main MySQL server, power to it was lost. Bad UPS battery. Long
story.
We replicate this server to two others. On one I get the following
error...
Jeff McKeon
IT Manager*** 1. row
Is there a way to get the output of a "select into outfile" statement to
have the column headers in it and not just the data?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a way to force the use of a specific index when issuing a
select querie?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or all the explanations..
Jeff
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 25, 2004 2:41 PM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Very Strange data corruption
>
>
>
> Jeff,
>
> You are try
Query:
insert into
MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk2,pin1,pin
2,TwoStage,Status,DateAssigned,DateDisabled,UserID)
VALUES('NULL', '6889927707', '1', '8988169214000421398', '881621456175',
'', '', '881693156175', '62982149', '', '', '', '1307', '1',
'1085508771',
I have to re-create a table every month with a section of data from the
main table. I suppose this would be an excellent situation to use views
for but being as how MySQL doesn't have view capability yet I'm stuck
with this. It's not a big deal but I just want to make sure that
Creating, populati
ile = '',
Master_log_pos = ;
Mysql:> Slave Start;
Does anyone see a problem with this method?
Thanks,
Jeff
> -Original Message-
> From: Jeff McKeon
> Sent: Thursday, April 08, 2004 8:54 AM
> To: [EMAIL PROTECTED]
> Subject: Corrupted relay log
>
>
>
Is there any way to fix a corrupted relay log on a slave?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ate
any indexes the table had when it recreates the table?
Thanks for the help!
Jeff
> -Original Message-
> From: Chris Nolan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 9:35 PM
> To: Steve Edberg
> Cc: Jeff McKeon; [EMAIL PROTECTED]
> Subject: Re: Does Dro
Quick question...
What you drop a table are the indexes for that table dropped to?
I'm about to write a script to take a data pull every night and
re-populate a table with the results, then have my apps run off of the
new consolidated table for a speed increase. If I drop the Consolidated
table,
relay log, you will be able to know their names by issuing 'SHOW SLAVE
STATUS' on this slave.
Skip_counter: 0
Exec_master_log_pos: 723207989
Relay_log_space: 14059362
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The informa
> -Original Message-
> From: Tobias Asplund [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 22, 2003 11:21 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication Question
>
>
> On Mon, 22 Dec 2003, Jeff McKeon wrote:
>
> > Is i
Is it possible to have 2 database on one server replicating from the
same Master server?
In other words. DB01 is the Master on System01,
System02 has DB01_rep1 and DB01_rep2, each with their own replication
from DB01.
I need to do this to have a development copy of DB01 on System02. I
have prod
Damn fat fingers and MS Outlook. I sent the "Query Help" message before
I was finishes typing. Sorry...
I have two tables, customer table and a company table
The customer table has an ID field that is 8 characters long. The first
4 characters are the company code.
We just added a company tabl
Acme_Europe
What I now need to do is create an update statement that will match the
customer to the company by substring(Customer.ID,1,4) to Company.ID
I tried:
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in
I'm trying to search a table for duplicate entries.
A record is a dup if fields Fee, Fie, Foe are equal in two records.
Would this query be correct to search the table for duplicates?
Select Fee,Fie,Foe
>From TableFoo
Group by Fee,Fie,Foe
Having Count(*) > 1;
Thanks,
Jeff
--
MySQL General Mail
We have a database that supports our customers and runs pretty much
24/7/365. Obviously we need to keep this database healthy and
optimized. I've read the official documentation and third party books
on MySQL and they all are very good at explaining what should be done
and how to do it but none t
IL PROTECTED]
> Subject: Re: Strange behavior on insert
>
>
> On 20 Nov 2003 at 11:12, Jeff McKeon wrote:
>
> > However when I go to the database and do a "select * from
> tablename;"
> > the records are in the table in the reverse order!!
> >
&g
I have a PHP page that takes data from a form and inserts it into a
table:
Show columns:
+++--+-+-+--
--+
| Field | Type | Null | Key | Default | Extra
|
+++--+-+-+---
ginal Message-
> From: Jeff McKeon
> Sent: Wednesday, November 19, 2003 4:54 PM
> To: [EMAIL PROTECTED]
> Subject: Mysql server time setting.
>
>
> I have two servers replicating. Server one to server two.
>
> If I do a show variables on server one it show the timezone
I have two servers replicating. Server one to server two.
If I do a show variables on server one it show the timezone as EST, on
server two it shows it as GMT. Where is this set and how can I change
server one to GMT?
The linux box itself, that mysql server one runs on is set for GMT
Thank
I have a table that has a field type DOUBLE. I need to put into it data
like '0.123' however any number less than .0001 (like .999) show
up in the field like '1e-05'
Also when I retieve the field in a PHP page it is return like '1e-05'.
Do I have the wrong column definition or am I doing
Yes there was a syntax error. I used an "and" instead of && in the
where clause.
However, my concern is that the error message was truncated.
Jeff
> -Original Message-
> From: Victor Pendleton [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 9:53 A
I just upgraded to Server version 4.0.15-standard, I just tried to do a
query and got a syntax error but the error message is incomplete.
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'where Remot
Is is possible to do a select query with a left join from a real table
to a temporary table? I'm trying it but keep getting "unkown table
'tablename' in field list" error.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Is there a way to abort a query after it's running?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ff
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 4:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Detect temporary tables
>
>
> "Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> > I know I can i
I know I can issue "show tables" to give me a list of tables from the
current database, how can I do the same thing with temporary tables?
That is, is there a command to list the current temporary tables?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
te it to a file?
Jeff
> -Original Message-
> From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2003 2:11 PM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Challenging query
>
>
>
> On Thursday, October 16, 2003, at
t['CustomerID'] ] = $result['Revenue'];
> }
>
> The result will be a simple multi-dimensional array with a
> minimal SQL
> query and minimal application code.
Jeff
> -Original Message-
> From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
> Sen
> If you have a way to generate the query code dynamically
> (e.g. using a loop in C, PHP etc.), you can build a query
> using aliased tables :
>
> SELECT YEAR(a.date) AS year, MONTH(a.date) AS month,
> SUM(a.revenue) AS cust1_rev,
> SUM(b.revenue) AS cust2_rev, SUM(c.revenue) AS cust3_rev
> F
as I know, there is no [easy?] way to generate dynamic columns
> in the result set like you're looking for. You can generate
> it the way
> I described and then manipulate that data into your desired format in
> the application layer.
>
> - Gabriel
>
>
> On
w | blah | blew |
| row | blah | blew |
Jeff
> -Original Message-
> From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2003 11:40 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Challenging query
>
I have a table that contains customer revenue information.
REVENUE TABLE:
Date, customer name, CustomerID, revenue, quantity
I need to create a query that will produce the following result
Year, Month, Customer1_rev, customer2_REV, customer3_rev, etc...
2002, 01, 0, $30.00, $15.00
2
Never mind,
I used the show create table Mailbox results as my create table
supermailbox query and it worked.
Thanks
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 11:59 AM
> To: Jeff McKeon; [EMAIL PROTECTE
Priority tinyint(4), ReadFlagSent int(11), Accounting int(11), QRG
tinytext, Modulation tinytext, RetryCount tinyint(4), LastTry int(11),
RemoteFaxID tinytext,
LLCharge tinytext, LLTime int(11), LLPages int(11), ExternalSerial text,
GPS tinytext, Price Double, User_ID int(11),Pay_ID int(11),
Tarif_I
aul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 11:19 AM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE: Data from two tables in one query
>
>
> At 11:14 -0400 10/14/03, Jeff McKeon wrote:
> >Paul,
> >
> >> - Original post
m the two tables I'm
merging or can I just grab the ones I want?
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 10:54 AM
> To: Rory McKinley; Jeff McKeon; [EMAIL PROTECTED]
> Subject: Re: Data from two tables in
We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon
but we're not ready yet.
I have two tables that are identical, table1 and table1_old. Table1_old
contains all data writen to table1 prior to july of 2003.
I need to do a single query that pulls the same fields from both tab
The way I usually do it is this..
I have a shell scipt called "query"
It contains:
/fullpath/mysql --user=root --password= Database_Name
I then make new scripts for the queries as such:
(query file name: Select_all.sql)
Select * from Table where blah=foo;
To run this I then execute
Put the full path to mysql in the script...
Jeff
> -Original Message-
> From: Mike Tuller [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 10, 2003 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: Shell Script to Insert Data
>
>
> I am trying to create a script that will insert data. Righ
I have two columns in a table, both timestamp(14). The first one holds
a start date and the second one holds an end date. Is there any built
in mysql function to subtrack timestamp1 from timestamp2 and get the
elapsed time between?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives:
> At 4:22 PM -0400 9/19/03, Jeff McKeon wrote:
> >We've got mysql 3.23 installed on a redhat system via the rpm's that
> >come with RedHat 8.0. I'd like to change the default data
> directory so
> >something other than /var/lib/mysql. I know this is s
We've got mysql 3.23 installed on a redhat system via the rpm's that
come with RedHat 8.0. I'd like to change the default data directory so
something other than /var/lib/mysql. I know this is supposed to be
possible with a start switch of --datadir=/path/to/data but it doesn't
seem to work.
Th
That's what I thought. Thanks for the advise!! :o)
Jeff
> -Original Message-
> From: Joseph Bueno [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 9:26 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Subject: Re: Joining tables from two different
I have an existing database with a lot of information, I need to create
a new database to record inventory information that pertains to records
in the first database. I'd like to keep these two database's separate.
Is it possible to relate a record in one database to a record in another
and do qu
All,
I'm looking for opinions/suggestions on a backup procedure I plan on
implementing.
All databases (DBXX) will be MySQL ver 4.0
All our applications work with DB01.
DB01 replicates to DB02.
Once a day I will Stop the slave on DB02, lock the tables, flush the
logs and perform a mysqldump of
We are currently running production on ver 3.23. We have two db servers
that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing
latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2
making it the new DB1
All,
I'm looking for opinions/suggestions on a backup procedure I plan on
implementing.
All databases (DBXX) will be MySQL ver 4.0
All our applications work with DB01.
DB01 replicates to DB02.
Once a day I will Stop the slave on DB02, lock the tables, flush the
logs and perform a mysqldump of
We are currently running production on ver 3.23. We have two db servers
that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing
latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2
making it the new DB1
> >
> > We've got our 3.23 db installed with all the data on the /home
> > partition which is ok. The *-bin.00x logs are also in that data
> > directory. The Var/log/mysql/mysql.log however on our root
> drive has
> > grown to 11gig. Our Root partion is not as large as our
> Home partition
Quick log question...
We've got our 3.23 db installed with all the data on the /home partition
which is ok. The *-bin.00x logs are also in that data directory. The
Var/log/mysql/mysql.log however on our root drive has grown to 11gig.
Our Root partion is not as large as our Home partition and I n
Nobody has any advice for this one?
Jeff
> -Original Message-
> From: Jeff McKeon
> Sent: Tuesday, August 19, 2003 8:22 AM
> To: [EMAIL PROTECTED]
> Subject: Replication question
>
>
> Hey all,
>
> I have 3 databases replicating (ver 3.23) A to B
Select monthname(yourdatefield) as month, year(yourdatefield) as year,
count(*)
>From yourtable
Group by year, month;
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is inten
Hey all,
I have 3 databases replicating (ver 3.23) A to B and B to C
On C I want to modify one of the tables and add a column. Tables A and
B will not have this new column added. Will this cause a problem
replicating data form B to C?
Thanks,
Jeff
--
MySQL General Mailing List
For list arch
Ok, I know it WAS there because we have two similar tables that should
contain sister records. One table has a record the other doesn't so it
had to have been deleted. I need to find out WHEN it was deleted.
How do I create a log of record deletes?
Jeff McKeon
IT Manager
Tel
>
>
> > Ok, I know it WAS there because we have two similar tables
> that should
> > contain sister records. One table has a record the other
> doesn't so
> > it had to have been deleted. I need to find out WHEN it
> was deleted.
> >
> > How do I create a log of record deletes?
> >
>
>
How can I see if a record was deleted from a database?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ver. 3.23
How do I write a select query to join more than two tables?
Table A relates to table B and table B relates to Table C.
I need to return fields from Table A and C that are related..
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Thanks, that did it!
Jeff
> -Original Message-
> From: Kevin Fries [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 04, 2003 3:05 PM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE: Query Help
>
>
> So you want to group by the customer, but only show t
I have a table that records connections from customers to our server.
When there is a software problem with our customer's that have older
versions of our software, it will dial our server constantly over and
over again.
I want to be able to detect this by having a query that does something
like
Nobody has any ideas on this one?
Jeff
-Original Message-
From: Jeff McKeon
Sent: Friday, July 25, 2003 3:23 PM
To: [EMAIL PROTECTED]
Subject: rights to create table, select, then drop table..
I have a need to get data from the db that requires me to
1) do a select and create a new
How bout
Delete from tablename where email like [EMAIL PROTECTED] && ID <> 1
Jeff
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 10:33 AM
> To: [EMAIL PROTECTED]
> Subject: Deleting duplicating records
>
>
> Greetings
>
> I manage
cesslist |
+-+--+-+--+-+---+---
--+--+
51 rows in set (0.00 sec)
Jeff McKeon
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 25, 2003 10:16 AM
> To: Jeff McKeon
> Cc: [EMAIL PROTECTED]
> Su
Variable_name: wait_timeout
Value: 28800
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privi
1 - 100 of 123 matches
Mail list logo
