preventing duplicate entries

Home ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Be

Re: preventing duplicate entries

g staff? > > I am a Sr. SUN Solaris Engineer 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://explor

multiple database issue on winNT4.0

le to connect ..." 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

select query for duplicate records

-- ___ 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)

Re: select query for duplicate records

no insert if (mysql_num_rows($result) != 0) { echo "error"; } else { // DO INSERT } ?> Pete Paul DuBois wrote: > > At 3:13 PM -0500 6/27/01, Pete Kuczynski wrote: > >Hi, > >How wou

Re: select query for duplicate records

PM -0500 6/27/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. > > B

logs on nt4

r them out. 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 --

restoring a database on nt4

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: http://www.

Re: restoring a database on nt4

I can't seem to find any documentation on how to set this up an a windowz box. Can anyone help? Pete Gerald Clark wrote: > > Run your transaction log against the restored database. > > Pete Kuczynski wrote: > > > Hoping someone can point me in the right directio

Re: Reporting Tool : Linux?

ECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- > > Joshua Kugler, Information Services Director > > Associated Students of the University of Alaska Fairbanks > > [EMAIL PROTECTED], 907-474-7601 > > >

Re: MySQL HELP -- Unable to start Win2k service

067: The process terminated unexpectedly. > >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

transaction logs using nt4

cen tell, 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

restorin a nt 4 database

>From what I can tell, 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!

backup on nt4

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-

backup/restore of mysql

atabase recovery in the event of a crash. Kindest thanks! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 --

Re: backup/restore of mysql

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 Jul

RE: backup/restore of mysql winNT

rently 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 --

transactions

nt on transactions. The rest of us, however, can > 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.

Re: transactions

.com/doc/S/E/SET_TRANSACTION.html > > Regards, > -- > Don Read [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. -- ___

Re: transactions

> > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastru

table types

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

innodb on nt4

on 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 _______

Re: transactions

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

Re: innodb on nt4

t find any documentation 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. > &g

Re: innodb on nt4

set-variable = innodb_additional_mem_pool_size=10M > > set-variable = innodb_file_io_threads=4 > > set-variable = innodb_lock_wait_timeout=50> > > Then you use mysql\bin\mysqld-max-nt --install to install it as a service. > > You can run SHOW VARIABLES to see the which tab

Re: innodb on nt4

gt; > set-variable = innodb_file_io_threads=4 > > set-variable = innodb_lock_wait_timeout=50> > > Then you use mysql\bin\mysqld-max-nt --install to install it as a service. > > You can run SHOW VARIABLES to see the which table types are available.> > > That's

Re: innodb on nt4

aste the above to your my.cnf > and adjust directories, file sizes, and pool sizes to your needs. Files must > be > < 4 GB currently. > > Hope it now succeeds! > > Heikki > > -Original Message- > From: Pete Kuczynski <[EMAIL PROTECTED]> > To: He

gemini tables in mysql

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 Kuczyns

blob question

n. Does 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

Re: blob question

ould I add a autoincremented > > primary key? > > > 4. Is it better to have a seperate table for this or, is it better to > > update my existing table, and add a blob column. Does it matter in terms > > of speed of queries? > > > Queries will be done via php. >

Re: MySQL with perl

ysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/ph