Re: True/False data type

2004-11-04 Thread Jeff Smelser
, `trnsfr` char(1) default 'n', PRIMARY KEY (`id`) ) TYPE=MyISAM Jeff pgp8Z1dDKHSNN.pgp Description: PGP signature

Update query help

2004-11-05 Thread Jeff McKeon
customer from the Transaction table. I tried this... UPDATE Customer,Transactions set Customer.First_Transaction = MIN(Transactions.Datestamp) Where Customer.ID = Transactions.CustID But this doesn't work because of MIN() grouping. I'm stumped, anyone know how to accomplish this? Thanks, Jeff

RE: Update query help

2004-11-05 Thread Jeff McKeon
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

Re: replication problems

2004-11-09 Thread Jeff Smelser
daily notifempty compress rotate 2 } Jeff pgp7Axkk8RKjY.pgp Description: PGP signature

Re: replication problems

2004-11-09 Thread Jeff Smelser
as well.. There is a default login in mysql, I think your getting in as that, but not able to do anything.. Make your your host variables are right.. Check your logs to make sure your getting is as who your expecting to be.. (show processlist even). Jeff pgpa5Z4LVImkC.pgp Description: PGP

Re: Test post to test new client

2004-11-14 Thread Jeff Smelser
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote: I'm posting to test a new newsgroup client. Please post several replies. Does it work with mysql? Just curious. Jeff -- === Jabber: tradergt@(smelser.org|jabber.org

Re: syntax question..

2004-11-14 Thread Jeff Smelser
.. select * needs to be a field.. like zip. Jeff -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: I don't miss deadlines, I ignore them

Re: myisam table corruption

2004-11-15 Thread Jeff Smelser
those indexes on there. that just slows down inserts. Jeff pgpaA9bNx47Mt.pgp Description: PGP signature

Re: myisam table corruption

2004-11-15 Thread Jeff Smelser
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote: insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken out. Course thats 4.0.18. pgpBoy3BGuPlh.pgp Description: PGP signature

Table # of rows changing?

2004-11-16 Thread Jeff Burgoon
I have table with 83,065 rows. Each time I go to MySQL Administrator and look at the catalogs, the number of Rows reported by the administrator changes. I can keep clicking refresh and the number of rows fluctuates between roughly 81,000 and 86,000. I also see similar behavior when I access the

Re: Table # of rows changing?

2004-11-16 Thread Jeff Burgoon
Thanks. Makes sense ... but strange. Jeff Brent Baisley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] It's because the table type is InnoDB. InnoDB tables can only give and estimate of how many rows are in the table. That's just the way InnoDB works. From the manual: SHOW

Re: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread Jeff Smelser
as work arounds. When they update DBD::mysql this should go away. There is a new version for this.. DBD-mysql-2.9004 I think thats the version that started supporting it. Jeff pgp06SFsJVeZj.pgp Description: PGP signature

Re: how to create views in mysql4.1

2004-11-21 Thread Jeff Smelser
On Sunday 21 November 2004 08:38 am, Dayakar wrote: Can any one help me in creating view using mysql4.1. If we cannot then any other alternative. It would be great if anyone give me an example for that. Thats a 5.0 feature.. Your not gonna get to far with 4.1.. Jeff

Re: 4.0.18 - 4.1.7 LEFT JOIN problem

2004-11-22 Thread Jeff Smelser
On Monday 22 November 2004 04:15 pm, Santino wrote: I can confirm it anyway: I think we have a bug.. Unless someone else see something, might want to take this to bugs.mysql.com Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 578 to server version:

Re: I need to understand INNO better.

2004-11-23 Thread Jeff Smelser
.. This is assuming your not coping the entire db directory tree.. Maybe someone else knows of another. Jeff pgp9Z7ari8lOX.pgp Description: PGP signature

Re: I need to understand INNO better.

2004-11-24 Thread Jeff Smelser
.. ;) Jeff pgpv5iABnmP3v.pgp Description: PGP signature

Re: upgrade from mysql 3.23 to 4.1

2004-11-24 Thread Jeff Smelser
to. Jeff pgpQkZExiFA1H.pgp Description: PGP signature

Re: upgrade from mysql 3.23 to 4.1

2004-11-29 Thread Jeff Smelser
to test these new features in 4.1.. Might want to look for that in 3.23.. Jeff pgpomOHXppHgb.pgp Description: PGP signature

Re: upgrade from mysql 3.23 to 4.1

2004-11-30 Thread Jeff Smelser
route. These major upgrades are no small tasks anyway. Jeff pgpV2KwnnCgL1.pgp Description: PGP signature

Re: Question after installing 4.1.7

2004-11-30 Thread Jeff Smelser
On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote: I had installed MySql on Win2003, and when I check the 'server information' page, it shows a IP of 127.0.0.1. The IP of the server has a 192.x.x.x address. Change the line below in my.cnf to what you need.. Its binding to 127 ip. #

Re: upgrade from mysql 3.23 to 4.1

2004-12-02 Thread Jeff Smelser
plan. Jeff pgpNKQ0K5Llcr.pgp Description: PGP signature

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
do you even know that affects you? Jeff pgpeYgKL0ynpT.pgp Description: PGP signature

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote: The following thread appeared in the FreeBSD list: snip Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can affect me. I may have missed it, but myisam, or innodb? Jeff pgpSqggIBC6My.pgp Description: PGP signature

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
'. These are all on myisam tables. Jeff pgpruzBlF9R3z.pgp Description: PGP signature

Re: 4.0 vs 4.1

2004-12-07 Thread Jeff Smelser
with MySQL + FreeBSD-4.x, I´m afraid that the table could crashs when MySQL hangs... :-/ Sounds like a local issue, not mysql.. I would go after that over bandaging mysql. Jeff pgpRjYfpgJ4bj.pgp Description: PGP signature

Re: slow date query

2004-12-07 Thread Jeff Smelser
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote: A function on the left hand side will nullify the use of an index. Sides dont matter, a function on an index, no matter what side, will kill an index. Jeff pgpsVFJcgS9kp.pgp Description: PGP signature

Re: slow date query

2004-12-07 Thread Jeff Smelser
where date1.date = date2.date; The above query, no matter which side you use a function on, will cause the index to be thrown.. Jeff pgpCPAUJk2r7Y.pgp Description: PGP signature

Re: MYSQL is getting slow

2004-12-09 Thread Jeff Smelser
before the machine stop responding ? HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB. What table type you using? Jeff pgpaVttIiLwf1.pgp Description: PGP signature

Re: MYSQL is getting slow

2004-12-09 Thread Jeff Smelser
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote: and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then dit from the commandline create database and then run the create table commands from snort. No idea.. you can do a show create table db.table to find

Re: optimizing InnoDB tables

2004-12-16 Thread Jeff Barr
rename the files in step 3, just in case, right? Jeff; On Fri, 8 Oct 2004 16:34:31 +0300, Dobromir Velev [EMAIL PROTECTED] said: Hi, According to the manual - http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html http://dev.mysql.com/doc/mysql/en/InnoDB_File_Defragmenting.html running a null

Re: MySQL inadvertently messing with the path in the Windows' registry?

2004-12-23 Thread Jeff Smelser
choose to add the /bin/ directory of MySQL to the path, during the installation. Do the developers read these messages as well? If not, where should I report the problem? bugs.mysql.com.. Jeff pgpWdoIKbXEGb.pgp Description: PGP signature

Re: Alternatives to Oracle's TO_CHAR()

2004-12-23 Thread Jeff Smelser
in my search for an equivalent method in MySQL or even an alternative. Any help, hints or suggestions are welcome, Cast will work, its in every DB.. Jeff pgpbdMaJFEcXW.pgp Description: PGP signature

Re: scanning 2 rows slow index fast 26GB MyISAM

2004-12-23 Thread Jeff Smelser
count anything. So the select count(*) theory isnt correct. Jeff pgpywUqJPtAY0.pgp Description: PGP signature

Re: insert

2005-01-07 Thread Jeff Mathis
is this insert/select not working? insert into the_db (place,address,number) values(stuff,stuff2,select this from that where one=two); i tried ()s around the 'select' too but it didn't work. thanks. -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company

Re: MySQL 4.1.8 InnoDB: data unavailability among different connections

2005-01-14 Thread Jeff Mathis
that is inserted by B while A is running is not visible to A. If A is re-started all the data that was inserted by B is now available. A is a plotting program and B is a data importer process. Any clue on what may be going wrong? Thank you in advance. Jose. -- Jeff Mathis, Ph.D. 505

Re: actual size of a innodb tablespace

2005-01-14 Thread Jeff Mathis
) is actually used? I would like to have an idea of the data space progression? Per database (I have 3). Thank you in advance Johanne Duhaime IRCM courrier: [EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED

Re: ENCODE DECODE

2005-02-04 Thread Jeff Smelser
to selecting the data from the table I would like to be able to select all the data and decrypt any fields as required. Is this possible with one query, or do I have to select every data item then decrypt it then present the data? Wouldn't select decode(col1) from table work? Jeff

Re: ENCODE DECODE

2005-02-04 Thread Jeff Smelser
whatever is in that column, was encoded. Jeff pgpDfYZf8nbn6.pgp Description: PGP signature

Re: ENCODE DECODE

2005-02-04 Thread Jeff Smelser
for the right syntax to use near '))' at line 1 your right, i was mistaken.. I use: select des_decrypt(des_encrypt(foo)); which works fine.. I am not sure what version he is using, but that should have worked. Jeff pgp7spCyw8ane.pgp Description: PGP signature

Re: default values

2005-02-08 Thread Jeff Smelser
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote: is it possible to force a field to be NOT NULL but not have any default value (I.E the insert statement must explicitly provide data for the field in question)? of course: col1 int not null Jeff pgpKRoQG6Ktfo.pgp Description: PGP

php conection problems

2005-02-10 Thread Jeff Mao
something? Thanks Jeff -- Jeff Mao [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: php conection problems

2005-02-10 Thread Jeff Mao
,... Thanks for any other ideas! Jeff At 2:09 PM -0600 2/10/05, Jay Blanchard wrote: [snip] In the past, I've always simply installed these two pieces as I mentioned above and everything was so easy,but it's been awhile since I last did this,did I miss something? [/snip] Permissions? -- MySQL General

RE: php conection problems

2005-02-10 Thread Jeff Mao
steps every time! Jeff At 8:55 PM + 2/10/05, mel list_php wrote: I'm not sure if it can be a password problem as you can connect through command line,but when upgrading to 4.1 I had the classical access deny error with phpmyadmin whereas everything else was ok. You can still have a look

RE: php conection problems

2005-02-10 Thread Jeff Mao
I'm running Mac OS X,...so if the the disable and rebuild isn't too hard, can you outline that process? Jeff Probably because they don't have the time to get the latest and greatest client library every time. I'm not sure how to rebuild it on Windows but you can disable the built in on unix

RE: php conection problems

2005-02-10 Thread Jeff Mao
Argh,...this is what happens when you leave your sysadmin job to become a bureaucrat! Lost my edge I guess,...I just looked again at what I downloaded earlier today to install,...and I had the version for Mac OS X v 10.2 and not 10.3,... Thanks all for your help! Jeff At 8:29 AM +1100 2/11/05

RE: php conection problems

2005-02-11 Thread Jeff Mao
earlier,... Is this a Mac OS X thing? Or is this normal? Do all the rest of you have newer version of MySQL recognized by php/apache? Thoughts? Thanks in advance Jeff -- Jeff Mao [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: php conection problems

2005-02-11 Thread Jeff Mao
Thanks,...that's the info I needed to help me know where to look for a solution,..I'll direct my work on the php side of things! Jeff At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote: Jeff Mao wrote: I'm back,...I've removed MySQL completely and reinstalled it using the binaries for Mac OS X

RE: php conection problems

2005-02-11 Thread Jeff Mao
for Macs,...I'm checking back on his site to see if this was an oops on his part or by design, etc,... Jeff At 1:19 PM -0500 2/11/05, Dean, Michael L USAATC wrote: Jeff, When you upgraded to the 4.1 version of MySQL did you run the mysql_fix_privilege_tables script? I just upgraded a 3.23

Re: Can I dissable transactions?

2005-02-14 Thread Jeff Smelser
to start all over. Jeff pgpd6v4TIoxmG.pgp Description: PGP signature

Re: MySQL and DNS problem

2005-02-17 Thread Jeff Smelser
will work. Then you can solve why its not resolving. Jeff pgpmTQHtRMU79.pgp Description: PGP signature

Re: MySQL and DNS problem

2005-02-17 Thread Jeff Smelser
are ridiculously messy as you can guess. You have a server thats on DHCP? Well, your problem is dhcp I am sure.. But good luck with that horror flick. What is this world coming to. Jeff pgpZsHHBXfcXQ.pgp Description: PGP signature

Re: MySQL and DNS problem

2005-02-17 Thread Jeff Smelser
.. Since its a binary. Jeff pgpG4TIEO5elB.pgp Description: PGP signature

Re: backing up Databases in Mysql

2005-02-18 Thread Jeff Smelser
copy for innodb too, but you have to pay for it.. (something like that anyway) Jeff pgp6nYOwRR6P1.pgp Description: PGP signature

Re: Logfile verbosity

2005-02-22 Thread Jeff Smelser
and.or pointers would be greatly appreciated. No, LOG is a all or nothing type thing.. LOG-ERROR gets you warnings/notes/errors though.. (an not all the other stuff). I do wish i could get a log with connections, without every query that goes through the system.. Jeff pgpH7HCKlY9wF.pgp

OSX Installation woes...

2005-03-08 Thread Jeff Justice
. Is there a way to un-install this and start COMPLETELY from scratch? It did work once. Jeff J. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OSX Installation woes...

2005-03-08 Thread Jeff Justice
installed it. Something is still goofy. Jeff J. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie question about test database...

2005-03-14 Thread Jeff Justice
Okay, so MySQL is now installed and running. It looks like a database named test was created with no tables. Is this just used for installation purposes? Can it now be deleted or is there a reason to keep it? Or does it have some magical purpose like the mysql database? Jeff -- MySQL

Server won't stop...

2005-03-16 Thread Jeff Justice
Using the OSX MySQL Administrator, when Stop Server is clicked under the Service tab, the server doesn't stop. In fact, the only way I have been able to quit the MySQL process is through the Activity Monitor, and a force quit at that. What's up with that? Jeff -- MySQL General Mailing List

Re: Server won't stop...

2005-03-17 Thread Jeff Justice
with both the MySQL preference pane and the Administrator utility. Jeff On Mar 16, 2005, at 10:56 PM, Michael Stassen wrote: It should be in mysql's bin directory, typically /usr/local/mysql/bin. You either need to add that to your PATH, export PATH=$PATH:/usr/local/mysql/bin or use the full path

Re: Server won't stop...

2005-03-17 Thread Jeff Justice
for me, it is time well spent to try and get the GUI working. Jeff On Mar 17, 2005, at 10:31 AM, Michael Stassen wrote: You can't call TextEdit from the command line like that, you have to launch it in the GUI. That doesn't really matter, though, as you do not want to use TextEdit, because

Re: Server won't stop...

2005-03-17 Thread Jeff Justice
of MySQL for OSX? Jeff On Mar 17, 2005, at 10:46 AM, Jeff Justice wrote: Okay...now we're getting somewhere. Thank you. Adding the file wasn't the problem, I just wasn't sure WHERE it should be added. Yes, I am using 10.3. Just trying to pin down why the GUI tools can't seem to start

Re: Problem with fedora

2005-03-20 Thread Jeff Steinkamp
file in /var/lib/mysql for messages. Look at the last entries in the file. That is what got mysql version 4 running on my FC3 box. Jeff Steinkamp - N7YG Tucson, AZ SCUD Missile Coordinates N32-13-52 W110-52-15 http://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org

Re: turning off replication

2005-03-24 Thread Jeff Smelser
/mysql/en/reset-slave.html Jeff pgpqS6H2r2My8.pgp Description: PGP signature

Re: OS X Gui?

2005-04-07 Thread Jeff Justice
Yes, there is a MySQL beta version of the administrator, but be warned, it has many bugs that I personally believe makes it unusable. Jeff J. On Apr 7, 2005, at 8:35 AM, Brent Baisley wrote: If you are looking for a GUI admin, MySQL has released a beta of MySQL Administrator for OSX. MySQL

changing the datadir on .rpm SuSE install?

2005-04-09 Thread Jeff Drew
, the mysqld_safe script says it's: - using /export for data - using a .pid file in /export - exits without starting mysql. There are no other error messages. Can datadir be set to /export successfully? If yes, is there some other configuration that needs to be changed? Thanks Jeff

Re: slave out of sync

2005-04-14 Thread Jeff Smelser
there.. If your missing bin log files, then you need to set up the master to not delete logs the slave has not processed yet. This would assure your up to date, once the slave comes back alive.. Or am I missing something? Jeff pgpsJU5d3COjX.pgp Description: PGP signature

optimal number of connections?

2005-04-15 Thread Jeff Drew
missing out somehow. Thanks Jeff

Re: zip code search within x miles

2005-04-15 Thread Jeff Kolber
, anyone have insights into doing with Canadian Zip Codes or otherwise optimizing a database of Canadian Zip Codes? Jeff Kolber http://www.ForSaleByOwner.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: zip code search within x miles

2005-04-19 Thread Jeff Kolber
On 4/16/05, Scott Gifford [EMAIL PROTECTED] wrote: Jeff Kolber [EMAIL PROTECTED] writes: How are sites doing the search by zip and coming up with results within x miles? Is there some OSS zip code download that has been created for this? The ones I'm familiar with use this: http

Build problem

2005-04-20 Thread Jeff Hinds
://www.mtsu.edu/~itd Information Technology Division Jeff Hinds, ocp Database Specialist Middle Tennessee State University 001 Cope Administration Building Murfreesboro, TN 37132 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] tel: fax: (615) 898-5719 (615) 898-5720

Query question

2005-04-25 Thread Jeff McKeon
links to 5 corresponding records in table2, I want to pull the latest record from table2 where table2.parentid = 100 and table2.user not like 'john' There is a datestamp field in table2. I just can't figure out how to do this. Thanks, Jeff -- MySQL General Mailing List For list archives: http

RE: Query question

2005-04-25 Thread 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: Query question Jeff, Something

RE: Query question

2005-04-25 Thread Jeff McKeon
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 Cc: mysql

RE: Query question

2005-04-25 Thread Jeff McKeon
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: Query

RE: Query question

2005-04-25 Thread Jeff McKeon
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 version high enough for subqueries

tables locked for no apparent reason

2005-04-29 Thread Jeff Schwartz
I'm running MySQL 4.0.14 and it's locking tables for everything including counting records and select statements. I don't use any lock statements. Has anyone else encountered this? Any suggestions? Thanks, Jeff __ Do You Yahoo!? Tired

Import of Text data

2005-05-01 Thread Jeff Steinkamp
I have a number of very large text files I need to import. The first line of each file contains the field names. Is there a way to automatically create the associated tables based on the filed names in the first line of the text file, then import the data using LOAD DATA INFILE? Thanks Jeff

Dates after version upgrade

2005-05-11 Thread Jeff Hinds
? Thanks, http://www.mtsu.edu/~itd Information Technology Division Jeff Hinds, ocp Database Specialist Middle Tennessee State University 001 Cope Administration Building Murfreesboro, TN 37132 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] tel: fax: (615) 898-5719 (615) 898

MySQL Administrator Broke MySQL

2005-05-17 Thread Jeff Gojkovich
| +---+ ./mysqlshow +---+ | Databases | +---+ | test | +---+ Please give me some pointers on where to go to fix this. I have googled and searched the archives and I haven't come up with anything that works. --Jeff -- MySQL General Mailing List For list

Re: MySQL Administrator Broke MySQL

2005-05-18 Thread Jeff Gojkovich
pointers on where to go to fix this. I have googled and searched the archives and I haven't come up with anything that works. --Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Restoring a database from binlogs

2005-05-18 Thread Jeff McKeon
into the dark) I have binlogs starting from Nov 12, a snapshot from sept 10th. Is there some way anyone can suggest that I can reconstruct the database table with what I have? Best Reguards, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Restoring a database from binlogs

2005-05-18 Thread Jeff McKeon
Interesting idea. So if I take the table from Sept 10th and then do that with the binlog I'll be missing about 2 months worth of data because my earliest binlog file is Nov 12th. The queries are always one to a line in the binlog? Best Reguards, Jeff -Original Message- From

Re: How to implement views in mysql 4.12 version

2005-05-23 Thread Jeff Smelser
://dev.mysql.com/doc/mysql/en/CREATE_VIEW.html Jeff pgpLkLDLqUMyZ.pgp Description: PGP signature

Re: problem loading dates from txt file

2005-05-31 Thread Jeff Mao
together in another cell,... =C1 - D1 - right(A1,2) Look at the functions left, right, mid to see how to pull out parts,... Jeff * Jeff Mao Coodinator of Educational Technology Maine Department of Education 23 State House Station Augusta, ME 04333

Re: MySQL 5.0.6-beta has been released

2005-06-01 Thread Jeff Smelser
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote: Just curious - was there a 5.0.5-beta release? The last beta I had was 5.0.4 unless I missed a release announcement... You need to read that email.. it says it was never released. Jeff pgpk9pJzWINTK.pgp Description: PGP signature

mysqlhotcopy

2005-06-03 Thread Jeff McKeon
files, then starting the db when done. Does mysqlhotcopy allow you to take a full snapshot of the db without needing to shut it down? What happens to read writes and updates while mysqlhotcopy is running? Any info or experiences anyone has would be greatly appreciated. Thanks, Jeff -- MySQL

RE: mysqlhotcopy

2005-06-03 Thread Jeff McKeon
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: Re: mysqlhotcopy I

Re: MySQL 4 Old Password

2005-06-03 Thread Jeff Smelser
On Friday 03 June 2005 03:36 pm, Joey wrote: SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' = OLD_PASSWORD('passowordo'); Why not recompile php to work with 4.1? --old-password Jeff pgpEctk2PnMK1.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread Jeff Smelser
is the best way to get this fixed... Jeff pgpWnixubL90D.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread Jeff Smelser
On Wednesday 08 June 2005 10:56 am, you wrote: In the last episode (Jun 08), Jeff Smelser said: On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote: Subqueries in 4.1 are totally broken. They don't use indexes. They're evil. We're told we have subqueries but there's no way anyone

Re: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread Jeff Smelser
..Or direct them to the right person.. Jeff pgpSieE9hrblQ.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-08 Thread Jeff Smelser
On Wednesday 08 June 2005 11:49 am, you wrote: Easy there boss, I was just responding to the thread and meant no offense. I saw the whole thing as funny. Oh.. email sucks that way.. My apologies as well.. Jeff pgpvHgJLsGjaw.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-09 Thread Jeff Smelser
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote: 1)Why can't I declare a datetime field with DEFAULT NOW() 4.1 has options to default timestamps on update/inserts or both.. Jeff pgp2pHd6mM2jF.pgp Description: PGP signature

Re: INSERT DELAYED and NOW()

2005-06-09 Thread Jeff Smelser
with the timestamp of when the query would have actually been inserted? Jeff pgpGXWuwLb4Lp.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-09 Thread Jeff Smelser
? Jeff pgpqFlRnr8VLc.pgp Description: PGP signature

Re: Seriously.. When are we going to get subqueries?!

2005-06-09 Thread Jeff Smelser
.. Why do you keep bringing this up? Jeff pgp6PCudsBfQQ.pgp Description: PGP signature

Re: InnnoDb - change innodb_buffer_pool_size ?

2005-06-15 Thread Jeff Smelser
keep mine to 1.5 and all the others are really low or turned off. Jeff pgpTAtr1JpbRo.pgp Description: PGP signature

Backing up live MySQL Databases

2005-06-16 Thread Jeff McKeon
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

RE: Backing up live MySQL Databases

2005-06-16 Thread Jeff McKeon
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 up live MySQL Databases I

Re: can innodb_buffer_pool_size be set 2Gb on FreeBSD?

2005-06-17 Thread Jeff Smelser
kernels have things to let you go over, but you get weird results when doing so. Jeff pgpzqaIko4NhJ.pgp Description: PGP signature

<    3   4   5   6   7   8   9   >