Help: Script stopped working

I had a transaction script that "was" working fine. Now I think it maybe due to a "duplicate key error". At least that is the error being printed out. Here is the table "Profiles_Skicerts"[innodb]: P_ID - PK, Normal Index (int) Skicert - PK, Normal Index (varchar) N_Year - int, allow null L_Used -

MySQL server is taking all my hardrive space

Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used and I realized that the directory that is taking the most space is /var/lib/mysql I know that now I have much less database records than I used to have and I have the same database structure h

Re: Trying to match on something that is not there

Sorry, I'm used to oracle, thought this was a standard query. > Brian wrote: > > select s.userid from surveyanswers s where s.userid not in (select > > distinct u.id from users u) > > > > > > On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAIL PROTECTED]> wrote: > > > >>I have a user who

Re: MySql basics?

Steve - This is a good place to start: http://dev.mysql.com/doc/mysql/en/Tutorial.html This is also very good for installing on MacOSX: http://www.entropy.ch/software/macosx/mysql/ HTH...James On Oct 20, 2004, at 9:44 PM, Steve Grosz wrote: Where would I find a good online tutorial

Re: Char to Varchar on Innodb

I'm not too worried about it myself, but I can see how less magic on a database server is better. Without actually trying it, if I mix CHAR's and VARCHAR's in a table, does SHOW CREATE TABLE reflect the internal conversion? If you wanted to reduce fragmentation in an Innodb table, wouldn't all th

Re: B-tree index question

If you are using MyISAM tables, have you thought about using MERGE tables instead? You could partition your table into several smaller tables. I don't know how the performance would be on a billion record table, but from my understanding it would shrink your index down. http://dev.mysql.com/doc/my

MySql basics?

Where would I find a good online tutorial that would step me through understanding setting up seperate tables, and the relationships between then? Thanks so much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: mysqldump and binary logs

If you are using a replica, you can grab the information from SHOW SLAVE STATUS or SHOW MASTER STATUS. I'm not too sure if there is a call for non-replicated database servers for this. BTW, if you aren't locking everything you're dumping, you'll probably never get a consistent state if you want to

Re: Trying to match on something that is not there

Or without a subquery, SELECT s.questionid, s.userid FROM SurveyAnswers s LEFT JOIN Users u ON u.id = s.userid WHERE u.id IS NULL; Brian wrote: select s.userid from surveyanswers s where s.userid not in (select distinct u.id from users u) On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAI

Filed names with trailing spaces

I had created a table and started populating it, but did not get to certain fields until later. When I tried to do an insert it would not go. It was not reconizing 2 fields. I read and re-read the statement etc. Tried it from phpMyAdmin, command line and my php script. Anyways, I removed one f

Error Starting MySQL 4.0.21

I have a new linux server that I just installed the mysql-max-4.0.21-pc-linux-i686 binary on. The installation had no errors. However, it is not starting on startup because of the following error: Can't execute ./bin/mysqld_safe from dir /var/lib I can start MySQL manually running '/usr/local/

Re: How to make 1 primary key work for 2 columns????

Seldom wrong and right again, Shawn! Yes, I forgot to cover the reflexive case. I don't have a magic bullet for that scenario; you'd just have to check that with application code. But on re-reading his original post, it occurred to me that I had misread it completely. I just sent a note outlining

RE: How to make 1 primary key work for 2 columns????

But rhino, your constraints don't cover the case of : Primary Secondary --- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] This passes all of your constraints (the primary key and both unique keys) but I think it fails his busines

Odd MySQL error

I have searched the archives (well, the search never came back...), and I have searched the web, but found very little that could help with the scenario that we are currently experiencing. We have the 4.0.21 RPM's installed direct from MySQL.com on a Fedora Core 2 server. The previous incarnat

RE: How to make 1 primary key work for 2 columns????

I wonder if it is possible for MySQL to create a virtual table upon every SQL selection by grabbing emails from two columns into an imaginationary table in the server's memory. So, what is the SQL term for that? That way, I can match it against it to see if it is a match or not. I can do that wi

Revert a column to its default value

Hi all, Is it possible in mysql 3.23 to update a row and revert a column back to its default value. Not the default value for the type, but the value defined as the column default. for example a column is defined as : picture_name VARCHAR(25) NOT NULL DEFAULT 'no_photo.gif' if someone removes t

RE: How to make 1 primary key work for 2 columns????

Sorry you didn't understand what's I'm asking for. It take some logical thought to see the picture. Now I know I will have to enforce it with the application code (PHP, HTML and JavaScript) with the current two column model. Thanks for this idea Scott

RE: How to make 1 primary key work for 2 columns????

Aw Man! I forgot about the null value... Since there will be some null values, so I can't use the primary key. So, I now know it is not possible. Thanks for reminding me that. So, seem that the workaround for me is to retrieve all of the emails from the primary contact and secondary contact in

Re: How to make 1 primary key work for 2 columns????

I couldn't understand exactly what you were asking for. Did you want no duplicates between columns or no duplicates between companies or what? This is something you will either enforce in your application code (with your two column model) - OR - you will have to redesign your Primary and Second

How to make 1 primary key work for 2 columns????

Hi! I'm trying to figure out how to make this possible... What I have here is a company address, along with both the primary contact and secondary contact. In them is one email address from the primary contact and one other email address from the secondary contact. Problem is setting an unique

mysql-administrator

Has anyone seen this before with mysql-administrator? /usr/local/bin/mysql-administrator: line 9: 19856 Segmentation fault $MYPATH/mysql-administrator-bin I get this everytime i go to schema privileges to assian a user rights. -- MySQL General Mailing List For list archives: http://lists.mysql

RE: Determining if query will work

See embedded comments "Eve Atley" <[EMAIL PROTECTED]> wrote on 10/20/2004 03:33:41 PM: > > Based on Shawn's tips, I revised the query to read thusly: > > SELECT * > FROM wow.resume r > INNER JOIN wow.candidate c > ON c.Candidate_ID = r.Candidate_ID > WHERE r.Section_ID = '1'

Re: Java.lang.outOfMemoryError on large ResultSet

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John McCaskey wrote: | The problem is not the memory on the database server, but on the client | running the JDBC connection. Seems that when you retrieve the result it | is trying to store everything in memory at once. | | Here is some info from the m

Re: Java.lang.outOfMemoryError on large ResultSet

The problem is not the memory on the database server, but on the client running the JDBC connection. Seems that when you retrieve the result it is trying to store everything in memory at once. Here is some info from the mysql docs that looks like it pertains, see http://dev.mysql.com/doc/connecto

RE: Determining if query will work

Based on Shawn's tips, I revised the query to read thusly: SELECT * FROM wow.resume r INNER JOIN wow.candidate c ON c.Candidate_ID = r.Candidate_ID WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+peoplesoft' IN BOOLEAN MODE); INSERT INTO wow.resume_erp (Candid

Java.lang.outOfMemoryError on large ResultSet

MySQL 5.0 Alpha Jdbc Driver: Connector J OS: Windows 2000 Professional Table Size 1 Mil. Records. Table Structure: Table1 logid - autoincrement int(11) Timestamp - timestamp Timestamp2 - timestamp Tag - varchar(15) Query/Code: --- PreparedStatement pst = con.prepareStatement("Select log

Re: where to download older versions?

On Thu, Oct 14, 2004 at 02:23:09PM +0200, [EMAIL PROTECTED] wrote: > please, where can I download older version (4.0.20) of mysql for Windows? > I searched archives, documentation, no advice. > > In fact, I only need libmysql.dll file - can anybody send me? Sorry, there was a mixup that caused th

Re: Determining if query will work

First a bit of friendly advice: When performing an INSERT...SELECT... it is better to explicitly list the source columns (part of the SELECT statement). Doing so will ensure that if you re-order some columns or if you add/drop columns to/from one of the tables participating in the SELECT port

Determining if query will work

I am attempting to copy data from 1 table into another, based on certain criteria. I have set up the following queries, but am unsure if they will function properly: #This pulls back all data for matching candidates with keyword from RESUME and CANDIDATE SELECT * FROM wow.resume r INNER JOIN wow.c

Display a blob from Mysql into Coldfusion?

I am trying to store images in the longblob text type in one of my tables, and then display the picture on a Coldfusion MX 6.1 page. When I try to get it to display, I get the following error: ByteArray objects cannot be converted to strings. The error occurred in C:\Web Sites\Scooter2\Scooters\V

Re: Sharing databases between win and linux

See below... Lau Sennels <[EMAIL PROTECTED]> wrote on 10/20/2004 12:49:19 PM: > Thanks for your reply. > > > >[client] > > >#password = your_password > > >port= 3306 > > >socket = /var/lib/mysql/mysql.sock > > > > Your client needs to connect to the windows machine, n

Determining if query will work

I am attempting to copy data from 1 table into another, based on certain criteria. I have set up the following queries, but am unsure if they will function properly: #This pulls back all data for matching candidates with keyword from RESUME and CANDIDATE SELECT * FROM wow.resume r INNER JOIN wow.

Re: Sharing databases between win and linux

> try adding to my.cnf: > > lower_case_table_names=1 You have a point it seems. Some tables, ones created with all lower-case names/keys are actually accessible. Thanks. Lau -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: Sharing databases between win and linux

Thanks for your reply. > >[client] > >#password = your_password > >port= 3306 > >socket = /var/lib/mysql/mysql.sock > > Your client needs to connect to the windows machine, not a local socket. The files are on the local machine. This is not a server/client setup, but tw

RE: select for text within a field.

Shanta McBain on Wednesday, October 20, 2004 9:29 AM said: > [% FOREACH link = DBI.query("SELECT * FROM url_tb > WHERE products LIKE 'honey' > AND (site_name = 'Apis' OR > site_name = 'All') >

Re: Sharing databases between win and linux

Hi Michael. > try adding to my.cnf: > > lower_case_table_names=1 That doesn't do the trick unfortunately. Setting the above should affect both the way future tables are stored /and/ the way mysql looks up names of existing tables, right? Lau -- MySQL General Mailing List For list archives:

Re: Sharing databases between win and linux

Lau Sennels wrote: Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton accessible from both OS's. I am able to access the database transparently from Win XP by modifying my.cfg as described in th

select for text within a field.

Hi all I am trying to get my mind around the process of searching for a text within a field. On one of my sites I collect information from users about the products they sell. This is from a predefined list of keywords. such as "Bees" "queens" "honey" (code is TTML) [% FOREACH link = DBI.que

Re: Sharing databases between win and linux

I also share databases Linux to XP. It could be an uppercase/lowercase issue, try adding to my.cnf: lower_case_table_names=1 Lau Sennels wrote: Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton

Sharing databases between win and linux

Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton accessible from both OS's. I am able to access the database transparently from Win XP by modifying my.cfg as described in the manual. The pro

migration of InnoDB 4.1.3 to 4.1.6

I see from the release notes that tables with timestamp column will need to be rebuilt. will the server automatically do this upon startup? thanks, jeff -- Jeff Mathis, Ph.D. 505-955-1434 Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste

mysqldump and binary logs

Hi All I have databases that are writing binary logs that I back up daily using mysqldump. I was wondering what is the best way to determine which binary logs have been created after the mysqldump, in the situation where I might do some restore that will involve the logs. Thanks Gabe <><><>

Re: Innodb foreign keys names

Martijn, - Alkuperäinen viesti - Lähettäjä: "Martijn Tonies" <[EMAIL PROTECTED]> Vastaanottaja: <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, October 20, 2004 11:34 AM Aihe: Re: Innodb foreign keys names > Hello Heikki, > ... > Thank you for your reply. > > One qu

Re: Commercial Licensing Question

From: "mos" <[EMAIL PROTECTED]> Mike, > >but the current license seems require a > >commercial license only if you distribute MySQL with your commercial > >product. > I'm sorry, but I believe your statement is incorrect. If you distribute an > application (outside of the GPL) that requires MySQL t

Re: Innodb foreign keys names

Thanks Heikki for your response : it works perfectly with the brand new version (4.1.6), I'm gonna drop all my old foreign keys now and rename them with an appropriate name... bye -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vitrine : www.c

RE: Re[2]: Commercial Licensing Question

But isn't it your job to inform the person reciving application about the license? -Original Message- From: DebugasRu [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 10:57 AM To: [EMAIL PROTECTED] Subject: Re[2]: Commercial Licensing Question Exactly: m> If you distribute an

Re[2]: Commercial Licensing Question

Exactly: m> If you distribute an application (outside of the GPL) that requires MySQL to run m> then THE PERSON RECEIVING the application needs a commercial MySQL license. Whether the person in question gets the license from you or someone else is not your problem -- MySQL General Mailing List

Re: Commercial Licensing Question

Jigal, but the current license seems require a commercial license only if you distribute MySQL with your commercial product. I'm sorry, but I believe your statement is incorrect. If you distribute an application (outside of the GPL) that requires MySQL to run (whether you distribute the MySQL en

Re: SELECTING Non existing Dates

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > With a LEFT JOIN you will get back your "zero hours" only if there exist > records in the Timesheets table that match no records in the projects > table. If you have no Timesheets data for the 23rd or 24th, then you > can't have any r

Re: MySQL Database Corruption (InnoDB), according to Innodb Hot Backup

David, - Alkuperäinen viesti - Lähettäjä: "David Griffiths" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Tuesday, October 19, 2004 9:33 PM Aihe: Re: MySQL Database Corruption (InnoDB), according to Innodb Hot Backup > No wor

Re: SELECTING Non existing Dates

With a LEFT JOIN you will get back your "zero hours" only if there exist records in the Timesheets table that match no records in the projects table. If you have no Timesheets data for the 23rd or 24th, then you can't have any rows in your results for those dates. MySQL won't fill in the miss

Re: Script question

Just so everyone is up to speed: The "system" client command is only available on Unix-like systems. To quote: http://dev.mysql.com/doc/mysql/en/mysql_Commands.html >>The edit, nopager, pager, and system commands work only in Unix. << So depending on your OS, that command may or may not be avai

Re: SELECTING Non existing Dates

Hello Shaun, > I have query that I am using to try to get the number of hours worked and on > which project by an employee during a particular week. Here is the query: > > SELECT T.Date, T.Hours, P.Project_Name > FROM Timesheets T > LEFT JOIN Projects P ON P.Project_ID = T.Project_ID > WHERE T.Dat

Sharing database files between EMBEDDED MYSQL and MySQL Server

Hello all, I have an application that uses mysql embedded (performance issues ...). The app itself works fine, but data adminsitration (issuing DDL, DML statements ) is very complicated using C API... So, I created an entry in my.cnf pointing to directory where database used by embedded is, aimi

SELECTING Non existing Dates

Hi, I have query that I am using to try to get the number of hours worked and on which project by an employee during a particular week. Here is the query: SELECT T.Date, T.Hours, P.Project_Name FROM Timesheets T LEFT JOIN Projects P ON P.Project_ID = T.Project_ID WHERE T.Date >= "2004-10-18" AND

Re: Commercial Licensing Question

> We intend to use MySQL database in one of our commercial applications. > We would like to know whether we need to buy MySQL license for each > of our product installations. Or How many installations can we make with > one commercial license of MySQL database. In general: The answer you will hea

RE: Commercial Licensing Question

http://www.mysql.com/company/legal/licensing/commercial-license.html : "With a commercial non-GPL MySQL server license, one license is required per database server (single installed MySQL binary). There are no restrictions on the number of connections, number of CPUs, memory or disks to that one M

Re: B-tree index question

Thanks for the informative reply Sergei, We're actually just using an INT field at the moment, we were going to move over to BIGINT when we start using 64-bit MySQL (soon). Do you know where I should look for information on writing our own table handler? Thanks, -Phil - Original Message

Re: B-tree index question

Thanks for the reply. We're actually using DELAY_KEY_WRITE on our tables. The manual says (7.2.15): Declaring a MyISAM table with the DELAY_KEY_WRITE=1 table option makes index updates faster because they are not flushed to disk until the table is closed. Does this work with all types of indexe

Commercial Licensing Question

Hi, We intend to use MySQL database in one of our commercial applications. We would like to know whether we need to buy MySQL license for each of our product installations. Or How many installations can we make with one commercial license of MySQL database. Expecting the reply at the earliest.

Re: Char to Varchar on Innodb

Hello, > those 'silent column specification changes' affect all table types. That > feature has caused lots of user questions over years. It is in the TODO to > remove that feature from MySQL, because it is not standards compliant. In > InnoDB, a reason to use a CHAR column in some cases is to red

Re: Innodb foreign keys names

Hello Heikki, > >> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > >> > > >> >Does a newer version allow you to change/set the names yourself? > >> > >> you can give the name yourself in new versions. Please look at the InnoDB > >> manual section. > > > > "A constraint name can

Re: Char to Varchar on Innodb

Gary, those 'silent column specification changes' affect all table types. That feature has caused lots of user questions over years. It is in the TODO to remove that feature from MySQL, because it is not standards compliant. In InnoDB, a reason to use a CHAR column in some cases is to reduce fr

Re: B-tree index question

Hi! On Oct 23, Phil Bitis wrote: > Hello, > > We want to be able to insert records into a table containing a billion > records in a timely fashion. > The table has one primary key, which I understand is implemented using > B-trees, causing insertion to slow by log N. Corect. But for auto_increme

Re: Innodb foreign keys names

Martijn, - Original Message - From: ""Martijn Tonies"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 20, 2004 10:08 AM Subject: Re: Innodb foreign keys names Hello Heikki, > >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > >Does a newer

Re: match a fulltext search with a "-" dash, can't match if - exist

On Mon, Oct 18, 2004 at 11:19:55AM +0800, Louie Miranda wrote: > > mysql> select * from fullsearch where match (title,body) against ('018-E'); > Empty set (0.00 sec) > > > it returns an empty set, is it possible to also search with "-" dash? chars? If I remember correctly, you need to pass the

Re: Innodb foreign keys names

Hello Heikki, > > > >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > > > >Does a newer version allow you to change/set the names yourself? > > you can give the name yourself in new versions. Please look at the InnoDB > manual section. "A constraint name can be given as of MySQL 4.