gemini tables in mysql

2001-07-19 Thread Pete Kuczynski
Hi, since Nusphere release the source code for gemini yesterday I believe it was, I was wondering if Mysql AB was going to incorporate it into a future release if it's database. I realise in light of recent .org events Pete -- ___ Pete Kuczynski Sr

blob question

2001-07-19 Thread Pete Kuczynski
it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767

Re: blob question

2001-07-19 Thread Pete Kuczynski
Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767

Re: innodb on nt4

2001-07-18 Thread Pete Kuczynski
to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table

Re: innodb on nt4

2001-07-18 Thread Pete Kuczynski
it now succeeds! Heikki -Original Message- From: Pete Kuczynski [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, July 18, 2001 10:14 PM Subject: Re: innodb on nt4 Ok, got the following line working in my.ini

innodb on nt4

2001-07-17 Thread Pete Kuczynski
on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field

Re: transactions

2001-07-17 Thread Pete Kuczynski
Thanks Monty! will this work on NT as well? or do I need to move to Linux. I don't much care if the tables are BDB or InnoDB, just that I have transaction support. Good luch with the Nusphere thing! Pete Michael Widenius wrote: hi! Pete == Pete Kuczynski [EMAIL PROTECTED] writes

Re: innodb on nt4

2001-07-17 Thread Pete Kuczynski
--install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED

Re: innodb on nt4

2001-07-17 Thread Pete Kuczynski
it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s

transactions

2001-07-16 Thread Pete Kuczynski
usually live without 'em. -- Hi Pete To emable logging use the --log option eg --log-update when stating the server... Simon ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434

Re: transactions

2001-07-16 Thread Pete Kuczynski
[EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7

Re: transactions

2001-07-16 Thread Pete Kuczynski
with Berkeley DB support, download MySQL Version 3.23.34 or newer and configure MySQL with the --with-berkeley-db option. See section 4.7 Installing a MySQL Source Distribution. cd /path/to/source/of/mysql-3.23.34 ./configure --with-berkeley-db Don Read wrote: On 16-Jul-01 Pete Kuczynski

table types

2001-07-16 Thread Pete Kuczynski
Hi, I understand mysql supported InnoDB and BDB table types for the purposes of transaction logging, which I need to use. Which is recommended by you folks for NT4 boxes. Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology

RE: backup/restore of mysql winNT

2001-07-13 Thread Pete Kuczynski
the update log is. Currently it's in d:\mysql\bin Pete Original Message Subject: RE: backup/restore of mysql Date: Tue, 10 Jul 2001 17:48:31 +0100 From: Simon Green [EMAIL PROTECTED] To: 'Pete Kuczynski' [EMAIL PROTECTED] Hi Pete To emable loffing use the --log option eg --log-update

backup/restore of mysql

2001-07-10 Thread Pete Kuczynski
. Kindest thanks! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check

Re: backup/restore of mysql

2001-07-10 Thread Pete Kuczynski
Very cool. Thaks very much Simon! Pete Simon Green wrote: Hi Pete To emable loffing use the --log option eg --log-update when stating the server... Simon -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:51 To: Simon Green Subject

backup on nt4

2001-07-06 Thread Pete Kuczynski
between the time of the backup and the crash? Thanks for any help! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767

restorin a nt 4 database

2001-07-05 Thread Pete Kuczynski
NOT support transaction logging, at least not for NT. Can anyone help, if transactions are not supported, how are those folks that have mysql running on NT, restoring a database? I'm using Mysql version 3.23.27. Thanks! ___ Pete Kuczynski Sr. Field

Re: Reporting Tool : Linux?

2001-07-03 Thread Pete Kuczynski
/php/unsubscribe.php -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check

Re: MySQL HELP -- Unable to start Win2k service

2001-07-03 Thread Pete Kuczynski
. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services

transaction logs using nt4

2001-07-03 Thread Pete Kuczynski
, Mysql does NOT support transaction logging, at least not for NT. Can anyone help, if transactions are not supported, how are those folks that have mysql running on NT, restoring a database? I'm using Mysql version 3.23.27. Thanks! Pete ___ Pete Kuczynski Sr

restoring a database on nt4

2001-07-02 Thread Pete Kuczynski
___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com

Re: select query for duplicate records

2001-06-28 Thread Pete Kuczynski
/01, Pete Kuczynski wrote: Thanks Paul! ps works great! I modified the database with a UNIQUE column like you recommended earlier, this will now help in the PHP script to trap the duplicate entry and advise the user of the dup. But if hostname now has a UNIQUE index on it, it won't even

logs on nt4

2001-06-28 Thread Pete Kuczynski
. Thanks for any insight in advance! Pete -- ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before

multiple database issue on winNT4.0

2001-06-27 Thread Pete Kuczynski
... I suspect I cannot, but some insight into this would help. Thanks! Pete -- ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767

select query for duplicate records

2001-06-27 Thread Pete Kuczynski
-- ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: select query for duplicate records

2001-06-27 Thread Pete Kuczynski
} ? Pete Paul DuBois wrote: At 3:13 PM -0500 6/27/01, Pete Kuczynski wrote: Hi, How would a word a select statment, to search a database for duplicate entries in one field. For example, the fields: device, hostname, IP, comments I want to find all instances where there my be two devices

preventing duplicate entries

2001-06-26 Thread Pete Kuczynski
device.); ? a href='index.html'bHome/b/a /body /html ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767

Re: preventing duplicate entries

2001-06-26 Thread Pete Kuczynski
with more than 10years experience if that helps at all. Good luck with your work. Kris- _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- ___ Pete Kuczynski Principal Field

Re: MySQL with perl

2001-06-07 Thread Pete Kuczynski
[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800