MySQL with InnoDB is not reliable ? :(

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:mysql with innodb not reliable >Description: 05 09:58:46 my

how include library correctly in a visual c++ 6 project

one question how to include your library in visual c++ 6 project because y have many problem y must redefine all path for include ex #include ->> #include "..\directory\mysql++" thank you for your answer Thomas Wolff - Akosystem

BCC32 problem.................

Hi I'm using Borland BCC32 & ILINK32 command line tools for windows to compile & link the C source code which contains calls for mySQL C APIs. I've downloaded the borland libraries. The problem I'm having is unable to refer to mysqlclient.lib file from BCC32. The problem is bit confus

Re: Hopefully easy SQL question

On Thursday 15 November 2001 13:03, Christopher Oson wrote: > Good Day All, > > I have a question > > mysql> select storyID, storyCategoryID, left(title, 25) title > -> from newsStories where storyCategoryID > 0 > -> order by storyCategoryID; > +-+-+

wait or install ??

Hello, i must install MySQL on my Linux Box to end of this week. So is better install version 4.0 or wait a while for 4.1 release ?? When will be 4.1 released ??? Regeards Michal query, table, sql - Before posting, please

Re: Warning: 1 is not a valid MySQL-Link resource

Thanks, I thought I had checked through the entire php.net site...oh well, I guess not :> But how can you explain that the very same code would work before the MySQL version upgrade, and even after on one of the servers, with the same software setup? I will check out the code though :) Thank

Re: Hopefully easy SQL question

On Wed, Nov 14, 2001 at 09:03:11PM -0800, Christopher Oson wrote: > Good Day All, > > I have a question > > mysql> select storyID, storyCategoryID, left(title, 25) title > -> from newsStories where storyCategoryID > 0 > -> order by storyCategoryID; > +-+-+--

Easy SQL query??

Good Day, All, Given: mysql> select storyID, storyCategoryID, left(title, 25) title -> from newsStories where storyCategoryID > 0 -> order by storyCategoryID; +-+-+---+ | storyID | storyCategoryID | title | +-+

Re: Basic index questions

On Tue, Nov 13, 2001 at 11:03:00PM -0600, Christian Stromberger wrote: > > I understand that an index is used to "speed stuff up", but am foggy > on the details. You might find this helpful: http://www.linux-mag.com/2001-06/mysql_01.html > Eg, let's say I have an "authors" table with fname, mna

Hopefully easy SQL question

Good Day All, I have a question mysql> select storyID, storyCategoryID, left(title, 25) title -> from newsStories where storyCategoryID > 0 -> order by storyCategoryID; +-+-+---+ | storyID | storyCategoryID | title

Re: Warning: 1 is not a valid MySQL-Link resource

At 10:20 AM +1100 11/15/01, John Mravunac wrote: >Hi, > >Has anybody seen this error before? Yes, lots of people. That's why it's in the PHP FAQ. :-) Typically, it's a symptom of failing to check MySQL calls for errors. Then your script continues blytely along, unaware that there's a problem,

Re: about Mysql_affected_rows

At 1:50 AM -0200 11/15/01, M wrote: >Hello, I work PHP environment. I use to call Mysql_Affected_Rows to get >number of records retrieved by SELECT commands. >This works fine for some scripts, but now I got a script which returns >qtty records = -1, even I know these records exists. >I review Mysq

Re: about Mysql_affected_rows

Miguel, What you want is mysql_num_rows() after a SELECT call. John >Hello, I work PHP environment. I use to call Mysql_Affected_Rows to get >number of records retrieved by SELECT commands. >This works fine for some scripts, but now I got a script which returns >qtty records = -1, even I know

Re: dropping auto_increment PK/Index

Maybe you could try insert delayed - Original Message - From: "Wilfred Li, Ph.D." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 9:17 AM Subject: dropping auto_increment PK/Index > Hi, > > Is it possible to drop an auto_increment column index or primary k

about Mysql_affected_rows

Hello, I work PHP environment. I use to call Mysql_Affected_Rows to get number of records retrieved by SELECT commands. This works fine for some scripts, but now I got a script which returns qtty records = -1, even I know these records exists. I review Mysql manual and notice this function just re

Re: Mysql and Japanese Characters

On Thursday 15 November 2001 06:30, Walter D. Funk wrote: > Hi everybody, > > I need some help !!! > does anyone now how to store "japanese" content into mysql ??? > I found out that using a VARCHAR field set to binary does seem to > work; but how can I manage larger amounts of text, since TEXT da

Problems with static binary of mysqlgui 1.6 for Solaris 7

I've downloaded the static binary mysqlgui-solaris-2.7-sparc-static-1.6. Although this appears to be a gzip file, it did not have a .gz extention. It also seems to be only a single file. I gunzipped the file and tried to execute it on Solaris 7. The result is: ./mysqlgui-solaris-2.7-sparc-static-

Re: Mysql and Japanese Characters - A Followup Question

Very sorry that I don't have an answer, only a followup question related to character sets I'm a sheltered American, unfamiliar with anything beyond the default ISO-8859-1. However, I run FreeSQL.org and I'm absolutely amazed at the international usage I receive. This has caused me a fair amou

users@localhost problems

I'm sure this question has been answered a million times, so please pardon it again. If there's an appropriate FAQ, please point me to it. My problem is fairly simple: I've set up a couple of users of the form username@localhost. When I run a 'SELECT * FROM USER;' in mysql, they show up, with

mysql_install_db empty

Hello, I downloaded mysql-3.23.39-pc-solaris2.8-i386 version of mysql. It seems that mysql_install_db file is empty( has 0 byte). Where can I get the mysql_install_db file? Philip M. Tan e21corp 41900 Christy St Fremont, CA 94538 (510)226-6780 x219 --

RE: Idea about extending Limit/mysql query

I wrote: > # create test tables > create table msg_main (mid int not null,name char(16),primary key(mid)); > create table msg_lang (mid int not null,lang char(2) not null,message > text,primary key(mid,lang)); mid is a bad choice for column names, because it is a function... it is however not an

Re: Bug Report - SELECT Does Not Recognize Column Alias

Hi Rick, - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> > Description: > The SELECT statement fails to recognize that an alias (mycol) was set for a > column. Note the column name is created from a table alias (c1) > > mysql> select c1.id as mycol from colors c1 right join

Re: Need A book for dynamic website

The books I got started with are: Essential PHP for web professionals by Cosentino (Prentice Hall) MySQL/PHP Database Applications by Greenspan & Bulgar (M&T) -- Chip On Wednesday 14 November 2001 07:37, Webmaster wrote: > Hi, > I need a book to teach me how to make a database driven website, I

RE: Idea about extending Limit/mysql query

* DL Neil [About Christian's problem with joining language specific info.] > MIN( FIELD( language, 'no', 'en', 'fr', 'sv' ) ) > Hi, I have a similar problem, and have found a workaround that may be useful for you, Christian. Use an extra left join to find the records you don't want... # cr

Re: Lock Table for new index?

On Tue, Nov 13, 2001 at 10:28:53PM -0700, Karl J. Stubsjoen wrote: > Hello, > > I have a fairly active and large DB. I need to create a new index > on a column. It will take (just guessing) 15-30 minutes for the > entire creation. I've got different people hittiing this table all > the time, m

Re: Need A book for dynamic website

Hi David, I was the technical editor for _PHP4 A Beginner's Guide_ by McGraw-Hill, which covers PHP4/MySQL and written by William McCarty a professor of IT at Azusa Pacific University. He is also a contributing editor for Linux Magazine. This book is completely aimed at the beginner, and

Re: mysqld shutdown

Dan, Thanks for that comprehensive answer. It doesn't seem like the FreeBSD solution will be one that I will try to implement into my installation of Darwin, as it draws on skills and knowledge that I definitely don't have -- though it would be educational to take a look into Darwin's threading

Warning: 1 is not a valid MySQL-Link resource

Hi, Has anybody seen this error before? Everything was working great on my web server until one day I upgraded MySQL from version 3.22.32 to 3.23.42. Initially I had Apache 1.3.12 working with PHP 4.0.1p12 and MySQL 3.22.32 along with a Mod_Auth_MySQL version 2.2 module. Then when I upgraded

Re: mysqld shutdown

In the last episode (Nov 14), Erik Price said: > > What OS do you use ? > > > > The behaviour you're describing I've seen two-three years ago on > > FreeBSD due to some bug/deficiency in FreeBSD threads. Since then > > it was fixed (in FreeBSD I mean). > > Interesting! I'm using Darwin 1.3.1 (f

dropping auto_increment PK/Index

Hi, Is it possible to drop an auto_increment column index or primary key to boost performance for bulk inserts? It seems mysql requires auto_increment columns to be a key at all times. Here is the error message: Incorrect table definition; There can only be one auto column and it must be define

Re: Text qualifiers

Won Lee wrote: > Perhaps... > > I may be missing something here. > Because I have about 15 seperate Access DBs on my workstation and don't want > to create 15 system ODBC connections for once in a life import, I thought > doing it via a text file would be easier. > > Unless you are talking about

RE: Text qualifiers

Look at MYSQL manual, sect. 6.4.9 LOAD DATA INFILE Syntax That explains how to work around your problems. -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:30 PM To: mysqlList Subject: Text qualifiers Hi everyone... Long time listener, fi

RE: Text qualifiers

LOAD DATA LOCAL INFILE 'C:/Documents and Settings/won/My Documents/summary.txt' INTO TABLE spacedx.summary FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (groupID,structural,mechanical,electrical,safety,vertical,misc)\ I'll save the trouble of cutting and pasting th

Bug Report - SELECT Does Not Recognize Column Alias

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 3:34 PM To: [EMAIL PROTECTED] Subject: ezmlm response Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. This is a generic help message. The message I re

Re: Text qualifiers

Won Lee wrote: > I have an slew of Access DBs that I need to port some of the info into a > MySQL DB. > I guess my main problem is my I have no idea in what format to export my > data from the Access DB. > In general I export it as a tab delimited file with no text qualifiers. > Unfortunately, mu

Re: Non-Buffered mysqld

Jeremy Zawodny wrote: > On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote: > > The most important exception is the mysql_use_result attribute: This > > forces the driver to use mysql_use_result rather than > > mysql_store_result. The former is faster and less memory consuming, > > but te

Mysql and Japanese Characters

Hi everybody, I need some help !!! does anyone now how to store "japanese" content into mysql ??? I found out that using a VARCHAR field set to binary does seem to work; but how can I manage larger amounts of text, since TEXT data type does not support binary encoding? lease ... or i´ll do h

Re: Need A book for dynamic website

On Wed, Nov 14, 2001 at 03:37:53PM -, Webmaster wrote: > > Hi, > I need a book to teach me how to make a database driven website, I think php > mySql is the way to go and have seen some on amazon and fat brain but don't > know if any are any good, any ideas? "Philip and Alex's Guide to Web P

Re: Non-Buffered mysqld

On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote: > Man I just cannot stop replying to myself... I've had days like that, too. > > The most important exception is the mysql_use_result attribute: This > forces the driver to use mysql_use_result rather than > mysql_store_result. The form

Fw: Idea about extending Limit/mysql query

Robot rubbish: MIN, FIELD, MySQL, SQL > Christian, > > ... > > > Another way to solve my problem would be if there was some sort of > > > FIRST_IN_SET functionallity that I could use on the where clause > > > select * from articles where language = FIRST_IN_SET('en,sv,no') > > =I "languag

Text qualifiers

>I tried to wrap the text in double quotes to tell it not to terminate the line. However, my imports have still failed. This could be due to my lack of experience or wrong syntax. But I did everything as told in the documntations. What parameters are you using for your import? If you give us a

Text qualifiers

Hi everyone... Long time listener, first time caller. Actually I'm a first time everything. Be gentle. I have an slew of Access DBs that I need to port some of the info into a MySQL DB. I guess my main problem is my I have no idea in what format to export my data from the Access DB. In general

Re: mysqld shutdown

If I remember correctly, on SCO I did a mysqladmin shutdown | mysqladmin This produced an error message, but also unblocked the shutdown. Erik Price wrote: > --- Sergei Golubchik <[EMAIL PROTECTED]> wrote: > >> What OS do you use ? >> >> The behaviour you're describing I've seen two-three ye

Re: Newbie: Can't get GRANT to work

Yes, I've read this a number of times too. I've also read the section that says "If you use GRANT, you don't need to use FLUSH PRIVILEGES." The way that I read this is that GRANT is the "automatic" method, not requiring FLUSH PRIVILEGES, whereas modifying the tables directly, using INSERT, UPDA

Re: Timestamp allways zero zero

See below. On Wed, 2001-11-14 at 14:40, Jason Wong wrote: > The above can be re-written as: > > //En record for hvert navnedomene > $sql = "CREATE TABLE domains ( > dNbr INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, > dName CHAR(25) NOT NULL, > payP

Re: Timestamp allways zero zero

The whole point of a time stamp is that you do NOT insert its value. Leave it out. Olav Drageset wrote: > Professionals! > I cannot get timestamp to contain a time value different from zero. > According to another mailing this shall happen when something is done wrong > I am completely new to da

Re: Non-Buffered mysqld

Man I just cannot stop replying to myself... Bill Adams wrote: > Bill Adams wrote: > > > Rick Emery wrote: > > > > > If you use PHP, the answer is:mysql_unbuffered_query() > > > > Well, I get the delay if I query with perl DBI or enter the query directly in > > the mysql client. perl DBI

Re: Newbie: Can't get GRANT to work

KEVIN ZEMBOWER writes: > mysql> grant all on zope.* to zope identified by "xxx"; > Query OK, 0 rows affected (0.00 sec) > > mysql> select * from user where user="zope"; > | %| zope | 34577362486f3680 | N | N | N | N >| N | N | N

Re: Newbie: Can't get GRANT to work

http://www.mysql.com/doc/P/r/Privilege_changes.html "If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. Otherwise your changes

RE: Joins with priority

* Roger Baklund > >I have two tables, and I want to join them based on some priority rules: > * Christopher Book > If you use UNIONS (in MySQL 4.0) then you can simply union your different > cases together. Thanks, but I need a solution for version 3.23.39. Roger Baklund, Mobiliant AS

Re: Non-Buffered mysqld

Bill Adams wrote: > Rick Emery wrote: > > > If you use PHP, the answer is:mysql_unbuffered_query() > > Well, I get the delay if I query with perl DBI or enter the query directly in > the mysql client. perl DBI + Informix does not buffer so I know that it is > not that combo. (I guess it cou

Re: Timestamp allways zero zero

Olav Drageset writes: > I cannot get timestamp to contain a time value different from zero. > $tid = "NOW(YY-MM-DD HH:MM:SS)"; > $sql .= "VALUES ('$domainName', '$payPerYear', '$nxtPayDay', '$tid', You're trying to INSERT the string constant 'NOW(YY-MM-DD HH:MM:SS)' which will be converted int

Re: Timestamp allways zero zero

On Thursday 15 November 2001 01:38, Olav Drageset wrote: > Professionals! > I cannot get timestamp to contain a time value different from zero. > According to another mailing this shall happen when something is done > wrong I am completely new to databases. I am initiating the database > tables f

Re: mysqld shutdown

--- Sergei Golubchik <[EMAIL PROTECTED]> wrote: > What OS do you use ? > > The behaviour you're describing I've seen two-three years ago on > FreeBSD > due to some bug/deficiency in FreeBSD threads. > Since then it was fixed (in FreeBSD I mean). > > Regards, > Sergei Interesting! I'm using D

Re: mysqld shutdown

On Wed, 14 Nov 2001 08:38:04 -0800, Bill Adams <[EMAIL PROTECTED]> wrote: >>> /usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown >>> >>> But this one doesn't work for me, even though I am using the proper >>> password and am the proper user. Executing this command just leaves me >>> ha

Re: Non-Buffered mysqld

Rick Emery wrote: > If you use PHP, the answer is:mysql_unbuffered_query() Well, I get the delay if I query with perl DBI or enter the query directly in the mysql client. perl DBI + Informix does not buffer so I know that it is not that combo. (I guess it could be the DBD::mysql.) While t

memory issues for large table query

>>>When I run a query "SELECT count(*) as count FROM tbl where col_1 like 'value1'", the query can take up to 45 minutes to bring back a result if there are >>>large number (sometimes 1 million plus) of records that match 'value 1'. Use EXPLAIN to make sure that you're using an index that you h

RE: Timestamp always zero

Are you really using "NOW(YY-MM-DD HH:MM:SS)"? I mean...that exact text? That would be your problem, mate. use: $sql = "INSERT INTO domains ( dName, payPrYr, nextPayDay,timeChanged, imeCreated ) ". "VALUES ('$domainName', '$payPerYear', '$nxtPayDay', NOW(), NOW()"; and DO NOT end your query tex

RE: Non-Buffered mysqld

If you use PHP, the answer is:mysql_unbuffered_query() -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 11:38 AM To: Mysql List Subject: Non-Buffered mysqld MySQL 4.0 Is there a way to prevent mysql(d) from buffering the output ala '

Re: myisamchk -a + indexes + hidden...?

Jon Gardiner wrote: > Analyzing a table requires looking at every > record in the table. If the > table you are dealing with is a large one then > there is a good chance that > after analyzing the table your disk cache will > not contain the records that > you are trying to grab. Once you run

memory issues for large table query

I'm trying to get a handle on how an increase inf physical memory will affect the query time for a large table. Here's the set up. I'm running MySQL 3.23.37 on RedHat 6.0. The server has a 700Mhz process with 1.5 Gig of RAM. I'm querying a table with 47 million plus records that has 3 columns (

RE: INSERT with SELECT on same table

If one of the table's fields is defined as UNIQUE or PRIMARY KEY, it will allow the insertion only once with that key. When a second attempt is made to insert the record with the same key, the insertion will be ignored and you may ignore the error code that results. Would that work for you? ---

Newbie: Can't get GRANT to work

I'm certain I'm making a simple mistake here, but can't find it. Here's what I'm executing, using mysql 3.23.43-log: [I'm root when I run this] #mysql -p mysql mysql> grant all on zope.* to zope identified by "xxx"; Query OK, 0 rows affected (0.00 sec) mysql> select * from user where user="

Re: foxpro conversion

On Wed, 14 Nov 2001 [EMAIL PROTECTED] wrote: > Anybody have any tools/tips for converting a foxpro database to mysql Hi; Take a look at mysql's page (contrib zone) or freshmeat... There's a "dbf2mysql" app somewhere (but I don't remember the URL) that works quite nice... Salud

Error

I am building mysql 3.22.26a with gnu cc 2.95.3 and gnu make under solaris 8 and get the following error. How do I fix this ? # make make all-recursive make[1]: Entering directory `/opt/ftp/mysql-3.22.26a' Making all in Docs make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/Docs' make[2]: N

Re: mysqld shutdown

Hi! On Nov 14, Bill Adams wrote: > > > > PS: If I run the mysqladmin shutdown command, then check "top" in > > another console, both the daemon and the mysqladmin command continue to > > run indefinitely -- and I have waited an hour to see if it's just slow. > > That doesn't seem to be the case

Re: Alphabetizing book titles

Christian Stromberger wrote: > Is there any way to build an index like this (to ignore A, An, The) for > faster title sorts? Any helpful advice for a newbie appreciated! Not really. You could create a new column that has the sort name and put an index on that. But really, if you are going to

Re: mysqld shutdown

--- "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> wrote: > Have you tried ./mysqladmin -u root -p shutdown > > when in the 'bin' folder otherwise typing mysqladmin, it will check > the server > PATH, to find the mysqladmin > > > Mike(mickalo)Blezien Hmm... isn't this the same thing as /usr/local/

Re: mac

MWP writes: > DO you have a MySQL download that works for Mac OS 9 or above, but below > OS X? I don't see it. > And you will not. Pre OS X systems did not have many things, including threads that could make MySQL running possible. There is in our manual a link to a site making MySQL clients fo

Timestamp allways zero zero

Professionals! I cannot get timestamp to contain a time value different from zero. According to another mailing this shall happen when something is done wrong I am completely new to databases. I am initiating the database tables from a php page. Can anyone tel me what I am doing wrong?? Thank you

Non-Buffered mysqld

MySQL 4.0 Is there a way to prevent mysql(d) from buffering the output ala 'mysqldump -q'? The specific case I am thinking of is a simple SELECT ... FROM ... WHERE (with no ORDER BY, no GROUP BY, etc.). In this case there is no reason [that I can think of] why mysqld cannot start returning reco

Re: Need A book for dynamic website

Todd Are you familiar with either of the books I recommended? Each of them does a fine job explaining (1) how to use PHP -- as a beginner (2) how to use MySQL -- as a beginner. The language is simple. If you've never come across a for{} loop, it explains it clearly. If you've never seen an R

Re: Need A book for dynamic website

Sorry, I can't help with PHP books, however for Perl books, "MySQL and Perl for the Web" by Paul Dubois is good. > I need a book to teach me how to make a database driven website, I think > php mySql is the way to go and have seen some on amazon and fat brain > but don't know if any are any good

Re: TCP_NODELAY: what systems?

Andrew Schmidt writes: > Hi guys, > > In the latest MySQL release (3.23.44) it was noted: > > o TCP_NODELAY was not used on some systems > > Which systems would this affect? and is this client side or server side? > > thanks, > > -- Andrew > SCO Unix. Both sides. -- Regards, __ ___

RE: Need A book for dynamic website

try http://www.devshed.com/Server_Side/PHP/DB_Basics/page1.html why use php only try out http://www.zope.org and http://www.python.org. MySQL interfaces with all of these, pretty well. hth & good luck Norman -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Wednesday

mysql4 Duplicate entry

I have just upgraded my test server to MySQL 4.0.0 from MySQL 3.23.44 There is a 2Gb table with 2286869 records which I can query fine on MySQL 3.23.44, but when I change over to MySQL 4 if I try and INSERT or REPLACE any records it keeps saying 'Duplicate entry' and when I do an UPDATE, it corrup

RE: Need A book for dynamic website

Brian... You can SLAM yourself into a wall of confusion if you do not pick the right books that doesn't explain things to you like a two year old. I like books that explain things that way when I learn a new technology. It keeps the frustration away Thank you, Todd Williamsen, MCSE home: 847.

Re: Need A book for dynamic website

My experience with DuBois's book is that it's GREAT for MySQL, especially when you want to interface with MySQL at the server level -- with C or C++ for example. But for PHP/MySQL or using MySQL at any level of web interfacing, this book just doesn't do it. Erik Price wrote: > When I was just s

Re: mysqld shutdown

--- Bill Adams <[EMAIL PROTECTED]> wrote: > This seems like an OS bug to me. All of the things you mention in > your last > email should stop mysql from running. > > What happens if you do (where safe_mysqld is running) 'fg' and > then CTRL+c? Does that just hang too? > > Do you need the debug

INSERT with SELECT on same table

Hi there, I am currently facing the following problem and hope someone can help me. I want to make an INSERT into a Table only if I haven't done this before. This is because the INSERT can be done by several Programs and the record should only be inserted once. I have found the following soluti

Re: mysqld shutdown

> > PS: If I run the mysqladmin shutdown command, then check "top" in > another console, both the daemon and the mysqladmin command continue to > run indefinitely -- and I have waited an hour to see if it's just slow. > That doesn't seem to be the case. > This seems like an OS bug to me. All o

ANN: EMS MySQL Manager 1.2 released

Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.2) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.2?

Re: mysqld shutdown

--- Bill Adams <[EMAIL PROTECTED]> wrote: > > One option is to use > > > > /usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown > > > > But this one doesn't work for me, even though I am using the proper > > password and am the proper user. Executing this command just > leaves me > > hangi

RE: Need A book for dynamic website

I bought "PHP: Fast and Easy Web Development." Its pretty through and nice walk-throughs for a beginner. You may end up buying several books... This book helps you get your feet wet with PHP and MySQL, but it is no reference on everything. Thank you, Todd Williamsen, MCSE home: 847.265.469

mac

DO you have a MySQL download that works for Mac OS 9 or above, but below OS X? I don't see it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: Performance problems

At 3:54 PM + 11/14/01, M. A. Alves wrote: >On Wed, 14 Nov 2001, Aaron Williams wrote: >> . . . >> I am not expert on innodb, or mysql either. I started playing with >> those values after reading the performance guide on Innodb.com. > >What is this site (Innodb.com)? It seems to show some k

Re: mysqld shutdown

Erik Price wrote: > All, > > Well, I solved the mystery of the missing Unix socket. It needs to be > defined at the time the daemon is started with: > --socket=/path/to/socket. Well, at least in my installation it does. > > But now I'm having the OPPOSITE problem -- shutting down the server >

Re: Need A book for dynamic website

"PHP and MySQL Web Development" by Luke Welling and Laura Thomson (Sams Publishing, Copyright 2001) is the best book on the market I think. But it depends on your skill level. This book has a section on basic PHP language, another section on setting up MySQL databases, and a third section with pra

Re: Need A book for dynamic website

When I was just starting to consider my database-driven web site, I checked mysql.com and found this: http://www.mysql.com/portal/books/html/index.html The best-rated book is the one I chose to get: MySQL by Paul DuBois New Riders I think it's awesome. (Although neither it nor the web site do

RE: what wrong with my database? or mysqlcheck? myisamchk?

You should run myisamchk on *.MYI not *.MYD. Jon Gardiner. > -Original Message- > From: sj [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 9:25 PM > To: [EMAIL PROTECTED] > Subject: what wrong with my database? or mysqlcheck? myisamchk? > > > My mysql is 3.23.42 > > I us

RE: Consequtive, Sequential auto-increment?

You typically wouldn't want to renumber a key field, as that would break any relations you have with other tables, unless you renumber all of those as well. As MySQL doesn't expressly support foreign keys, and has no idea about the relations between your tables, there is no way for MySQL to renu

Re: Need A book for dynamic website

I myself like the following PHP4 Bible Sams Teach yourself MySql in 21 days "Webmaster" <[EMAIL PROTECTED]> on 11/14/2001 10:37:53 AM To: [EMAIL PROTECTED] cc:(bcc: Lad Gaal/MarconiMedical) Subject: Need A book for dynamic website Hi, I need a book to teach me how to make a data

TCP_NODELAY: what systems?

Hi guys, In the latest MySQL release (3.23.44) it was noted: o TCP_NODELAY was not used on some systems Which systems would this affect? and is this client side or server side? thanks, -- Andrew - Before posting, please

RE: Need A book for dynamic website

I found this one was pretty good when I fancied learning PHP... http://www.wrox.com/Books/Book_Details.asp?ISBN=1861003730 Beginning PHP4 What does this book cover? Complete tutorial in the PHP language Installation guide and troubleshooting tips Introduction to relational databases and MyS

RE: Re: Default forced on MySQL

I guess you'll have to wait till its implemented its on the TODO >Is that too much to ask? database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: Performance problems

On Wed, 14 Nov 2001, Aaron Williams wrote: > . . . > I am not expert on innodb, or mysql either. I started playing with > those values after reading the performance guide on Innodb.com. What is this site (Innodb.com)? It seems to show some kind of report on some system associated with the HTTP r

Joins with priority

If you use UNIONS (in MySQL 4.0) then you can simply union your different cases together. Chris >I have two tables, and I want to join them based on some priority rules: - Before posting, please check: http://www.mysql.com

Re: foxpro conversion

El Miércoles 14 Noviembre 2001 09:00, escribiste: > Anybody have any tools/tips for converting a foxpro database to > mysql > > ___ > Sean O'Donnell Try dbf2mysql. It works for me. -- Alfredo J. Cole Tegucigalpa, D. C., Honduras http://www.acyc.com (Accounting Systems)

RE: nonstandard meaning of "KEY" in MySQL?

I don't think that's entirely true. MSAccess doesn't refer to indexes, only keys... and keys in access can be unique or non-unique based on your key properties. This is identical to how MySQL treats the terms. Chris >What are the *standard* meanings of these terms? The usage in the textbook ma

RE: Consequtive, Sequential auto-increment?

This topic was discussed about two weeks ago. The over-riding question was: Why does it matter that the numbers are consecutive? Sir, I pose that question to you. -Original Message- From: Bryan Capitano [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 14, 2001 9:21 AM To: mysql Subject:

  1   2   >