Multi-Table Insert Strategy

2005-07-02 Thread Don Parris
O.k., this question is more about the best way to run a multi-table insert on a MySQL DB (4.0.18), given a console based interface (Python 2.3.x under SUSE Linux 9.2). My guess is that this would be a bit easier with a GUI, where I would have widgets to assign to various functions. However, I am c

Re: offer a solution ?

2005-07-02 Thread Stephen Cook
depending on what you use this information for, you might want to keep two tables, one with the current information, and one of the history. it would keep the "current" one relatively small, but allow for looking up historical data if necessary. nephish wrote: Hey there, i have been messing

fulltext searching using special chars

2005-07-02 Thread Octavian Rasnita
Hi, I am trying to search for a word that contains special chars like ş or ţ, but I find only the words and like when the special chars are not a part of the word. I found that if I search for "ş" (in boolean mode), I am able to find the records that contain the

Re: Duplicate entry error

2005-07-02 Thread Gleb Paharenko
Hello. > 1.How to send MySQL versions on master and slave. Send an output of the following statement executed both on master and slave: select version(); > 2.Where I have to include output of 'SHOW SLAVE STATUS'. Execute SHOW SLAVE STAUTS on your slave (run START SLAVE before) an

Re: mysql won't start anymore ?!?

2005-07-02 Thread Gleb Paharenko
Hello. It is not enough information to make a conclusion. Follow recommendations from: http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html JanBro <[EMAIL PROTECTED]> wrote: > Hi list, > > I can't get mysql running again and I don't know why. My wag would > be a corrupt

Re: offer a solution ?

2005-07-02 Thread Frank Bax
Actually, there should actually be two tables. One for columns that are static information about the monitor; the other with information that changes. should be in a separate table. OnlAt 12:30 PM 7/2/05, Jim McAtee wrote: No, you don't want a table for each monitor. One table for the data

Re: offer a solution ?

2005-07-02 Thread Jim McAtee
No, you don't want a table for each monitor. One table for the data will be _much_ easier to work with. If you want a history then you need to insert a new record for each datapoint that you get, with, as Frank suggested, a date/time column. How large your table will get will depend on the n

Re: offer a solution ?

2005-07-02 Thread Frank Bax
At 01:49 PM 7/2/05, nephish wrote: i am writing a database to track what a bunch of electric monitors are doing. the status of the monitor changes almost daily. i need access to each monitor, when it changed, and i also need to track its history. Easy enough. but if i update a row in a table,

offer a solution ?

2005-07-02 Thread nephish
Hey there, i have been messing around with MySQL for a little bit now. I have a question about how i might could do something. i am writing a database to track what a bunch of electric monitors are doing. the status of the monitor changes almost daily. i need access to each monitor, when it

General-list comment

2005-07-02 Thread Danny Stolle
Is there a problem with the mysql-general list? I haven't had any messages? Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql won't start anymore ?!?

2005-07-02 Thread JanBro
Hi list, I can't get mysql running again and I don't know why. My wag would be a corrupt mysql.exe? I had it running for almost a year now and besides the fact that my ibdata1 rose to a size of more than 2.5 G (with actual data of less than 100 M) I didn't encounter problems. but this morning I

Re: Some query help

2005-07-02 Thread Mathias
Selon Mathias <[EMAIL PROTECTED]>: > Selon [EMAIL PROTECTED]: > > > "Matt Babineau" <[EMAIL PROTECTED]> wrote on 07/01/2005 05:05:28 PM: > > > > > Hi Again - > > > > > > I need some more help with a query. I have a list of numbers (bandwidth > > > required)... 2200, 2200, 2200, 400, 320 > > > > >

Re: Some query help

2005-07-02 Thread Mathias
Selon [EMAIL PROTECTED]: > "Matt Babineau" <[EMAIL PROTECTED]> wrote on 07/01/2005 05:05:28 PM: > > > Hi Again - > > > > I need some more help with a query. I have a list of numbers (bandwidth > > required)... 2200, 2200, 2200, 400, 320 > > > > My data looks like this: > > > > Bandwidth | Distance

RE: Duplicate entry error

2005-07-02 Thread anurag.dashputre
Gleb, Thanks for your suggestions. I would like to know 1.How to send MySQL versions on master and slave. 2.Where I have to include output of 'SHOW SLAVE STATUS'. 3.How to Fix the problem if it does occurs. 4.How to restart the slave SQL thread with "SLAVE START". Thanks again for your help and c