Re: Problem with Replication - Slave Option replicate-ignore-tabl e and replicate-wild-ignore-table

Hi, I have had similar problems with "do-table", but never succeded finalizing my bug-report. I have added (on master) ... "SET SQL_LOG_BIN = 0" as start of each action where not to replicate data "SET SQL_LOG_BIN = 1" as start of each action where to replicate data Further I have had some issue

Re: Drop all keys / indexes on a table?

Hi, Take at look at CHECK TABEL - as far as I remember, the CHECK TABLE EXTENDED will do a re-index (check index), otherwise some of the other OPTIMIZE, etc. can help on this. Take a look in the exellent manual. Best regards Peter - Original Message - From: "Daevid Vincent" <[EMAIL PR

Re: Dream MySQL Server?

Hi Alec, You are not mentioning the "application", if this is a web-based application/interface or some "internal heavy stuff". I'm running Windows 2000 and MySQL (and are happy, sleep fine every night !) for web-sites, and have only a P4 1.6 processor - and this is working very fine so far. So,

Re: datetime in mysql

Hi, If You take Your really exellent "MySQL Reference Manual", and search for "timestamp" or look into chapter 6.2, You fill find what You are looking for. Best regards Peter - Original Message - From: CurlyBraces Technologies ( Pvt ) Ltd To: [EMAIL PROTECTED] Sent: Friday,

Re: Problem with Selecting Text and Blob fields

Hi, I have had problems reading BLOB fields using MyODBC (I can't see if this is Your way of doing this). I have solved reading/updating BLOB using the samples from http://www.vbmysql.com/ - http://www.vbmysql.com/articles/visual-basic_mysql/blobaccessvb.html Best regards Peter - Origi

Re: MySQL big problem

Hi, The install of MySQL is mainly "only a unpack". If You make a new folder - ex. C:\mysql02 - and install in this, You have the \data available and can copy to Your first installation, or change You my.ini to use second installation. Best regards Peter WR - Original Message - From:

Re: Mysql issues.

Hi, Two way, depending on size of Your data ... - programming if data is more than 64MB - best way - export MS SQL 7 to MS Access and import MS Access to MySQL (my experience is only char.data, no image in blob or other things like this) Best regards Peter W Rasmussen - Original Message --

Re: transaction support

Hi, I have been using MySQL since 3.2x and now 4.0.1x in Windows NT and Windows 2000 IIS / .asp environment including MyODBC for more than 4 years now, and never lost any data. Setup problems have been solved by reading and following instruction in the manual, or asking in the support / newsgroups

Re: More database replication

Støt Julemærkesagen Hi,   From my experience, if You have to write ...   LOAD DATA FROM MASTER   Your replication is not setup correctly.   LOAD DATA FROM MASTER is reload of the whole table, and by that You also get the updates.   When working correctly, the replication starts when MASTER

Re: My Company DB Wars

Hi, You could bring the attention to www.mysql.com - probably German software company SAP would not integrate with MySQL, if there were any kind of problems. Further You could look at the success stories ( http://www.mysql.com/press/user_stories/index.html ), and You will find NASA, Yahoo! Finan

Re: Selecting on timestamp(14)

Hi, I dont think so - the timestamp is a system-field, set by the system and can not be modifyed by users. You probably have to make an additional datetime-field for You purpose - if You can do CONCAT(timestamp + NOW()) when it is INSERT, I dont know - try. best regards Peter - Original M

Re: MySQL - MS SQL

Hi, Forgot - You can also run PHP on Win2000. Best regards Peter - Original Message - From: "Sheni R. Meledath" <[EMAIL PROTECTED]> To: "MySQL Masters" <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 10:42 AM Subject: MySQL - MS SQL > Hi, > > I have designed a site using PHP & MySQL.

Re: MySQL - MS SQL

Hi, MySQL is running fine on Win2000 and IIS, so why change to MS SQL ? Best regards Peter - Original Message - From: "Sheni R. Meledath" <[EMAIL PROTECTED]> To: "MySQL Masters" <[EMAIL PROTECTED]> Sent: Saturday, June 21, 2003 10:42 AM Subject: MySQL - MS SQL > Hi, > > I have design

Re: Complex SQL involving 10 checkboxes

When I have these kind of settings/testing, I make one text-field and set a specific code ex. age 0-5 "[age00-05]" age 6-10 "[age06-10]" and so on - then you reduce the SQL to always read that specific tablefield, and leave the complexity to the program instead. best regards Peter - Origin

Re: selecting PRIMARY KEY when there is no unique value

Hi, >From my point of view, you should always add a autoincrement_field for having a unique identifier and keeping each record unique, ex. in case of programmingmistakes and so. Best regards Peter - Original Message - From: "Mojtaba Faridzad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

SQL question

Hi, I have a SQL issue I cannot figure out, perhaps somebody can help / solve / input on this ... I have a table with stock-status transactions like ... 2003-06-17 06:00 stockA SKU1 QTY 98 2003-06-16 06:10 stockA SKU1 QTY 101 2003-06-15 04:59 stockA SKU1 QTY 111 - the time for updating the tra

Re: mysql.org

L initiative at www.mysql.com" (or something like that) ... and by that make it clear to newcomers, that there are something to be aware of. Best regards Peter - Original Message - From: "Van" <[EMAIL PROTECTED]> To: "PeterWR" <[EMAIL PROTECTED]> Cc: <

Re: mysql.org

Hi Monty, When reading Your comments, I became very sorry for You and MySQL. With almost four years experience on MySQL on Windows, I have had no problems of any kind. You and Your people are doing a great job both on the software and on the support - other major players could learn from MySQL w