FAQ

Search Discussions

1,049 discussions - 2,577 posts

  • send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 ...
    JonJon
    Apr 9, 2001 at 7:34 pm
    Apr 12, 2001 at 7:03 pm
  • Hello mysql, I've resenty tried to becnhmark mysql in really simple case. I need to select indexes really fast so I did "select * from pages where hash=11" there was a key on hash and the query ...
    Peter ZaitsevPeter Zaitsev
    Apr 5, 2001 at 2:59 pm
    Apr 7, 2001 at 8:21 pm
  • Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under ...
    WebmasterWebmaster
    Apr 16, 2001 at 4:05 pm
    Apr 24, 2001 at 2:38 pm
  • Hi, I am running a query using C APIs to insert a large text item into a MySQL table. The query is as follows sprintf(szQuery,"Insert into mytable(mycol)values '%s' ", mydata); where mydata is a C ...
    Shambhu Kumar singhShambhu Kumar singh
    Apr 12, 2001 at 11:28 am
    Apr 12, 2001 at 12:05 pm
  • I have a table, that DOES NOT have a primary key, but is setup like this: Field Type Attributes Null Default Extra Action PageID int(11) No 0 Change Drop Primary Index Unique ArticleID int(11) No 0 ...
    VigileVigile
    Apr 6, 2001 at 5:24 am
    Apr 7, 2001 at 5:20 am
  • Well, cool. If that works I'm happy. I was trying to go by the README and use automake. Thanks! It'd sure be nice if somebody fixed the docs, or at least put a note on the web site that said they're ...
    Michael J. KobbMichael J. Kobb
    Apr 29, 2001 at 1:05 am
    Apr 29, 2001 at 3:35 pm
  • I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql use lumina; Reading table information for completion of table and ...
    New Style MySQL PersonnelNew Style MySQL Personnel
    Apr 23, 2001 at 8:04 am
    Apr 24, 2001 at 8:23 pm
  • Greetings, mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the output when I try to make it. [relson@osage mysqlgui-src-1.7.5]$ make make: *** No rule to make target `edfile.o', ...
    David RelsonDavid Relson
    Apr 15, 2001 at 1:31 pm
    Apr 17, 2001 at 2:31 pm
  • This is an open plea to the MySQL team. The amount of spam and other noise on the list has been growing more and more every day. I would like to make a couple basic plea's. The first, is that you ...
    Eric FitzgeraldEric Fitzgerald
    Apr 4, 2001 at 5:11 pm
    Apr 6, 2001 at 9:42 am
  • in Mysql documents section 4.16.5 Options files it is documented as : ------------------------------------------------------------ MySQL reads default options from the following files on Windows: ...
    Yusuf IncekaraYusuf Incekara
    Apr 17, 2001 at 7:00 am
    Apr 19, 2001 at 9:33 am
  • System: Linux ujeli.mos.com.np 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading ...
    UjwolUjwol
    Apr 3, 2001 at 9:49 am
    Apr 3, 2001 at 1:42 pm
  • Is there a way to store the time and date that a record was added within MySQL? I want to show the time and date on some of my records and can't seem to figure out an easy way to do it. Thanks! -Chris
    ChrisChris
    Apr 3, 2001 at 12:24 am
    May 25, 2001 at 9:41 pm
  • Just use mysqlbinlog to analyze a remote host binlog. mysql -h ip_address -u user -p pass file For instance (My environment): shell mysql -h 192.168.1.11 -u awp -p root etosha-bin.001 Copyright (C) ...
    GustavoGustavo
    Apr 29, 2001 at 6:13 pm
    Apr 30, 2001 at 5:15 pm
  • For example i have 3 tables (really i have to make it with 6 tables, but...) So 3 tables: Table1 uid | name 1 user1 2 user2 3 user3 Table2 id uid c 1 1 50 2 1 23 3 1 42 4 2 23 5 2 303 Table3 id c txt ...
    Z_da_eXTaZieZ_da_eXTaZie
    Apr 23, 2001 at 12:19 pm
    Apr 24, 2001 at 11:41 am
  • I would like to do something similar to an ORDER BY in one of my select statements, but I'mt not sure how to do something as complicated as this: I have two columns, category and subcategory, that I ...
    Jeff Shipman - SysProgJeff Shipman - SysProg
    Apr 20, 2001 at 6:36 pm
    Apr 23, 2001 at 2:10 pm
  • If I understand the manual correctly when I do a "select blah from blah where blah = blah order by blah limit 10" Mysql finds the first 10 matching records and then sorts those records. How do I have ...
    Mat MurdockMat Murdock
    Apr 4, 2001 at 11:34 pm
    Apr 19, 2001 at 5:56 pm
  • Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding
    JohndJohnd
    Apr 19, 2001 at 3:41 pm
    Apr 19, 2001 at 5:43 pm
  • Hi, I goot this error when I type "make" apache after installating (mysql-3.23.36-pc-linux-gnu-i686.tar.gz) configurating it with php 4.0.4pr1 on RedHat 7.0, the problème as seen bellow seems to be ...
    Mohamed OuldMohamed Ould
    Apr 9, 2001 at 5:28 pm
    Apr 12, 2001 at 4:26 pm
  • Hello mysql, I made one more test of mysql perfomance. PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 I had the followings table with 12.000.000 rows (well I checked this with 10000 rows as well but the speed ...
    Peter ZaitsevPeter Zaitsev
    Apr 6, 2001 at 8:21 am
    Apr 9, 2001 at 2:14 pm
  • OS: Red Hat Linux 6.0 / Intel 1GB RAM MySQL 3.23.36 PHP4.0.4PL1 Linux kernel 2.4.3 Using the my.cnf for medium sized sites mySQL starts with safe_mysqld and there are three threads running. Queries ...
    Hunter HillegasHunter Hillegas
    Apr 25, 2001 at 3:20 pm
    Apr 26, 2001 at 5:34 pm
  • I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting to a MySQL db running on a linux box. When I try to connect, I get a dialoge that says: ODBC -- call failed. ...
    Fenn RiderFenn Rider
    Apr 11, 2001 at 9:37 pm
    Apr 12, 2001 at 2:01 pm
  • Dear Y'all - I've developed a diff-based testing framework in perl. It's used to qualify modifications we want to make to systems (i.e. applying patches, installing applications...) for deployment to ...
    William GoedickeWilliam Goedicke
    Apr 5, 2001 at 4:57 pm
    Apr 10, 2001 at 9:00 pm
  • I frequently get a error 127 on merged tables. The query is a join of two merged table with each merge table have 4 base tables. If I flush tables the query works. I notice that when have about 190 ...
    DaveclarkDaveclark
    Apr 4, 2001 at 3:44 pm
    May 1, 2001 at 4:23 pm
  • Mysql : 3.23.33 server : NT 4.0 S.P.3 Client : Win98 This is the table structure: CREATE TABLE `ordinit` ( `ID_Ordine` int(11) NOT NULL auto_increment, `Cod_Cliente` int(11) default NULL, .. OMISSIS ...
    Antonino ChircoAntonino Chirco
    Apr 28, 2001 at 3:17 pm
    May 1, 2001 at 2:28 pm
  • I'm trying to install mysql onto a uniz environment. I've already unzipped and untarred, and I've created the mysql - version directory, but when I type configure, I get a grant table failed error. I ...
    Stephen HenryStephen Henry
    Apr 18, 2001 at 1:45 pm
    Apr 30, 2001 at 11:30 am
  • I am having a problem installing mysql++ on a freebsd 4.2 install.. I am wondering if there is anyone who has got it to work? thanks Kevin ps if I am in the wrong place please tell me where I should ...
    Kevin PrattKevin Pratt
    Apr 5, 2001 at 2:11 am
    Apr 29, 2001 at 2:01 pm
  • does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana mhafner@ohanalearning.org
    Matthew HafnerMatthew Hafner
    Apr 24, 2001 at 7:41 pm
    Apr 24, 2001 at 9:25 pm
  • Salut Mr/Mme, J'ai une question précise : Comment coder les caractères spéciaux (de type à, é,..) dans une BDD MySql Le problème c'est que j'ai developpé avec JSP un site en utilisant le Système ...
    Samir BaghdadiSamir Baghdadi
    Apr 21, 2001 at 9:31 pm
    Apr 23, 2001 at 7:48 pm
  • The following works ok in SQL Server, can it work in mySQL? select * from users where id in (select userid from group where name='sales') TIA, Jim Gonthier ------------------------------------------- ...
    James GonthierJames Gonthier
    Apr 13, 2001 at 1:38 am
    Apr 18, 2001 at 11:37 am
  • Uhm, did you escape embedded NULLs in the file? Did you byte compare the files you've stored and retrieved to see if they REALLY got corrupted? MySQL doesn't know a thing about files. Actually, it ...
    Alexander SkwarAlexander Skwar
    Apr 11, 2001 at 12:16 pm
    Apr 16, 2001 at 1:44 pm
  • Hi, I have one problem regarding database creation. I am using MySQL on FreeBSD unix os. I have already created two databast in mysql. Now I want to create new database for same but i forgot my root ...
    Sandeep PachpandeSandeep Pachpande
    Apr 12, 2001 at 1:14 pm
    Apr 14, 2001 at 10:33 am
  • Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of ...
    MCA Department PESITMCA Department PESIT
    Apr 9, 2001 at 5:30 am
    Apr 11, 2001 at 1:10 pm
  • I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to ...
    DavidDavid
    Apr 8, 2001 at 4:34 pm
    Apr 10, 2001 at 12:31 pm
  • Dear sir or madam MySQL user's account is not related to user's account on Linux System, so they can be different. My problem is that I use perl DBI to interact MySQL server as belows: ------ use ...
    Taing NguonTaing Nguon
    Apr 3, 2001 at 3:18 am
    Apr 4, 2001 at 4:06 pm
  • mysql INSERT INTO outages (status) VALUES ('Open'); mysql SELECT LAST_INSERT_ID() AS lid FROM outages; +-----+ +-----+ 3 rows in set (0.00 sec) Why would MYSQL do this? Any ideas? Thanks, Graeme p.s. ...
    Graeme B. DavisGraeme B. Davis
    Apr 30, 2001 at 7:09 pm
    May 4, 2001 at 6:16 am
  • Dear Friends , One of our clients wants to port the Database which was originally in MS SQL , to MY SQL . he main problem we are facing is that how to make previous stored procedures run . There are ...
    Istiaque HussainIstiaque Hussain
    Apr 24, 2001 at 2:24 pm
    Apr 25, 2001 at 2:44 am
  • I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was ...
    Bob DushokBob Dushok
    Apr 9, 2001 at 11:08 am
    Apr 23, 2001 at 3:47 pm
  • Hi, I have the following tables: Country: id | int(5) | | PRI | NULL | auto_increment | country | varchar(35) | | MUL | | | contid | int(5) City: id | int(5) | | PRI | NULL | auto_increment | city | ...
    Adrian D'CostaAdrian D'Costa
    Apr 17, 2001 at 6:10 am
    Apr 18, 2001 at 11:09 pm
  • Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had ...
    Andrei CojocaruAndrei Cojocaru
    Apr 16, 2001 at 1:40 am
    Apr 16, 2001 at 6:05 pm
  • After intsalling mysql is there a default password assigned to root? I type "./mysqladmin -u root -p password 'new-password'" Well, I don't know what the old/default password is deermind for the ...
    David LoszewskiDavid Loszewski
    Apr 14, 2001 at 5:00 am
    Apr 16, 2001 at 7:22 am
  • Attempting to delete all records in a table containing NULL values in a UNIQUE KEY field does not work as expected. Only a single record is deleted, presumably because the server thinks that the ...
    LoschertLoschert
    Apr 9, 2001 at 4:41 pm
    Apr 10, 2001 at 8:24 am
  • Okay, I'm about to rip my hair out trying to figure this out, and I thought before I start looking for a gun, maybe I should ask.. I need someone to explain the 'mysql' database to me. I've tried ...
    Ashley M. KirchnerAshley M. Kirchner
    Apr 9, 2001 at 4:36 pm
    Apr 9, 2001 at 8:13 pm
  • Hello My provider 1&1-Puretec (www.puretec.de) hosting more than 1.000.000 domains runs about 14 Databaseserver with MySQL 3.22.32-log on Linux dual Penti-III 500Mhz machines. In the last 6 month the ...
    Gunnar von BoehnGunnar von Boehn
    Apr 4, 2001 at 3:24 pm
    Apr 8, 2001 at 10:50 pm
  • Hi. Does mySQL have support for virtual domains ? And if so, how can i set it up ? (relevant documentation, ...) Kris
    Kris Van HulleKris Van Hulle
    Apr 3, 2001 at 1:52 pm
    Apr 3, 2001 at 7:32 pm
  • Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file : mysqldump --flush-logs --add-drop-table shuncheong /backup/shuncheong.sql -u root ...
    Mark Lo \(3\)Mark Lo \(3\)
    Apr 2, 2001 at 3:55 pm
    Apr 3, 2001 at 6:34 am
  • Hi, I have a problem, my database has reached Linux Redhat 7.1 max file size. (2147483647 Bytes). Does eny one know what i can do to make a lager database. (lager filesystem) Thanks Erik Dhiin
    Dhiin Data - Erik DhiinDhiin Data - Erik Dhiin
    Apr 30, 2001 at 8:13 pm
    May 5, 2001 at 10:08 am
  • I have a fairly large table (greater than 4mil rows) that I would to preform a query like: SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; I have an index on the table INDEX1( ...
    RycRyc
    Apr 30, 2001 at 9:23 pm
    May 1, 2001 at 6:32 pm
  • I can't connect to my database via mysql.... This is the load of crap I'm getting....... I would appreciate any input or feedback you have. We are on a virtual server......we set up with this company ...
    WebmasterWebmaster
    Apr 30, 2001 at 2:29 pm
    May 1, 2001 at 12:36 am
  • Is there a place to purchase the MySQL manual? I don't think my printer can handle printing that thing out. Thanks - -- Rodney D. Myers <rdmyers@koan.com Member of Digital Freedom Alliance Amateur: ...
    Rodney D. MyersRodney D. Myers
    Apr 27, 2001 at 2:34 am
    Apr 27, 2001 at 6:09 pm
  • Anybody tried this? and hopefully got some good ideas of how to do it properly? I'm trying to create a perl script that just produces a MySQL compliant SQL file based on the tables from Oracle, but I ...
    Johan AnderssonJohan Andersson
    Apr 26, 2001 at 9:24 am
    Apr 27, 2001 at 12:27 pm
Group Navigation
period‹ prev | Apr 2001 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions1,049
posts2,577
users982
websitemysql.com
irc#mysql

982 users for April 2001

Sinisa Milivojevic: 102 posts Gerald Clark: 99 posts B. van Ouwerkerk: 63 posts Steve Werby: 53 posts Jeremy Zawodny: 36 posts Thalis A. Kalfigopoulos: 31 posts Rolf Hopkins: 29 posts Heikki Tuuri: 28 posts René Tegel: 24 posts Peter Skipworth: 23 posts Aigars Grins: 22 posts Sasha Pachev: 21 posts Yusuf Incekara: 21 posts Bob Hall: 19 posts Ken Menzel: 18 posts Benjamin Pflugmann: 16 posts Braxton Robbason: 16 posts Gary Huntress: 16 posts Michael Widenius: 16 posts Paul DuBois: 16 posts
show more
Archives