Re: Databases not seen in MySQLCC

Marvin Cummings wrote: Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before? If you right-click the server entry in MySQLCC and select "Edit", there is a "Databases" ta

Re: Questions about MySQL's INSERT syntax....

Hi You shoule be able insert fewer columns. Of course, you should include all the NOT NULL columns unless they arere is auto_increment for them. Regards Bhaskara > --snip-- > INSERT INTO TABLE1 > (COLUMN1,COLUMN3) > VALUES > ('ONE','THREE') > --snip-- > --- Scott Fletcher <[EMAIL PROTECTED]

Re[4]: Delphi 7 and MySQL

At 03:08 6/17/2004, vanquish, wrote: >Bonjour Martijn, > >>> >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 >>> >> anyone have an answer for my PLEASE >>> >>> I'am using Zeoslib (www.ZeosLib.net). It's fast, free, open source and >>> powerfull. > >MT> Does it require MySQ

Re: Recommendation on god MySQL books

Get the recently published book from Jeremy Zawodny. It's excellent. Very easy to understand and goes through all the admin stuff. It has a chapter dedicated to replication and explains in simple concise steps how to set up replication. It demonstrates many different types of replication config

Odd behaviour of server / script?

This is driving my crazy. The culprit table seems to be 'Member_WebSkills'. When I delete a record using phpMyAdmin a Perl script I have shows the updated data. When I add the same data back, the script shows the updated data. If I add a *new* record via phpMyAdmin, the script *doesn't* show the

Re: Erro on Query

Try back ticks around it. `DESC' > Dear Friends. > > when Creating the follow table > > CREATE TABLE CONHEC_DBF (CON CHAR (7) , >SER CHAR (2) , >NUMNF CHAR (8) , >SERNF CHAR (2) , >LOJA CHAR (2) , >PAIDF CHAR (12) , >QUANT REAL (6,0) , >NOP CHAR (10) , >TRAN CH

Databases not seen in MySQLCC

Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before?

Re: Erro on Query

Luiz Rafael Culik Guimaraes wrote: Dear Friends. when Creating the follow table I got an Erro when defining Column DESC(same error even if DESC is between "") DESC is a reserved word, try something else. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Erro on Query

Dear Friends. when Creating the follow table CREATE TABLE CONHEC_DBF (CON CHAR (7) , SER CHAR (2) , NUMNF CHAR (8) , SERNF CHAR (2) , LOJA CHAR (2) , PAIDF CHAR (12) , QUANT REAL (6,0) , NOP CHAR (10) , TRAN CHAR (4) , DTC DATE, DTE DATE, ESPEC CHAR (10) ,

Re: Why can't I make a connection?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Scott D. Spiegler wrote: > Hi, > > I tried doing what Rhino suggested by coping the jar > file I downloaded to the jre\lib\ext folder where my > jdk is installed. The only thing that was different on > my system than what Rhino described is that my ha

Re: Why can't I make a connection?

Hi, I tried doing what Rhino suggested by coping the jar file I downloaded to the jre\lib\ext folder where my jdk is installed. The only thing that was different on my system than what Rhino described is that my hard drive only had a path jre\lib, but with no ext folder inside the lib directory. I

Re: Out of memory on INSERT

On Tue, 2004-06-15 at 08:08, J S wrote: > Hi, > > I have a perl script which runs a bulk insert. When I run an insert with > about 100,000 lines it keels over with the following message: > > DBD::mysql::st execute failed: Out of memory (Needed 6100848 bytes) at > ./parse.pl line 227, <> line 10

Re: Multiple Databases

4 or 5 tables is pretty small. We've got about 200 tables here, some containing over 100 million rows which still runs well on a simple PIII test server. You are definitely better off having one database serve this data. If you want a backup, the MySQL replication stuff works very well. On Thu,

Out of memory on INSERT

Hi, I have a perl script which runs a bulk insert. When I run an insert with about 100,000 lines it keels over with the following message: DBD::mysql::st execute failed: Out of memory (Needed 6100848 bytes) at ./parse.pl line 227, <> line 15. There is 8GB of memory on the box so I'm sure th

Multiple Databases

I'm working on a rather large database - four or five tables - that will power eight different websites. There will also be a few additional supplemental tables on various sites, but I'd speculate that 90% of the data will be exactly the same on all eight sites. With that in mind, would you recomm

Re: MySQL Installation Problem

I have a windows installation of myql. The links Michael gave give correct info. Here's a synopsis: To test a mysql install on windows open the mysql/bin dir in a dos window. At the prompt type mysqld --console you should get a message back that indicates the server is running, such as mysqld: rea

RE: Ask again about comparing cast string to date

If the activationtimestamp field is in MMDDHHMMSS format have you tried using unix_timestamp? ... select * from SoutheastDB.SubscriptionVersion where unix_timestamp(activationtimestamp) > unix_timestamp(DATE_ADD('2004061807', INTERVAL 5 HOUR)) and activationtimestamp <= '20040619065959' lim

Ask again about comparing cast string to date

I am trying to select the records where the field activationtimestamp is within a certain range. Unfortunately the field activationtimestamp is defined as character(14) in the table. mysql> select * from SoutheastDB.SubscriptionVersion where date(activationtimestamp) > DATE_ADD('2004061807',

Re: Update problem

echo $updatequery to screen and see what the sql looks like. > I am trying to update a table from results generated from a select query, > but can't seem to get the queries running right. The select query works > fine, but when I try to use the results for an update it error out. Here > is > my

Re: Recommendation on god MySQL books

When I first started, I bought MySQL by Paul DuBois. It covers the basics to admin responsibilities and preventive maintenance. But, you may want to search the archives, this question has been asked many times before. On Jun 17, 2004, at 1:44 PM, Bartis, Robert M (Bob) wrote: I'm looking for sug

Re: Recommendation on god MySQL books

God doesn't use MySQL (I think he leans towards Postgres - he needs views and triggers). But if you are interested in MySQL, Paul DuBois's book, "MySQL, Second Edition" is a great reference. If you need more insight into performance tuning, then Jeremy Zawodny and Derek Balling's book, "High Pe

Re: MySQL Installation Problem

I'm including the list on this. In general, you will get better and faster responses if you keep threads on the list. I've never run the mysql server under Windows, but I assume the manual is accurate and

Update problem

I am trying to update a table from results generated from a select query, but can't seem to get the queries running right. The select query works fine, but when I try to use the results for an update it error out. Here is my query: db_connect(); $query = "SELECT cst_SiteID FROM customer

RE: Recommendation on god MySQL books

I think Wiley´s Mysql enterprise solutions could be a good option. It´s a great book and have an entire chapter covering replication -Mensaje original- De: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 17 de Junio de 2004 11:44 a.m. Para: [EMAIL PROTECTED] Asunto:

Re: Importing data, indexes, and analyzing tables.

After a day of looking, I answered my own questions, and I'll post those answers here in case anyone else was interested in the answer. First, "LOAD DATA" + "ALTER TABLE ADD INDEX"... seems to be slower than a "mysqldump" + "ANALYZE TABLE". Of course, you don't always have a mysql dump file. A

Recommendation on god MySQL books

I'm looking for suggestions on books that would help me to improve my understanding of MySQL operations, admin operations, replication etc. I'm new to MySQL and am about to embark on supporting a database for my team to use in recording test results. Any suggestions and recommendations ones to s

RE: Replication - promoting slave to master

Initially you should have set the slave up with log-bin in its my.cnf file so that it is writing to its own binary logs. In the event that the master goes down, you should issue a change master on any other slaves so that they point to the new master. Redirect all writes to the new master. On the n

Re: Problems with boolean keyword search

Hello, Eamon Daly schrieb am Donnerstag, 17. Juni 2004 um 19:04: > FYI, MySQL allows boolean searching as of 4.0.1. See: > http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html I normally use that. But: Very bad result quality because there are only sigle keywords. I tried it with a text colum

Re: MySQL Installation Problem

First, make sure mysql server is running. Second, make sure you have properly configured phpmyadmin in file config.inc.php. In particular, you have to set how phpmyadmin will connect to mysql (user and pass). Michael Daniel Clark wrote: After the phpmyadmin login I got the same error. In the ph

Replication - promoting slave to master

Hello, I've been lurking about the lists for a few months now, hoping to gain some knowledge on MySQL's replication features for HA setup. I have a fairly good understanding of the setup process, but I'm a little confused on one points. We are running a 2 node - master-slave setup, and we are

Re: How to monitor that slave is not working because of user rights?

On Thu, Jun 17, 2004 at 06:01:56PM +0300, Cemal Dalar <[EMAIL PROTECTED]> wrote: > Actually. I am talking about a machine which is at office. And inside office > we're connecting using ADSL which gets dynamic Ip address. The slave > server's IP address actully doesn't change. It doesn't have a rea

Re: using a column value in IN() in a join condition.

Long ago, I would Reply to All, remove the poster's address from the To: line, and change the list address from Cc: to To:, all so the poster wouldn't get two copies of my reply. Then I noticed two things: * Posters often request direct email because they aren't subscribed to the list. * There

slave death during transfer

I need to fetch data from multpiple masters to one slave and I have a few theoretical questions... What if I will do "slave stop" query during transfer of data? Is "Has read all relay log; waiting for the I/O slave thread to update it" status reliable? If I will depend on it and I will do "slave

Re: Problems with boolean keyword search

FYI, MySQL allows boolean searching as of 4.0.1. See: http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html Or pp. 256-257 of MySQL, 2nd Ed. by Paul DuBois for several examples. Eamon Daly - Original Message - From: "Andr

Re: open notify

On Thursday 17 June 2004 06.25, Stano Paska wrote: > Is there some common technique to notify another user, when he wants > open second dialog with same person, which is opened by first user at > the same time? > Another user sees on list of persons actual data, but this record is > already opened

RE: Delphi 7 and MySQL

I use http://crlab.com/mydac/ with Delphi 7. Works fine for me so far. I tried Zeos, but their lack of documentation made it too cumbersome. Jackie -Original Message- From: Johan Harmse [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 9:34 AM To: MYSQl Maillist Subject: Delphi 7

Re: MySQL Installation Problem

After the phpmyadmin login I got the same error. In the phpmyadmin config files I had to set the local IP address that phpmyadmin was on. > Dear Michael, > > I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not > able to get this rite. > > > I am trying to instal MySQL with

Re: Questions about MySQL's INSERT syntax....

You should try it. The database will like it just fine as long as you have as many values/columns in your VALUES/SELECT clause as you list as columns in your INSERT clause. Just remember, though, that for all of the columns NOT listed in the INSERT clause of your statement the database will assi

Dying query ....

Hello! I am running: Server version 4.1.2-alpha-max-log On linux RedHat. When I execute a simple select, it's dying, with no error message reported or so, the query is simply dying together with the server. After query is died entire server is hang on. I can't even shut it down. Query sh

Problems with boolean keyword search

Hello, I have to build a keyword search with support for the boolean operators +, -, * and ". Basically it's quite easy: Connect the three tables with two joins, keyword search with LIKE. But the boolean operators give me a headache. mysql> SELECT c.id FROM keywords AS a LEFT JOIN keywords_trans

re: Questions about MySQL's INSERT syntax....

Hi Scott, Yes this will work. But, you the columns you are leaving out, must be auto fill or allow blank/Null entries. Scotty. Original Message: >From: "Scott Fletcher" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: Questions about MySQL's INSERT syntax >Date: Thu, 17 Jun 2004 12:2

Questions about MySQL's INSERT syntax....

Hi! The SQL's INSERT Syntax that have been frequently been used is --snip-- INSERT INTO TABLE1 (COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5) VALUES ('ONE','TWO','THREE','FOUR','FIVE') --snip-- where the TABLE1 have 5 columns, "COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5". What I wanna know is wi

Re: How to monitor that slave is not working because of user rights?

Cemal Dalar wrote: Actually. I am talking about a machine which is at office. And inside office we're connecting using ADSL which gets dynamic Ip address. The slave server's IP address actully doesn't change. It doesn't have a real ip address only the ADSL has. Simply saying we are using NAT.

MySQL Installation Problem

Dear Michael, I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not able to get this rite. I am trying to instal MySQL with phpMyAdmin and i get the error when view from : http://localhost/phpMyAdmin/ #2003 - Can't connect to MySQL server on 'localhost' (10061)

RE: Where are BLOBs / TEXTs stored?

> > Thank you all, it all makes sense (at least to me) . > > The "row" object contains a pointer to a location elsewhere in the SAME > FILE where the BLOB itself is kept. That pointer (and maybe the size of > the BLOB itself) add the 5 to 9 bytes to the row as discussed in the > docs. The actual BL

Re: collation problem

SQL thank you. I found how to set koi8r charset for the server: to set default collation for configure. But how to build mysql client and client library that default client sharset is koi8r? It isn't useful to set this in my.cnf IMHO if I use only one charset for my application. I want something

RE: Where are BLOBs / TEXTs stored?

Thank you all, it all makes sense (at least to me) . The "row" object contains a pointer to a location elsewhere in the SAME FILE where the BLOB itself is kept. That pointer (and maybe the size of the BLOB itself) add the 5 to 9 bytes to the row as discussed in the docs. The actual BLOB data is i

grepping data from show processlist in more elegant way

Hello, I have wrote a small program which's main purpose is to do "change master to", "slave start" and after a transfer of data - "slave stop". But after "slave start" i need to know when the transfer ends - to do this I could parse the mysql_list_processes() output for a string "Has read all re

RE: Where are BLOBs / TEXTs stored?

Here's one more quote, it is more relative to Alec's comment/concern about access speed. "It is unlikely that the 'field and offset are on different pages' unless the record contains a large BLOB." Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Where are BLOBs / TEXTs stored?

Here's an excerpt from the MySQL internal doc, the format is better in html but not appropriate for this forum. The last paragraph sums it up: Hexadecimal Display of Table1.MYD file F1 61 62 63 00 F5 64 00 66 00 ... .abc..d e. Here's how to read this hexadecimal-dump display: The hexadecimal

Re: DBD or InnoDB or not?

On Thu, 17 Jun 2004 09:01:57 -0500 "Scott Johnson" <[EMAIL PROTECTED]> wrote: > Hi Every one, > > I'm back to using Mysql after being away doing too many Microsoft > job. hahaha > > I'm installing my first MySQL in about five years and I'm perplexed > with the the added formats of batabase table

RE: Where are BLOBs / TEXTs stored?

When looking at the directory that stores all the files for a database, I see my table that has a TEXT column. I see "tbl.frm","tbl.myi","tbl.myd". This is the same for tables that do not have TEXT columns, so I can rule out separate files as a possible storage method for TEXT. There are also no ex

Re: How to monitor that slave is not working because of user rights?

Actually. I am talking about a machine which is at office. And inside office we're connecting using ADSL which gets dynamic Ip address. The slave server's IP address actully doesn't change. It doesn't have a real ip address only the ADSL has. Simply saying we are using NAT. What I have in mi

RE: Where are BLOBs / TEXTs stored?

[EMAIL PROTECTED] wrote on 17/06/2004 15:35:36: > > I am curious about this, too. However, I don't think that you answer the > original question. > > Are BLOBs stored as separate files, one file per object? Are they combined > into a single large BLOB file? are they aggregated into several medi

RE: Where are BLOBs / TEXTs stored?

I am curious about this, too. However, I don't think that you answer the original question. Are BLOBs stored as separate files, one file per object? Are they combined into a single large BLOB file? are they aggregated into several medium sized files? Answering "where are they stored on the disk"

DBD or InnoDB or not?

Hi Every one, I'm back to using Mysql after being away doing too many Microsoft job. hahaha I'm installing my first MySQL in about five years and I'm perplexed with the the added formats of batabase table. What are the pro's and con's of the DBD and InnoDB formats over the origional Binary? Ju

Re: How to monitor that slave is not working because of user rights?

Cemal, If the connection between your master and your slave is somehow proxied, then your slave may never know it's address changed. If your slave doesn't know it's broke, how can it fix itself? How is this "Dynamic IP" actually being performed? (specifics please) Shawn Green Database Administr

Re: How to monitor that slave is not working because of user rights?

Why should the slave stop running, just because the IP address changed? Once the slave is running, how will it know the address changed? The master will be trying to serve binlogs to the old address, but the slave won't know this. You could monitor the IP address, and stop and start the slave when

Re: How to cast string to timestamp

Cao, Wenhong wrote: Hi, I am trying to get the records for the activationstamp within a certain range. The activationstamp is defined as character(14) in the ddl. I don't know how to cast the activationstamp field to timestamp before doing the comparison. I tried to use date(), but it didn't work.

mysqladmin variables is broken

>Description: FAILS: mysqladmin -u root -P 9000 -h catchall -p variables mysqladmin: unable to show variables; error: 'Lost connection to MySQL server during query' usage: ps [ -aAdeflcjLPy ] [ -o format ] [ -t termlist ] [ -u userlist ] [ -U userlist ] [ -G grouplist ] [ -p procl

Re: How to monitor that slave is not working because of user rights?

My point was this situation should affect on Slave_SQL_Running value.. but in real it is NOT.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.gittigidiyor.com & http://www.dalar.net - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To:

Re: How to monitor that slave is not working because of user rights?

Cemal Dalar wrote: Hi all, I'm running a mysql master - slave configuration. My Slave server is on a dynamic IP address and I restricted the access to master only from specific IP address for security. I am getting backups through slave server and writted a small java application to monitor the

Re: Dumb question (joining tables)

Василий Петров wrote: I have large "fact" table, in which there are much ids (that are in fact "foreign keys" but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of "fact" columns, so it has two fie

Re: open notify

You explaination is very good. My application is in python with wxpython gui, it would be easy implement row deletion from lock-table in onclose event of dialog with details about person. (this is horrible sentence, maybe I wrote some semantical errors :)) Thank you for your time... Stano. [EMA

upgrade from 4.0.13 -> 4.1.2

Hi all, I am planning to upgrade from 4.0.13 to 4.1.2 because my department will need the subquery feature very soon, but the db server I am upgrading is a live production server, and unfortunately we don't have the resources for a testing machine to test things out. :( So I would like to ask thos

Re: open notify

Stano, There are many ways to track what goes on in an application. I suggest you implement an application based version of "row-locking". Create a table to hold a list of the IDs that you are currently editing. If a user requests to edit a person, check that table and if no entry exists add one

RE: Where are BLOBs / TEXTs stored?

Found this at http://dev.mysql.com/doc/mysql/en/BLOB.html, basically it's not stored in the table row along with any other columns in the same row. 12.4.2 The BLOB and TEXT Types Each BLOB or TEXT value is represented internally by a separately allocated object. This is in contrast to all other co

Re: using a column value in IN() in a join condition.

I do know this mail goes to the mailing list. It's right there in my CC field. I also directly respond to everyone just in case the list server does not. Yes, you should receive two copies of this letter. One directly from my mail server to you and another from the list server. Are you asking me

MySQL stops accepting connections

Hi everyone. Here's the situation. I have third-party software which is written in PHP. It makes hard use of MySQL (several queries per second, according binlog). It works smoothly most of time, but sometimes it stops accepting connections. It continues 1-20 minutes and then it works again for a

Re: starting mysql server

Check your log file for details. Probably because of file permissions of data folder. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.gittigidiyor.com & http://www.dalar.net - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <

Re: starting mysql server

Check the owner and group for /home/mikem/local/mysql/data. It should be mysql. run the following commands shell> groupadd mysql shell> useradd -g mysql mysql shell> chown -R mysql /home/mikem/local/mysql/data shell> chgrp -R mysql /home/mikem/local/mysql/data shell> ./bin

starting mysql server

Hello all, I have installed mysql and in one of the tutorials it has told me to do the following: "You can start the MySQL server with the following command: shell> ./bin/mysqld_safe --user=mysql &" However when I did this I got the following: -

Dumb question (joining tables)

I have large "fact" table, in which there are much ids (that are in fact "foreign keys" but as long as I use MyISAM engine them are not technically). So when I try to join another table (that contains text descriptions for each id from one of "fact" columns, so it has two fields (id (PK) and name))

Re[4]: Delphi 7 and MySQL

Bonjour Martijn, >> >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 >> >> anyone have an answer for my PLEASE >> >> I'am using Zeoslib (www.zeoslis.net). It's fast, free, open source and >> powerfull. MT> Does it require MySQLlib? MT> The Microolap components don't. Yes

How to monitor that slave is not working because of user rights?

Hi all, I'm running a mysql master - slave configuration. My Slave server is on a dynamic IP address and I restricted the access to master only from specific IP address for security. I am getting backups through slave server and writted a small java application to monitor the slave status by c