Grokbase › Groups › MySQL › mysql › June 2004
FAQ

MySQL > mysql > June 2004

Search Discussions

553 discussions - 1,769 posts

  • Rebuilding index takes 3 1/2 days!!! Growing pains with mysql.. I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm raid 5 on u320 perc raid cards, dell 2600/4600's with single ...
    Matt ryanMatt ryan
    Jun 30, 2004 at 6:50 pm
    Jul 22, 2004 at 12:19 pm
  • Hello, I run a toaster email server which is having trouble authenticating at times. Both methods of authentication, imap AND web for some reason just hang. I'm pretty new to MySql but I figure if ...
    Chip BellChip Bell
    Jun 29, 2004 at 3:38 pm
    Jul 6, 2004 at 1:55 pm
  • Hi, I need some help please! I have 60GB of proxy logs to parse and load into a mysql database. I've written a parsing script but I'm stuck now on how to load the data in. I have a database called ...
    J SJ S
    Jun 9, 2004 at 6:36 pm
    Jun 25, 2004 at 10:22 pm
  • Does anyone know when INDEX DESC will be implemented? I'm storing time values and want to access the data from the most recent time value without sorting the result set. Thanks!
    Alejandro HeyworthAlejandro Heyworth
    Jun 23, 2004 at 3:37 pm
    Jun 28, 2004 at 5:24 am
  • MySQL Server: 4.1.1 alpha MySQL Control Center: 0.9.4 beta I am not sure whether this is a Control Center or MySQL Server problem, but here it goes: I have a database with MyISAM tables created using ...
    Silvio Lopes de OliveiraSilvio Lopes de Oliveira
    Jun 2, 2004 at 3:39 pm
    Jun 3, 2004 at 5:27 pm
  • Hi - I need some help :) I set up a simple mysql table: mysql describe ip2org; +----------+-------------+------+-----+---------+-------+ +----------+-------------+------+-----+---------+-------+ 3 ...
    MerchantSenseMerchantSense
    Jun 25, 2004 at 2:46 am
    Jun 25, 2004 at 6:33 pm
  • Hi, select * from ytbl_development as t1 where (t1.txtDevPostCode REGEXP "^[[:alpha:]]{1,2}[[:digit:]]{1,2}[[:alpha:]]{0,1}" in #QuotedValueList(qryRadius.shortpostcode)#) The above Where clause ...
    ZzapperZzapper
    Jun 29, 2004 at 5:53 pm
    Jul 1, 2004 at 8:55 am
  • We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. We can get going again after doing an ALTER ...
    Kevin BrockKevin Brock
    Jun 19, 2004 at 12:16 am
    Jun 23, 2004 at 8:24 pm
  • Hi Everyone. I have the following a table with a varchar column that contains a comma delimited list of id's from another table that relates the item keywords in the other table. The table keywords ...
    Andrew Dixon - MSO.netAndrew Dixon - MSO.net
    Jun 11, 2004 at 11:22 am
    Jun 28, 2004 at 8:40 pm
  • I haven't worked with dates yet and wondered if someone could give me an overview in plain English. At the moment, I'm working on a table with a column of dates in this format: March 2, 2003 July 7, ...
    David BlomstromDavid Blomstrom
    Jun 22, 2004 at 6:40 am
    Jun 22, 2004 at 9:14 pm
  • Hi i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do anyone have an answer for my PLEASE Johan H
    Johan HarmseJohan Harmse
    Jun 15, 2004 at 1:35 pm
    Jun 18, 2004 at 5:20 am
  • The schema in question needs a redesign (dynamic row format, contains two BLOB columns) but I was wondering if anyone has written up some guidelines for general data warehouse configuration of MySQL ...
    DossyDossy
    Jun 3, 2004 at 2:20 pm
    Jun 3, 2004 at 8:11 pm
  • Hi, I got an error 27. DBD::mysql::st execute failed: Got error 27 from table handler at /home/u752359/logfile.pl line 144, <PS_F line 3079464. The FAQs say: Check whether you have hit 2 Gb limit. If ...
    J SJ S
    Jun 25, 2004 at 7:52 am
    Jun 26, 2004 at 4:57 pm
  • I have never done anything like this but after looking at the spec's I have a possible direction for you.... In String functions there is LOCATE(substr,str,pos) The first syntax returns the position ...
    Paul McNeilPaul McNeil
    Jun 8, 2004 at 11:59 am
    Jun 11, 2004 at 9:22 pm
  • I have a large table (64,000,000 rows). Everything was fine when the table was 16,000,000 rows, now connectorJ crashes: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: 6 at ...
    Leonardo FrancalanciLeonardo Francalanci
    Jun 22, 2004 at 1:45 pm
    Jun 22, 2004 at 7:35 pm
  • Hi All I have a puzzle or more like a mental block that needs some sensible thought inputs please. If I odbc inot mysql and pull out records and make chnages how do I put the changes back into mysql ...
    Business A2ZBusiness A2Z
    Jun 14, 2004 at 7:46 pm
    Jun 15, 2004 at 8:57 pm
  • Hi, This seems to be a strange situation. I have a server ( Sun fire v65x ) running SuSE 8.2 and My-Sql 4.1.1alpha-max. I've detected that when our adsl internet connection is down the querys on our ...
    Mauricio PellegriniMauricio Pellegrini
    Jun 3, 2004 at 7:42 pm
    Jun 8, 2004 at 9:42 pm
  • Hi, I would appreciate any help on this: I got approximate same timing on following two: case 1: create 1 jdbc connection and issue 4 queries sequentially case 2: create 4 jdbc connections and issue ...
    Haitao JiangHaitao Jiang
    Jun 7, 2004 at 11:13 pm
    Jun 8, 2004 at 6:20 pm
  • Hi all, I have mysql table that has a field named 'crea_dt' (it records the creation date of data)... I want to delete records that have passed for more than a day description like this : if ...
    StarofframeStarofframe
    Jun 8, 2004 at 12:27 am
    Jun 8, 2004 at 3:53 am
  • Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything :(((( root@leya [~]# service mysql start root@leya [~]# mysql ERROR ...
    PouravePourave
    Jun 5, 2004 at 4:20 pm
    Jun 6, 2004 at 9:45 pm
  • I have two mysql servers as shown below: MySQL server A: version 3.23.58, database: mydb, table: mytable MySQL server B: version 5.0.0-alpha-standard-log I want the server B to have the exact same ...
    Bing DuBing Du
    Jun 29, 2004 at 6:35 pm
    Jun 29, 2004 at 9:40 pm
  • 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 ...
    Cemal DalarCemal Dalar
    Jun 17, 2004 at 7:31 am
    Jun 21, 2004 at 4:10 am
  • [ Please CC me ] Hi, http://dev.mysql.com/doc/mysql/en/Storage_requirements.html Page says: --- "The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and TEXT column accounts for ...
    Luis R. RodriguezLuis R. Rodriguez
    Jun 17, 2004 at 12:37 am
    Jun 17, 2004 at 3:55 pm
  • Probably simple but I can't figure it out! THe manual section 3.3.4.8 has the example SELECT owner, COUNT(*) FROM pet GROUP BY owner which is fine. Now what I want to do is count the number of rows ...
    Dave TorrDave Torr
    Jun 15, 2004 at 2:00 am
    Jun 15, 2004 at 9:25 pm
  • I just installed mysql using Xampp, an installer for Apache, Mysql, PHP installation. Everything else works fine, but mysql will not start with the Apache startup. When I try to do a manual startup ...
    Curtis Seyfried 2Curtis Seyfried 2
    Jun 14, 2004 at 9:39 am
    Jun 15, 2004 at 8:58 pm
  • Hello all, I see a similar question was asked before, but it was not answered. I hope someone can assist me. My query uses two tables. The query selects one row on table b for each row on table a, ...
    Emmanuel van der MeulenEmmanuel van der Meulen
    Jun 7, 2004 at 4:48 am
    Jun 12, 2004 at 5:29 pm
  • If your table contains a timestamp field, it will update each time the row is altered. Otherwise I don't think it's possible. You Wrote --------- Hello I am using PHP, MySQL. How would I query MySQL ...
    Paul McNeilPaul McNeil
    Jun 10, 2004 at 10:15 am
    Jun 11, 2004 at 12:40 pm
  • I just got my first MySQL database online, but I have some questions. First, if I want to import a database named, say username_jack, do I have to create a database named username_jack online first? ...
    David BlomstromDavid Blomstrom
    Jun 3, 2004 at 2:36 am
    Jun 3, 2004 at 6:14 pm
  • Hi, I am using MySQL 4.0.17. When I try to create a foreign key on a field of the type text, I get this error: 040609 15:02:31 Error in foreign key constraint of table db_name/tb_name: There is no ...
    Sudip ShekhawatSudip Shekhawat
    Jun 9, 2004 at 7:33 pm
    Aug 13, 2004 at 7:53 pm
  • Suppose I have a field with the names of states, linked to their home pages: <a href="http://www.alabama.gov/" Alabama</a <a href="http://access.wa.gov/" Washington</a If I display this on a webpage, ...
    David BlomstromDavid Blomstrom
    Jun 22, 2004 at 12:58 am
    Jun 23, 2004 at 1:19 pm
  • I am getting the above error (the number is wrong - manual says this is 1249) on a statement of the form (SELECT species_table.species_id,count(*) as c FROM species_table INNER JOIN checklist_table ...
    Dave TorrDave Torr
    Jun 15, 2004 at 6:39 am
    Jun 16, 2004 at 10:23 pm
  • I'm not sure if I'm wrestling with a 1) PHP problem, 2) MySQL problem, or 3) operator error. I have a really a page with a really nice script for querying my database. I've previewed a variety of ...
    David BlomstromDavid Blomstrom
    Jun 14, 2004 at 10:51 pm
    Jun 15, 2004 at 6:40 pm
  • Hi, What is the maximum number of simulataneous connections that can exist for MySQL. Can we change this limit? If yes please tell me how to do this. I am using MySQL4.1 in Linux. Thanks, ramana.
    Venkata ramanaVenkata ramana
    Jun 11, 2004 at 10:53 am
    Jun 12, 2004 at 3:43 pm
  • I'm using MySQL version 4.0.18. I have two datetime columns in the same table, one that represents a start time and the other that represents an end time. I would like to write a query that will show ...
    Dirk Bremer \(NISC\)Dirk Bremer \(NISC\)
    Jun 11, 2004 at 6:57 pm
    Jun 11, 2004 at 8:06 pm
  • Hi I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master where I have attached a slave to for replication. The problem now is that on the master there is a LOT of mysql-bin.XXX ...
    Søren NeigaardSøren Neigaard
    Jun 10, 2004 at 6:05 am
    Jun 11, 2004 at 11:26 am
  • I am having a update problem, I have a table that has 28 columns they are name 1-28. I am able to insert data into the table. When I try to update info into the table it does not work. Any ideas?
    Blake SchroederBlake Schroeder
    Jun 9, 2004 at 5:37 pm
    Jun 9, 2004 at 6:11 pm
  • I'm trying to figure out how to get my MySQL databases online. Someone told me to EXPORT my databases as SQL files, then go into my online websites's phpMyAdmin program and import it, and everything ...
    David BlomstromDavid Blomstrom
    Jun 2, 2004 at 11:57 pm
    Jun 3, 2004 at 6:14 pm
  • Hi Guys, I'm just wondering if anyone could tell me when 4.1 will be moving to Beta? I was told by a MySQL guy at Linux Conf AU 2004 (January) that 4.1 would be in Beta by March!! As such, we have ...
    Jonathan SoongJonathan Soong
    Jun 1, 2004 at 12:26 am
    Jun 1, 2004 at 2:14 pm
  • Hi, I would like to switch off the logging that creates the large files below (in the mysql data directory) Could someone tell me how to do this please? Thanks, js. # ls -l total 5418648 -rw-rw---- 1 ...
    J SJ S
    Jun 30, 2004 at 5:09 pm
    Jul 15, 2004 at 6:32 pm
  • O.K. you SQL gurus-- I have a difficult query for you that has me stumped. The table has two columns: rowID (MEDIUMINT-but *NOT* AUTO_INCREMENT) and theDate (DATETIME). I need it to find: 1. The ...
    John MistlerJohn Mistler
    Jun 28, 2004 at 8:31 am
    Jun 29, 2004 at 7:05 pm
  • We have an internal SNMP monitoring system that is monitoring about 10,000 devices. Each device is pinged then pulled for about an average of 25-30 elements. Each of the ping results and elements are ...
    Aram MirzadehAram Mirzadeh
    Jun 22, 2004 at 5:30 pm
    Jun 28, 2004 at 8:31 pm
  • I think I recall a thread where someone mentioned merging two fields. If that can be done, I'd like to know how. For example, suppose I have a field filled with place names, next to a field filled ...
    David BlomstromDavid Blomstrom
    Jun 27, 2004 at 6:07 am
    Jun 28, 2004 at 3:22 am
  • Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks
    Jerome greeneJerome greene
    Jun 5, 2004 at 4:54 am
    Jun 27, 2004 at 3:16 pm
  • ( first.. sorry for my english ) hello people.. i have read multiple websites and posts.. and this mail list archive but i have not found the answer to the question: how is it possible to do a backup ...
    D2clonD2clon
    Jun 24, 2004 at 9:08 am
    Jun 25, 2004 at 12:04 pm
  • Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, ...
    Roy NasserRoy Nasser
    Jun 18, 2004 at 1:55 pm
    Jun 23, 2004 at 12:49 am
  • 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 ...
    Luiz Rafael Culik GuimaraesLuiz Rafael Culik Guimaraes
    Jun 18, 2004 at 12:44 am
    Jun 21, 2004 at 1:43 pm
  • I have a MySQL table with about 3,500 rows and 30 columns. There are rows for each of the world's nations, each of the 50 states, some 3,000 U.S. counties, Canada's provinces, etc. Obviously, I can't ...
    David BlomstromDavid Blomstrom
    Jun 13, 2004 at 6:26 pm
    Jun 14, 2004 at 1:06 am
  • Hi, Is it possible to DELETE from more than one table in one command? Thanks for your help Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
    Shaun thornburghShaun thornburgh
    Jun 7, 2004 at 11:38 am
    Jun 9, 2004 at 11:20 am
  • We're looking for a client-server instant messaging system (opensource), powered by MySQL if possible. Anyone know of one? I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo, ...
    TerenceTerence
    Jun 8, 2004 at 5:57 am
    Jun 8, 2004 at 3:08 pm
  • CONTACT_X_CUSTOMER.ID_ADDRESS CUSTOMER.ID_ADDRESS_SHIPTO CUSTOMER.ID_ADDRESS_MAIN What I would like is to be able to JOIN conditionally based on the absence/presence of reference SELECT ADDRESS.ID ...
    Luc FoisyLuc Foisy
    Jun 2, 2004 at 1:46 pm
    Jun 3, 2004 at 1:37 pm
Jun 2004
12345…12
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions553
posts1,769
users552
websitemysql.com
irc#mysql

552 users for June 2004

Sgreen: 96 posts Michael Stassen: 86 posts Victor Pendleton: 53 posts Egor Egorov: 47 posts David Blomstrom: 46 posts Gerald_clark: 28 posts Paul DuBois: 27 posts J S: 26 posts Leonardo Francalanci: 23 posts Jeff Smelser: 22 posts Robert A. Rosenberg: 21 posts Josh Trutwin: 16 posts Martijn Tonies: 15 posts Andrew Pattison: 13 posts Eric Bergen: 13 posts Shaun thornburgh: 13 posts David Griffiths: 12 posts Chip Bell: 11 posts Daniel Clark: 11 posts Dan Nelson: 11 posts
show more
Archives