InnoDB Question

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 Any views expressed in this message are the sender's own, and do not represent the views of RedTie Software exc

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

MysqlDump (Possible bug?)

import wrong, is this a bug or how can I fix it? 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 Any views expressed in this message are the sender's own

RE: Connecting to MySQL w/VB

very 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 B

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

Replication Drama

st, Site 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 RedTi

RE: mysqldump loses auto_increment

ne may/may not work, but the second 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

RE: MySQL: my.cnf in Windows 2000

Notepad, or wordpad. 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- &

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 (+

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?

ck up 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 Directo

Query Help

0 c 07 0 2001-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 ~~~

Is replication inteligent enough for ..... ?

en't lost everyone 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

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

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

Replication - Can I?

rectly to "C" instead of the "normal" tri-angular sequence. My question is really . When the replication occurs how does it know what information is from what server, do the logs stor the server id, and therefore the above should work because when "A" replicates

MSACCESS v.s. MYSQL

an'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 ~

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

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

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 va

RE: Compiling MYSQL for Win32 Platform & BDB

rds 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] > ]On Behalf > Of Miguel Angel Solórzano > Sent: 24 April 2001

Desperate

BDB table format on some of my tables. If anyone can help I will appreciate it or if you can help on the error I am in getting (posted previously to the group). I would really appreciate it. Kind Regards Warren ~ Warren van der Merwe Software Director PRT Trading

RE: transaction

don't have 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] >

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

RTFM - Show locks

27; period 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 Tradin

myODBC

~ 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://www.mysql.com

API or ADO??

d reliability. Which 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

RE: API or ADO??

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

RE: how to access mysql using vb as front end

Hi I am successfully developing with VB and MYSQL using the MYSQL API, which can be found on the mysql website, look at the download section and it is called myvbql.dll Similar to ADO, but a little different. Works like a dream Warren ~ Warren van der Merwe

RE: how to access mysql using vb as front end

gt; 0 then goto errorrun while not rst.eof text1=trim(rst.fields("Name").value) rst.movenext wend rst.closerecordset mydb.closeconnection Exit Sub ErrorRun: msgbox "Number : " & mydb.error.number & " Description : " & mydb.error.d

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 >

RE: InnoDB, BDB, and Gemini

eve Ruby'; 'Kevin McBrearty'; > [EMAIL 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]] >

MYISAM v.s. GEMINI Tables

herwise the mysqld-opt crashed 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 --

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

GRANT & REVOKE

other quicker way of doing this? 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

ISAM v.s. MYISAM

shed 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 c

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

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

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 (+

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 Red

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

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

all three sites add/amend/delete records. I currently have the first setup running and working well. 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

Replication out of sync

all three sites add/amend/delete records. I currently have the first setup running and working well. 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

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

A has 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

Slave Stop

continued 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 da

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 Dir

RE: exporting from MS Access

Hi there I used DB Tools, downloadable from the MYSQL web site. Works like a charm 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 Mess

RE: Replication out of sync

00 but it won't 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- > Fr

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

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

RE: Replication and primary key autoinc issue

. Each branch starts 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 >

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

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: 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 &