RE: replication question

Hi Rob Read the manual, you can do exactly what you need to and it is explained in the manual. I am doing it myself. Regards Warren You can set it up so that the slave only gets updates to certain databases. Have you looked at the replication docs in the manual yet? Yes I did, but what

InnoDB Question

. using the update balance1=balance1 + 500 in side a transaction which has the potentially to be rolled back and there could be any number of simulatenous queries of this nature executing on the same row in the same table at once? Regards Warren ~ Warren van der

Replication - Can I?

because when A replicates to B again, it will ignore the C entries it already has Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249

0 Records Affected

affected because the information was the same and not something else. Anyway of doing his? Thanks ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249

Replciation 3.23.41

(the master was running 3.23.41 but as soon as I tried to start the slave (running two way replication) the server crashes). Any ideas? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262

Is replication inteligent enough for ..... ?

Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check

Query Help

-05-10 in the above example, the result would only return the b row as both the a c rows have entries where the date is newer than the 11 entry. Hope I am explaining it clearly Regards Warren database ~ Warren van der Merwe Software Director PRT Trading (Pty

RE: Default date format

Hi -mm-dd is how it is stored in the db, you have to pass the date like that, and that is how it will be returned. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31

RE: re-indexing records

complain the two tables don't agree)) and then I recreated the table with a auto-number column and imported my dump file. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31

Replication Load InFile

Hi If you use the load infile to insert images into a blob field, and then the path does not exist when the replication takes place, will there be an error, or is it clever enough to get the blob data from the db? THanks ~ Warren van der Merwe Software Director

RE: how to elect slave as master?

it will not have the changes that has occured since Server2 took over. Beware though, two way replication causes serious issues with auto-numbering, and it is best to handle this yourself, in my opinion. Regards Warren ~ Warren van der Merwe Software Director PRT Trading

RE: mysqldump loses auto_increment

will definatelly not (sometimes if I remember correctly the first number may be 0, so the second one will be 1.) in my plain language there it is, but the pro's may give a more detailed approach. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty

RE: MySQL: my.cnf in Windows 2000

. Works well, but a bit of a hassle each time :-) Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED

Replication Drama

A won't update because the table exists and the Add table was the first command, etc etc etc, turns into a vicious loop. Is there a way I can recover from this? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South

RE: Connecting to MySQL w/VB

fast. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of [EMAIL

RE: BerkleyDB and mysql and COMMIT

down.! ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of MikemickaloBlezien

RE: MyODBC through ADO

. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Nipanjan Gupta

skip-resolve

database Hi there I remember seeing somewhere that there is a way to skip resolution of names when conneting to the DB, can someone tell me how. I can't seem to find it in the manual. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty

Lock Tables

database Hi there Is there anyway to see what tables are locked and by who? I have a problem where tables are locked but I am not sure who or why they are. Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South

RE: Replication and primary key autoinc issue

generating at different places, one is 10 billion, the second starts at 20 billion and so on. BYe bye ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message

RE: Access Database into mysql

~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Ute Hoffmann Sent: 07

RE: Replication out of sync

happen for many many many years in my environment. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Michael Eklund [mailto:[EMAIL

RE: Replication out of sync

numbering. Comments from the MYSQL dev team? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Some more questions on Replication

when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249

Replication out of sync

Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http

Replication out of sync

Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http

Some more questions on Replication

when the slave is finished, so that I can disconnect the dial-up line? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249

RE: Some more questions on Replication

updated Site B, Site B will dialin and update Site C, and then C will update A. It works fine, except the two questions I have asked. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163

Slave Stop

once the network connection was interrupted. Any ideas? Thanks ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 database,sql

RE: Replication out of sync

HI What effect will this have in my current setup where A is a slave of B and B is a slave of A. If A, is correct, and I issue a load on B, when A syncs for an update will it not try and write those records back? Thanks' ~ Warren van der Merwe Software Director

BLOB, Images and Visual Basic

I have done it is correct. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before

RE: Replication

Hi How would you set it up so that each server uses different auto numbers? Could I do it so that server A's auto numbers start with A, and B's with B, etc etc etc? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban

Replication

it in the correct format into a text file, but was just wondring if anyone had any other brilliant ideas to share with me Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31

RE: my sql database and locking issues(URGENT)

2. The following is the extract from mysql documentation: In MySQL Version 3.23.7 and above, you can insert rows into MyISAM tables at the same time other threads are reading from the table. Note that currently this only works if there are no holes after deleted rows in the table at the

RE: transaction

Hi No not all versions. You have to have either BDB, InnDB or GEMINI to use transactions. The new mysqld-max has either BDB or InnoDB and some have Both. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell

ISAM v.s. MYISAM

some light? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http

SQL Statements

one way is to not allow the field to contain the single quotation, but now what happens to fields that contain them already, and alot of my stuff is imported from third parties and they contain them. Any help will be appeciated. Thanks Warren ~ Warren van der

MYISAM v.s. GEMINI Tables

occassionally. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please

RE: how to access mysql using vb as front end

).value) rst.movenext wend rst.closerecordset mydb.closeconnection Exit Sub ErrorRun: msgbox Number : mydb.error.number Description : mydb.error.description,vbcritical,Error! End Sub ~ Warren van der Merwe Software Director PRT Trading (Pty

RE: InnoDB, BDB, and Gemini

Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Steve Ruby Sent

RE: InnoDB, BDB, and Gemini

PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED

API or ADO??

would be better? Kind regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting

RE: API or ADO??

and then any changed made to the grid are automatically updated in the database, can this still be done with the MyVBQl? Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31

RTFM - Show locks

that userb will wait for? 2. When the timeout is reached, I want to give the user a message box that shows them who is currently locking the table. How do I see who is locking table1? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t

RE: Optimization of MySQL

Hi there Is there anything similar to this that will run on a Windows platform? Regards WARREN ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original

RE: transaction

the BDB option, otherwise it will say BerkelyDB Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

Berkely DB

Hi there I am trying to find out how the Berkely DB stuff works when running MYSQL on windows. How do I create a transactional table? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767

RE: Query problems

Hi In my opinion I would imagine Merged tables would do what you wanting. Refer to the MYSQL manual. Thanks ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 -Original Message- From

Berkelely MYSQL

Hi there I have managed to download the Berkeley for Windows installation, however I have noted that MYSQL will not run without a patched version of berkeley's. Where can I obtain such a installation to run on Windows? Kind Regards Warren ~ Warren van der Merwe

Compiling MYSQL for Win32 Platform BDB

the type to BDB, it defaults to MYISAM. What am I missing. In all honesty this has been a huge learning curve for me, I feel like I am almost there, and just need a little more help. Anymore's assistance will be greatly appreciated Thanks Warren ~ Warren van der

RE: Compiling MYSQL for Win32 Platform BDB

~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Miguel Angel Solórzano Sent: 24 April 2001 12:50 To: [EMAIL PROTECTED]; [EMAIL

MSACCESS v.s. MYSQL

ing access, mean't I never had the ' ""' at the end. By the way, variable in this particular case equals nothing Also, has anyone moved from Access to MYSQL on a live application, what kind of things did you encounter when doing this migration? Thanks Warren ~~~~~~~~~~~~~ Warren van