Re: MySQL and kernel upgrade
Sommai Fongnamthip writes: > Hi, > I was read recommendation from MySQL download page to upgrade Linux Kernel > for latest MySQL version. I have problem because I must still with Linux > Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat > has many task to upgrade in newer kernel. What will effect my system if I > install latest MySQL with current kernel? Sommai, Linux kernel 2.2.16 should be ok. The problem is specifically with an I/O bug in kernel 2.2.14. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT ... INTO
I have been assigned the fun little job of porting a (very badly designed) database from Access97 to MySQL so that we'd finally get rid of that pesky Win2000-server. The database contains a list of magazines currently in our basement waiting for someone to borrow them. There are, at the moment, just over 4500 records in the database, but when someone starts inserting magazines, it'll be a tad over 100 000 records. Now, the problem is that I'd somehow like to get all the magazine names into another table, and references to that table in the first table without having to change all the records by hand. I have gotten the names of the magazines into a table with an auto_incremented primary id field, but how could I get all the same names away from both tables and only leave unique names? -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Regional Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't save queries to file
This just happened to me tonight. I am running Windows98, Apache, MySQL 3.23.38. Running mysql as a CLI I was always able to \T to a file. Now whenever I try that, I get an error message that MySQL has performed an illegal operation. I have to shut it down. I've rebooted, and restarted Apache and MySQL servers and it still breaks every time I try to save query output to a file. Anyone have any ideas why? -- Amer Neely [EMAIL PROTECTED] Softouch Information Services: www.softouch.on.ca/ Perl / PHP / CGI programming for shopping carts, data entry forms. "We make web sites work!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and kernel upgrade
On Tue, 18 Dec 2001 09:53:32 +0700, Sommai Fongnamthip used a few recycled electrons to form: | Hi, | I was read recommendation from MySQL download page to upgrade Linux Kernel | for latest MySQL version. I have problem because I must still with Linux | Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat | has many task to upgrade in newer kernel. What will effect my system if I | install latest MySQL with current kernel? You should be able to upgrade the kernel to the 2.4 series without any problem. We have many production boxes with RH 6.2 and the 2.4 kernel on them. Mysql runs much better with the 2.4 kernel, esp on a multi proc box. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB still gives poor analysis to the optimizer
Is there any upcoming fix for this recurring problem? The table handler is just giving poor data to the optimizer and the optimizer is making bad decisions because of it. It appears to come and go, depending on data that is in the table, what's been done, etc. To give one example, with one of our queries that does a good deal of joining (roughly 10 tables), an optimized version needs to sift through approximately 6500 rows. The unoptimized version needs to sift through 8600 rows, a 32% increase that results (in our case) to a 20% increase in CPU usage on a dual CPU system. Right now, the tables are small, but we want them to get bigger, and the unoptimized version scales *much* worse than the optimized version. Furthermore, I thought sticking more data into the tables might eliminate the problem as the two plans data dispersals grew further apart, but it looks like that isn't the case. Sometimes, converting the tables to MyISAM (where the optimization *always* works) and then back to InnoDB fixes it, but obviously, that's not something you want to do on a running system. Is there any headway being made into this problem? I think I first reported it back around .41 or .42. This isn't really something a bug report can be filed on, because it seems to be the result of a varying data group and InnoDB's corresponding analysis, but if there's some bit of data that will help short of the data in my database, I'll gladly pass it on. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and kernel upgrade
Hi, I was read recommendation from MySQL download page to upgrade Linux Kernel for latest MySQL version. I have problem because I must still with Linux Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat has many task to upgrade in newer kernel. What will effect my system if I install latest MySQL with current kernel? SF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hate to do it, but TEST
Disregard please... database,sql,query,table -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: Returning html code-PROB SOLVED
Dumb question, but why is that? I have stripslashes on everything that goes into the database, (i also addslashes on everything, so people can't break the database, too), why is it unecessary? and what might it break? Thanks, James Cox - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(WOT) Re: "SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE"
A better question is why hasn't this host `From:' been banned yet? This is the second time in a month that this guy has spammed the lists with his garbage. Shankar Unni wrote: > > rc wrote: > > > anyone know why i'm getting these spam emails over this list > > Because it had the magic word "sql", which the filter checks.. > -- > Shankar. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Returning html code-PROB SOLVED
except there's no need to stripslashes(), in fact it could even break things..
unless you have magic_quotes_runtime enabled (default is off in the latest php)
bvr.
On Mon, 17 Dec 2001 16:33:24 -0700, Kevin Stone wrote:
>Ahh.. I was about to reply but nevermind. The two functions you're talking
>about are addslashes() and stripslashes(). Yes those are very handy. :)
>
>>
>>
>> > Does anyone know of an easy way to store html code in a mysql database,
>> and
>> > then retreive it, in such a way that it can display the page as if it
>were
>> a
>> > standard html page? Would using php be of benefit to me?
>>
>>
>> Figured it out. I completely forgot about two php functions that escape
>> problem characters in databases and unescape them when retrieved.
>>
>> Problem solved.
>>
>> Steve Osborne
>> [EMAIL PROTECTED]
>>
>> > /* Happy Holidays */
>> mysql_select_db('North_Pole');
>> mysql_query('SELECT reindeer FROM stable WHERE nose_color="red"');
>> ?>
>>
>>
>>
>>
>>
>>
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Returning html code-PROB SOLVED
Ahh.. I was about to reply but nevermind. The two functions you're talking
about are addslashes() and stripslashes(). Yes those are very handy. :)
>
>
> > Does anyone know of an easy way to store html code in a mysql database,
> and
> > then retreive it, in such a way that it can display the page as if it
were
> a
> > standard html page? Would using php be of benefit to me?
>
>
> Figured it out. I completely forgot about two php functions that escape
> problem characters in databases and unescape them when retrieved.
>
> Problem solved.
>
> Steve Osborne
> [EMAIL PROTECTED]
>
> /* Happy Holidays */
> mysql_select_db('North_Pole');
> mysql_query('SELECT reindeer FROM stable WHERE nose_color="red"');
> ?>
>
>
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
> > > > Does anyone know why it is that the MyODBC authors prefer not to allow > > that to be distributed in the unixODBC package, or with distros (eg the > > SuSE CDs don't contain it)? > > Peter will answer this, why MyODBC is not included in > unixODBC distribution :) > > Peter, any comments .. ? > > > Is it a licensing issue, something to do with the ODBC spec, or just > > plain "don't want to do that, so there" (which, I hasten to add, is > > perfectly acceptable)? > > No such, as long as it is GPL distribution. > I had it in unixODBC originally but I gather someone asked Nick to remove it. Mind you; I just built the OSX version of MyODBC by copying all the MyODBC source (just *.h and *.c) into the unixODBC source tree. However; I only checked the make (actually qmake project file) into unixODBC cvs. It was really important, when unixODBC first started, to have some drivers in the unixODBC source tree but it less important now. What is REALLY important is to encourage Linux, UNIX, and OSX people to put unixODBC itself into O/S distros as a standard thing. Then allow drivers to be added with the assumption that the O/S has some form of ODBC sub-system. It's not as of there is some kind of overhead of having it on a system and not being used (no processes and < 1 meg on disk for the core stuff). The upside is significant. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Returning html code-PROB SOLVED
> Does anyone know of an easy way to store html code in a mysql database, and > then retreive it, in such a way that it can display the page as if it were a > standard html page? Would using php be of benefit to me? Figured it out. I completely forgot about two php functions that escape problem characters in databases and unescape them when retrieved. Problem solved. Steve Osborne [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Returning html code
> Does anyone know of an easy way to store html code in a mysql > database, and then retreive it, in such a way that it can > display the page as if it were a standard html page? You store and retrieve html in a mysql database like you store/retrieve any other string values. You would probably want a TEXT (max 64K)or MEDIUMTEXT (max 16M) type field to store it. You would also need to escape some characters before you store the page in the database: ", ' and \ are common problems. You do not say if this is entire pages or fragments of pages. If it is entire pages, your program must output http headers, a blank line, and then the page from the database. If it is fragments, you can just output the html content on your result page like you do for any other scripts reading from mysql. > Would using php be of benefit to me? Possibly... you can't get data from mysql and output it to a webpage without some kind of scripting/programming language... and most languages may be used. Do you use a different language today? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui, ?var? and quotes
Sinisa Milivojevic wrote:
>Jean.Maupertuis writes:
>
>>I try to use the ?var?'s to create a menu for inserting new rows in a table.
>>for example:
>>insert into personnel(first_name, last_name) values(?first_name?,
>>?last_name?)
>>if i type jean in first_name and maupertuis in last_name the result is
>>"unknow column
>>'jean' in 'field list' "because it's translated
>>insert into personnel(first_name, last_name) values (jean,maupertuis)
>>to correct i have to type 'jean' and 'maupertuis' this is tranlated
>>insert into personnel(first_name, last_name) values('jean','maupertuis')
>>which is the correct form.
>>
>>We can test this with a little sql:
>>select ucase(?test?)
>>
>>I try different things to solve : concat, '?var?', ... but i don't find
>>a way to bypass.
>>
>>Have anyone a better solution?
>>
>
>
>Just use quotes when inserting values.
>
>I could (when I find time), do it automatically if column is
>char/varchar/text/blob ...
>
>Would that solve your problem ??
>
>
Yes , it solves but it's not friendly to tell a user to insert quotes.
So, i totally agrre with your proposal to do it automatically (when you
have time).
Please put a message on the list when you have done.
Thanks
Jean
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE" (fwd)
rc wrote: > anyone know why i'm getting these spam emails over this list Because it had the magic word "sql", which the filter checks.. -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Returning html code
iv'e done it before. store the html as a varchar,text field in database. using php would help if only certain sections are stored as html. Good Luck, Rick -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 3:38 PM To: MySQL (E-mail) Subject: Returning html code Does anyone know of an easy way to store html code in a mysql database, and then retreive it, in such a way that it can display the page as if it were a standard html page? Would using php be of benefit to me? Steve Osborne [EMAIL PROTECTED] * *(borrowed from Paul) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE" (fwd)
anyone know why i'm getting these spam emails over this list -- Forwarded message -- Date: Mon, 17 Dec 2001 17:36:59 -0500 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: "SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE" From:- Gani Pola SP* PCI Data Consulting Marketing Division 434 Ridgedale Avenue, PMB # 11-108 East Hanover NJ 07936 Tel: 1-888-248-3443 OR 1-888-713-7201 Fax:1-603-297-5644 mailto:[EMAIL PROTECTED] Attention: Recruiting Department / Human Resources Department ==+=+== Please find our software consultant's brief information listed are available for contract or contract to hire positions. We have consultants available with skills- *- QA Testers with - QA Center Test Pack: QA Run, QA Director and QA Track - Mercury Winrunner, Testdirector, Loadrunner,Windows, Unix, Oracle - Seague Silk, Silk Pilot, Silk Performer, Windows, Unix,Oracle, SQL Server - Rational SQA Suite, Windows, Unix, Oracle - Main Frames tester with Winrunner,Testdirector * Telecom Embedded software developers using 'C',Assembly and on VxWorks & pSOS OS platform, Sonet, SNMP, Device Drivers * Auto CAD Developer - AutoCAD 11,14, 2000, CAM, Fabricam, Camstore, FC2001, Windows 95, 98NT. * Main Frames Developers with Cobol II, JCL, CICS, DB2, MVS, IMS, TSO, ISPFs * Oracle Developers with Developer / 2000 * Oracle DBAs * Microsoft certified windows 2000 Admins * Java Developers with EJB, Weblogic, Websphere, Swings, Servellets, JSP, XML, Unix and Windows * VB Developers with Crystal Reports, Oracle, MS Access and SQL Server * VB, ASP, SQL Server, COM/DCOM web developer * Visual FoxPro Developers with SQL Server, Windows * Certified Lotus Notes/Domino developer with R5.0 * System Admins-SUN CERTIFIED SENIOR UNIX ADMIN WITH VERITAS. All of them will relocate and our rates are including relocation. All of them are on H1-B visa status and available for Contract or Contract to Hire and some of them are immediate hire positions which requires H-1B visa transfer For detailed resumes,rates and contact information, Please send us an e-mail mailto:[EMAIL PROTECTED] ** *** To receive our Hotlist of available software testers-consultants please send a balnk e-mail mailto:[EMAIL PROTECTED] ** -- -- REMOVAL INSTRUCTIONS (REQUEST) T O T H E R E C I P I E N T -- -- ** ** If you have received this message in error,we apologize for any inconvenience. To ensure that you do not receive further email from us and wish to be removed from our list,please send us an e-mail, mailto:[EMAIL PROTECTED]?[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: cannot figure out how to parse SELECT query into pages
If you want to use PHP, here's a nifty utility that posts your query and displays the results. "Give me back my MySQL Command Line!" http://www.webmasterbase.com/article.php/627 Doug On Mon, 17 Dec 2001 14:27:11 -0800 (PST), John Kurkiewicz Jr. wrote: >I cannot figure out how to parse SELECT query into >html pages. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: cannot figure out how to parse SELECT query into pages
* John Kurkiewicz Jr. > I cannot figure out how to parse SELECT query into > html pages. Please be more specific. If you want to display a select statement on a web page, you need to transform "<" into "<", and you should probably put it inside a html element. If you want to display the result of a select query on a html page, you probably want to use an html table. You must construct the table (and other html elements) from your script/program. The result of the query must be written in the cells of the table. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Returning html code
Does anyone know of an easy way to store html code in a mysql database, and then retreive it, in such a way that it can display the page as if it were a standard html page? Would using php be of benefit to me? Steve Osborne [EMAIL PROTECTED] * *(borrowed from Paul) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Search & Replace
What is the best way to do a search & replace on a MySQL database? I just want to wipe a particular character from each field it occurs in; the REPLACE command, at least in the documentation on www.mysql.com, doesn't appear to be the best bet for doing this. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connecting
I am very green when it comes to MySQL and i am having some problems connecting via a web interface. I keep getting. -snip- Warning: MySQL Connection Failed: Host '' is not allowed to connect to this MySQL server in /home/sites/site105/web/forums/install.php on line 39 -snip- I am not sure if my usernames and passwords have been set up properly or not, any help would be great. Cheers, Nathan Kondra Production Manager Think Profits.com Inc. "Building sucessfull e-businesses since 1997" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql forum or newsgroup
> Hi, > > I willing to build and host a free mySQL discussion > forum/newsgroup for the mySQL community. I have web > space available and can easily build a discussion > forum using vbulletin and mySQL in a couple of days. > > Does the mySQL community think that we need a > discussion forum where all the mysql messages are > archived and offer superor search options ? Any > comments and feedback is appreciated. marc.theaimsgroup.com ...:-=>> The freaking Mail Band <<=-:... [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE"
From:- Gani Pola SP* PCI Data Consulting Marketing Division 434 Ridgedale Avenue, PMB # 11-108 East Hanover NJ 07936 Tel: 1-888-248-3443 OR 1-888-713-7201 Fax:1-603-297-5644 mailto:[EMAIL PROTECTED] Attention: Recruiting Department / Human Resources Department ==+=+== Please find our software consultant's brief information listed are available for contract or contract to hire positions. We have consultants available with skills- *- QA Testers with - QA Center Test Pack: QA Run, QA Director and QA Track - Mercury Winrunner, Testdirector, Loadrunner,Windows, Unix, Oracle - Seague Silk, Silk Pilot, Silk Performer, Windows, Unix,Oracle, SQL Server - Rational SQA Suite, Windows, Unix, Oracle - Main Frames tester with Winrunner,Testdirector * Telecom Embedded software developers using 'C',Assembly and on VxWorks & pSOS OS platform, Sonet, SNMP, Device Drivers * Auto CAD Developer - AutoCAD 11,14, 2000, CAM, Fabricam, Camstore, FC2001, Windows 95, 98NT. * Main Frames Developers with Cobol II, JCL, CICS, DB2, MVS, IMS, TSO, ISPFs * Oracle Developers with Developer / 2000 * Oracle DBAs * Microsoft certified windows 2000 Admins * Java Developers with EJB, Weblogic, Websphere, Swings, Servellets, JSP, XML, Unix and Windows * VB Developers with Crystal Reports, Oracle, MS Access and SQL Server * VB, ASP, SQL Server, COM/DCOM web developer * Visual FoxPro Developers with SQL Server, Windows * Certified Lotus Notes/Domino developer with R5.0 * System Admins-SUN CERTIFIED SENIOR UNIX ADMIN WITH VERITAS. All of them will relocate and our rates are including relocation. All of them are on H1-B visa status and available for Contract or Contract to Hire and some of them are immediate hire positions which requires H-1B visa transfer For detailed resumes,rates and contact information, Please send us an e-mail mailto:[EMAIL PROTECTED] ** *** To receive our Hotlist of available software testers-consultants please send a balnk e-mail mailto:[EMAIL PROTECTED] ** -- -- REMOVAL INSTRUCTIONS (REQUEST) T O T H E R E C I P I E N T -- -- ** ** If you have received this message in error,we apologize for any inconvenience. To ensure that you do not receive further email from us and wish to be removed from our list,please send us an e-mail, mailto:[EMAIL PROTECTED]?[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: please help newbie
* John Kurkiewicz Jr. > I am using perl 5 and linux 6. I am currently capable > of retrieving information from my databases, but am at > a complete loss as to how to parse the results into 20 > results per page. Take a look at the LIMIT part of the SELECT statement. >From the manual http://www.mysql.com/doc/S/E/SELECT.html >: "The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1): mysql> select * from table LIMIT 5,10; # Retrieve rows 6-15" For 20 rows per page, you would use: SELECT ... FROM ... WHERE ... ORDER BY ... LIMIT $start,20 Your initial value for $start is 0, but in the "Next page" link you set it to 20 ($start+20). -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need Prototyping tool
try phpgen It gives a nice web interface that then you can mess around with. Requires php however. http://www.byggsoft.se/~mikaelu/phpgen.html Rick -Original Message- From: Langfeldt, Jeanne [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 2:04 PM To: '[EMAIL PROTECTED]' Subject: Need Prototyping tool Hi, I wish to set up a MySQL DB, but due to time constraints need to get something up and running quickly. I would like to do set it up in something like Access, then later convert it to MySQL.. I need to run it on the Solaris platform, so Access is out, but I need something like it - quick and dirty - preferably with built in web interfacing. Would also be nice if the end user could create custom reports (as in Oracle). Oracle is definitely too expensive and slow for what I want. Thanks, Jeanne Langfeldt Software Engineer NASA Deep Space Network JPL, Pasadena - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cannot figure out how to parse SELECT query into pages
please help: I cannot figure out how to parse SELECT query into html pages. __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation trouble with PHP Mysql
Hi Luis, Did you compile PHP to include MySQL? At 13:46 -0800 2001/12/17, Luis A wrote: >I have just installed the current version of php and mysql server plus >the client. > >I had apache running already, so that means that I did not have to >install it again. > >When I did a test on mysql to connect i get this error > > >Fatal error: Call to undefined function: mysql_connect() in >/var/www/html/test.php on line 3 HTH, /rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help newbie
I am using perl 5 and linux 6. I am currently capable of retrieving information from my databases, but am at a complete loss as to how to parse the results into 20 results per page. Can / will you help? __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Prototyping tool
Hi, I wish to set up a MySQL DB, but due to time constraints need to get something up and running quickly. I would like to do set it up in something like Access, then later convert it to MySQL.. I need to run it on the Solaris platform, so Access is out, but I need something like it - quick and dirty - preferably with built in web interfacing. Would also be nice if the end user could create custom reports (as in Oracle). Oracle is definitely too expensive and slow for what I want. Thanks, Jeanne Langfeldt Software Engineer NASA Deep Space Network JPL, Pasadena - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Selecting unknown columns
On Mon, 17 Dec 2001, Alex Kirk wrote: > I've got a 700-question multiple choice quiz that I've got imported into > MySQL, with one small problem: the answers to the quiz are not a separate > column. I have three columns for each of the possible answers; the correct > answer is denoted by a "*" in the appropriate field. For example, if I have > columns A, B, and C for the three answers, they would contain data such as > "George Washington", "*Abraham Lincoln", and "Bill Clinton". > > I'd like to be able to select out all the fields with a * in them, and then > place them in a new, blank column called Answer. However, I'm really not > sure how to select these out, since I can't say "where like "*%". > Further complicating the matter is the fact that, in a few of the questions, > there are multiple answers, and thus multiple columns with the asterisk in > them. > > How would I go about selecting out these fields? Even if I can only get > those with one answer, I'd be immensley appreciative. _If_ you can re-import I'd _strongly_ suggest you change your schema. You'd have one table for questions: Question question_id int PK question text Answer question_id int PK (part 1) display_order int PK (part 2) answertext is_correcttinyint (or bool, or whatever) Then it would _really_ easy to find all the correct answers, no matter how many you had. Ok, that's not necessarily the answer you were looking for, but if you did the import once maybe you can do it again. And if not at least its something to think about next time. -dave /*== www.urth.org We await the New Sun ==*/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation trouble with PHP Mysql
I have just installed the current version of php and mysql server plus the client. I had apache running already, so that means that I did not have to install it again. When I did a test on mysql to connect i get this error Fatal error: Call to undefined function: mysql_connect() in /var/www/html/test.php on line 3 Well heres the code I used Can someone tell me what I'm doing wrong . or is there other way I could test it out? Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: relationships between databases
You need to have some sort of unique identifier, like a primary key. And all the tables should agree upon that Defryn, Guy wrote: DG: Date: Tue, 18 Dec 2001 10:37:41 +1300 DG: From: "Defryn, Guy" <[EMAIL PROTECTED]> DG: To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> DG: Subject: relationships between databases DG: DG: DG: DG: This is my first post to the list DG: DG: What is the best way of making a relationship between tables in Mysql. DG: Do you set it up when you are creating the tables or is it done with the DG: insert statement DG: DG: I am a newbie to Mysql, BTW DG: DG: Guy DG: DG: - DG: Before posting, please check: DG:http://www.mysql.com/manual.php (the manual) DG:http://lists.mysql.com/ (the list archive) DG: DG: To request this thread, e-mail <[EMAIL PROTECTED]> DG: To unsubscribe, e-mail <[EMAIL PROTECTED]> DG: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DG: -- Sherzod Ruzmetov <[EMAIL PROTECTED]> http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
Hi John, Just listing the files and directories in your data directory won't tell you (or anyone else here) if you're out of disk space. Try: $ df -k to show your disk free space in K. or, if you're in a directory, try $ du -sk * to show you a disk usage summary, in K, of the things in the directory. At 14:41 -0600 2001/12/17, John Lepone wrote: >I don't think I'm out of room on the volume. Below is the directory >listing: > >-rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001 >-rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002 >-rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003 >-rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 >-rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 >-rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index >-rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err >-rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid >-rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* >drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ >srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= >drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ HTH /rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
Venu <[EMAIL PROTECTED]> writes: > No such, as long as it is GPL distribution. Actually, it's Public Domain, not GPL. It's included in Red Hat Linux 7.2. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
relationships between databases
This is my first post to the list What is the best way of making a relationship between tables in Mysql. Do you set it up when you are creating the tables or is it done with the insert statement I am a newbie to Mysql, BTW Guy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation trouble
Installed mysql on suse 7.3 on intel, server does not run, error message is attached Please help thanks Mysql version 3.23.41 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC availability
Hi Kevin, > -Original Message- > From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 17, 2001 12:47 PM > To: [EMAIL PROTECTED] > Subject: MyODBC availability > > > Does anyone know why it is that the MyODBC authors prefer not to allow that > to be distributed in the unixODBC package, or with distros (eg the SuSE CDs > don't contain it)? Peter will answer this, why MyODBC is not included in unixODBC distribution :) Peter, any comments .. ? > > Is it a licensing issue, something to do with the ODBC spec, or just plain > "don't want to do that, so there" (which, I hasten to add, is perfectly > acceptable)? No such, as long as it is GPL distribution. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing MysQL
Hi, I try to install MysQL-4.0.0, but when I 'make' I receive the following: make[2] ***[ctype_extra_sources.c] error 132 make[2] Leaving. make[1] *** [all recursives]error 1 make[2] Leaving. make *** [all recursives-am]error 1 somebody an id ? Greets Piet Vlissingen (Holland) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC availability
Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Is it a licensing issue, something to do with the ODBC spec, or just plain "don't want to do that, so there" (which, I hasten to add, is perfectly acceptable)? Just curious. Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I don't think I'm out of room on the volume. Below is the directory listing: -rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001 -rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002 -rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003 -rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 -rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 -rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index -rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid -rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
On Mon, 17 Dec 2001 14:20:11 -0600, John Lepone <[EMAIL PROTECTED]> wrote: | I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to | the DB as root. When I try to create a new DB, I get the following error: | | [jlepone@mandrake jlepone]$ su | Password: | [root@mandrake jlepone]# mysql -p | Enter password: | Welcome to the MySQL monitor. Commands end with ; or \g. | Your MySQL connection id is 2 to server version: 3.23.46-log | | Type 'help;' or '\h' for help. Type '\c' to clear the | buffer. | | mysql> CREATE DATABASE mynewdb; | ERROR 1006: Can't create database 'mynewdb'. (errno: 28) | mysql> | | | Likewise, if I try to add a table to an existing DB I get the following: | | mysql> use test; | Database changed | mysql> CREATE TABLE mynewtable (mycolumn int); | ERROR 3: Error writing file './test/mynewtable.frm' | (Errcode: 28) | mysql> | | can anyone help? Check your ownerships and permissions. All the directories and files in the mysql data dir should be owned by your mysql user and mysql group. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
Error code 28: No space left on device You're out of disk space on the drive where your databases are stored. Chris Schreiber -Original Message- From: John Lepone [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 3:20 PM To: '[EMAIL PROTECTED]' Subject: ERROR 1006: Can't create database 'mynewdb'. (errno: 28) I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to the DB as root. When I try to create a new DB, I get the following error: [jlepone@mandrake jlepone]$ su Password: [root@mandrake jlepone]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.46-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE mynewdb; ERROR 1006: Can't create database 'mynewdb'. (errno: 28) mysql> Likewise, if I try to add a table to an existing DB I get the following: mysql> use test; Database changed mysql> CREATE TABLE mynewtable (mycolumn int); ERROR 3: Error writing file './test/mynewtable.frm' (Errcode: 28) mysql> can anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
> mysql> CREATE DATABASE mynewdb; > ERROR 1006: Can't create database 'mynewdb'. (errno: 28) > mysql> [carsten@tsort carsten]$ perror 28 Error code 28: No space left on device - Maybe clearing up some disk space would help??? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to the DB as root. When I try to create a new DB, I get the following error: [jlepone@mandrake jlepone]$ su Password: [root@mandrake jlepone]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.46-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE DATABASE mynewdb; ERROR 1006: Can't create database 'mynewdb'. (errno: 28) mysql> Likewise, if I try to add a table to an existing DB I get the following: mysql> use test; Database changed mysql> CREATE TABLE mynewtable (mycolumn int); ERROR 3: Error writing file './test/mynewtable.frm' (Errcode: 28) mysql> can anyone help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locked out
At 08:06 PM 12/17/01 +, Kevin Donnelly wrote: >On Monday 17 December 2001 15:04, David VanHorn wrote: > > I killed all Mysql processes, and confirmed that they are killed (ps -ef | > > grep mysql) > > Then I restart with safe_mysqld --skip-grant-tables > > Trying to log in to mysql in any way, including mysql -h localhost mysql > > or mysql root or mysql root -p gives me the failed password error again. > >The only time I ever did this, I did the following: > >- safe_mysqld --skip-grant-tables > >- mysql -u root mysql That's where I'm stuck, I can't get in with anything like the above. >You don't seem to be including the -u marker in the options you have tried >above. My mistake, I can't cut and paste from my terminal client (putty) -- Dave's Engineering Page: http://www.dvanhorn.org Got a need to read Bar codes? http://www.barcodechip.com Bi-directional read of UPC-A, UPC-E, EAN-8, EAN-13, JAN, and Bookland, with two or five digit supplemental codes, in an 8 pin chip, with NO external parts. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locked out
On Monday 17 December 2001 15:04, David VanHorn wrote:
> I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> grep mysql)
> Then I restart with safe_mysqld --skip-grant-tables
> Trying to log in to mysql in any way, including mysql -h localhost mysql
> or mysql root or mysql root -p gives me the failed password error again.
The only time I ever did this, I did the following:
- safe_mysqld --skip-grant-tables
- mysql -u root mysql
- update user set password=password("mypass") where user="root";
- exit
- mysqladmin -u root reload
- mysql -uroot -p
- enter mypass
That allowed me back in with the correct password.
You don't seem to be including the -u marker in the options you have tried
above.
Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting
> It simply won't connect. It just says 'Can't connect to local MySQL > server through socket '' (111)' > > I can connect via terminal so I know MySQL is (at least semi) correctly > setup. > > Any ideas? http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connecting
It simply won't connect. It just says 'Can't connect to local MySQL server through socket '' (111)' I can connect via terminal so I know MySQL is (at least semi) correctly setup. Any ideas? Kenny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL Database Specs
> Hello, > I am interested in knowing :- > 1) The maximum number of tables possible in MYSQL Database > 2) The maximum number of columns that are in a table. http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error handling in MySQL
> I have been scouring the MySQL site and manual for a couple of days > trying to find a place to have a listing of MySQL error messages > what they > mean and what should correct them. Does such a beast exist anywhere? > Specifically I am getting the error > > ERROR 1030: Got error 1 from table handler > > This happens when I do an order by in the sql statement. Use perror: [carsten@tsort carsten]$ perror 1 Error code 1: Operation not permitted. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Altering an index?
At 11:46 -0500 2001/12/17, Roger Karnouk wrote: >Is there a way to alter an index on a table without dropping it and >recreating it? I don't think so. See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html HTH, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 12:10 -0500 2001/12/17, Etienne Marcotte wrote: >Netscrap 4.78 >oops sorry mispelled that one.. Netscape :) Hmmm. I see you're using Netscape on NT. [X-Mailer: Mozilla 4.78 [en]C-CCK-MCD (WinNT; U)] Haven't tested with that -- I don't have a BillWare OS here -- but friends have accessed the archive from 95, 98, 2000, and XP that I know of. This is the first report that the 'Any Date' selection has not appeared checked by default. Wonder what could be causing it...? The archive has been tested with Netscape 4.0-4.78 on Solaris, Linux (RedHat 7.0), and MacOS; with Mozilla on Linux; with IE on MacOS; with Lynx and even with the browser in 'StarOffice' on Solaris. :> >I do loads of html and I hate Netscape with a passion, I think 6.2 >renders pages like IE4, but I'm not even sure, and only .2% of websurfer >use it. www.technodium.net/kira/kira.htm check this out with IE = >perfect.. chek it out with NS, different for every version, even if all >the tags are ok > >As for email spamming, you are right, since it's taken from a database. >Unless the archive was called e-may, I think we might not have to >protect the emails beyond leaving them outside of static webpages:-) That's my thinking... At 12:16 -0500 2001/12/17, Etienne Marcotte wrote: >grr > >e-may > >my bad > >meant e-bay > >two keys beside.. I think I have the shake > >sorry! Having a bad spelling day, my friend? >Etienne Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
Netscrap 4.78 oops sorry mispelled that one.. Netscape :) I do loads of html and I hate Netscape with a passion, I think 6.2 renders pages like IE4, but I'm not even sure, and only .2% of websurfer use it. www.technodium.net/kira/kira.htm check this out with IE = perfect.. chek it out with NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) Etienne Robert Alexander wrote: > > At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: > >This is a very very good search engine for the mailing list!!! Great > >work > > Thank you! > > >Two things: > > >2- Put the "Any Date" checked by default so we don'T have to always > >click it:-) (I'm lay) You could add some javascript so that the > >range is celected when something is entered in the from or to fields > > Second one first: "Any Date" is already checked by default. What > browser/OS are you using? > > >1- Is it possible to remove our full email adresses? > > To put like emarcott@... or emarcott at itl dot ca (like the > >mysqldeveloper archive. > > > > > >my 2 cents > > > >#2 is not a big thing, but #1 is pretty important against spam and spam > >bots. > > > >Etienne > > A valid concern, Etienne, and one that's very important to me, too. > Word's fail me in describing how much I detest spam -- well, at least > polite ones do. :-/ > > I believe our information is safe in this case, though. Let me explain why: > > To the best of my knowledge, Email harvesting 'bots (spambots) use > technology similar to that used by the big web search engines. Those > companies, like Google, Yahoo, etc., run two main pieces of software; > one (a 'spider') that continually accesses all the sites on the web > -- well, they hope it's all of them -- and stores information about, > or a complete copy of, each page they find. These pages are stored > in their database on their big, fire-breathing computers (it's a > staggering amount of data) and that's what the _other_ piece of > software, the search engine, looks through when you do a search. > > The spambots do basically the same thing -- they gather up web pages. > They, however, simply extract anything that looks like an email > address. These lower-than-pond-scum then add that to their database > (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that > you 'opted-in' or 'expressed an interest.' > > Fortunately, search engine page gatherers and spambots can access > only 'static' html pages that exist on a server and can be searched. > The pages you see when you search the email archive are safe from > 'bots because they don't even _exist_ until you ask for them -- > they're generated on-the-fly, on demand, and they're sent directly to > your computer. > > The content of the archive is visible only to the person doing the > search. So, it's a 99% solution. There's still the chance that an > unscrupulous person could go to the effort of doing an archive search > in the hopes of getting some email addresses to spam, but that's > simply not their style; that's too much like legitimate work. > Pirating email addresses is 'profitable' (I guess) if they let a > computer do all the work; it's not if a person has to write them down > or type them in. > > There are places that DO put the contents of mailing lists up on the > web on static, searchable pages. You should be aware of them so you > can make better-informed decisions, and thereby have more control > over where your address appears. One site with the MySQL list is > http://dbforums.com/f114/. Or try, for example, > http://www.mail-archive.com/dbi-users@perl.org/msg06361.html > > For an interesting exercise, you should try going to www.google.com, > or your favourite search engine, and doing a web search on your email > address and/or your phone number. The hits you get on that search are > the prime places where spambots are getting your email address from. > > I truly believe we're safe, though I'd love to hear more comments. > > All the best, > /Rob > > -- > Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 > http://www.workmate.ca WWW Database Applications and Web Hosting > > Searchable MySQL List Archive: http://archive.workmate.ca/myarchive -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: >This is a very very good search engine for the mailing list!!! Great >work Thank you! >Two things: >2- Put the "Any Date" checked by default so we don'T have to always >click it:-) (I'm lay) You could add some javascript so that the >range is celected when something is entered in the from or to fields Second one first: "Any Date" is already checked by default. What browser/OS are you using? >1- Is it possible to remove our full email adresses? > To put like emarcott@... or emarcott at itl dot ca (like the >mysqldeveloper archive. > > >my 2 cents > >#2 is not a big thing, but #1 is pretty important against spam and spam >bots. > >Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me in describing how much I detest spam -- well, at least polite ones do. :-/ I believe our information is safe in this case, though. Let me explain why: To the best of my knowledge, Email harvesting 'bots (spambots) use technology similar to that used by the big web search engines. Those companies, like Google, Yahoo, etc., run two main pieces of software; one (a 'spider') that continually accesses all the sites on the web -- well, they hope it's all of them -- and stores information about, or a complete copy of, each page they find. These pages are stored in their database on their big, fire-breathing computers (it's a staggering amount of data) and that's what the _other_ piece of software, the search engine, looks through when you do a search. The spambots do basically the same thing -- they gather up web pages. They, however, simply extract anything that looks like an email address. These lower-than-pond-scum then add that to their database (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that you 'opted-in' or 'expressed an interest.' Fortunately, search engine page gatherers and spambots can access only 'static' html pages that exist on a server and can be searched. The pages you see when you search the email archive are safe from 'bots because they don't even _exist_ until you ask for them -- they're generated on-the-fly, on demand, and they're sent directly to your computer. The content of the archive is visible only to the person doing the search. So, it's a 99% solution. There's still the chance that an unscrupulous person could go to the effort of doing an archive search in the hopes of getting some email addresses to spam, but that's simply not their style; that's too much like legitimate work. Pirating email addresses is 'profitable' (I guess) if they let a computer do all the work; it's not if a person has to write them down or type them in. There are places that DO put the contents of mailing lists up on the web on static, searchable pages. You should be aware of them so you can make better-informed decisions, and thereby have more control over where your address appears. One site with the MySQL list is http://dbforums.com/f114/. Or try, for example, http://www.mail-archive.com/dbi-users@perl.org/msg06361.html For an interesting exercise, you should try going to www.google.com, or your favourite search engine, and doing a web search on your email address and/or your phone number. The hits you get on that search are the prime places where spambots are getting your email address from. I truly believe we're safe, though I'd love to hear more comments. All the best, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-WIN] Access Problems
At 17.12.2001 17:50, A. Bacon wrote: >Help? I cannot get access to anything in mysql through my php scripts. >I have a good connection (with a user and password set up by inserting >into the user db) and can work with mysql from dos with no problem, but >when I issue any command to mysql through php, I get an 'access denied >for 'tonloc@localhost' for database 'whatever'... Have you made a user by that name who i supposed to have access to the DB in question? Use root@localhost (the default user) if you do not know how to make your own user (this is of course a huge security issue, so you should relly start reading those MySQL manuals ;) Regards - Tommy - --- -- -- -.-- ..-. .. -. ... . -. Tommy Finsen Redaktør, Webmaster, Hostmaster, Postmaster http://www.laiv.org Mail: mailto:[EMAIL PROTECTED] | ICQ: 908297 Cell +47 90531602 | Work +47 23062856 | Fax +47 23062801 - "Careful. We don't want to learn from this." - Calvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Problems
Help? I cannot get access to anything in mysql through my php scripts. I have a good connection (with a user and password set up by inserting into the user db) and can work with mysql from dos with no problem, but when I issue any command to mysql through php, I get an 'access denied for 'tonloc@localhost' for database 'whatever'... Any help would be greatly appreciated...Tonloc. I'm running mysql 3.22.34/apache3.12/php4.0 on a win95 machine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Altering an index?
Is there a way to alter an index on a table without dropping it and recreating it? I have a table containing 4 columns (col1, col2, col3, col4) and an index that currently uses 3 of them (not the primary key) idx = (col1, col2, col3) I want to change the index to idx = (col2, col3) I need to do this the fastest way possible. I am using 3.23.34 on a windows machine Thanks Roger Karnouk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 20:18 -1000 2001/12/15, Peter Reck wrote: >Rob, > >THANK YOU for putting this together. You're welcome. Glad you like it. :> >I am a complete newbie to MySQL, and have a VERY BASIC question: In the future, Peter, please direct questions to the MySQL list, and not to me personally. Thanks! >- How do I go into the db and clear and/or edit what has been written to it thus far? > >Maybe you can point me in a useful direction to learn about the basics of MySQL? The MySQL manual, either on-line (http://www.mysql.com/doc/) or in the distribution you got, is *very* good. Take a bit of time to get to know it. For a basic start on logging-in, and inserting and deleting data, take a look at the tutorial in the manual, Chapter 3 "Introduction to MySQL: A MySQL Tutorial." >I am now looking at a nice summary on developer shed right now, which gives me a >basic intro. The stuff on DevShed is generally quite good. It's a good resource. >Thanks a lot Rob, > >Peter Hope this helps, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: deleting records?
> Is there a way to delete records in a table by specifying row numbers. for > example: > > delete from tbl1 where row > 900 and row <1000; How do you get hold of the row numbers? The rows in the database are NOT the same as the rows in any particular SELECT you may have done. How the database stores the data internally is its private business. So generally, the answer is no. But if you provide some sort of ORDER BY clause, you ought you be able to use the field you have ordered by to select the records for deletion. For example, if you haven't already got an autoincrement key, add one and order by it. You will then be able to delete using that key. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL Database Specs
Hello, I am interested in knowing :- 1) The maximum number of tables possible in MYSQL Database 2) The maximum number of columns that are in a table. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locked out
At 09:20 AM 12/17/01 +, Carl Troein wrote: >David VanHorn writes: > > > At 08:58 PM 12/16/01 -0700, Doug Thompson wrote: > > >This should help: > > > > > >A.4.2 How to Reset a Forgotten Password > > >http://www.mysql.com/doc/R/e/Resetting_permissions.html > > > > Works ok up through step 2. > > mysql -h localhost mysql gives me error 1045 again. > > Can't get in with mysqladmin either. > >What exactly are you doing and at what point does it fail? Could >you post the contents of your terminal window after failing? I killed all Mysql processes, and confirmed that they are killed (ps -ef | grep mysql) Then I restart with safe_mysqld --skip-grant-tables Trying to log in to mysql in any way, including mysql -h localhost mysql or mysql root or mysql root -p gives me the failed password error again. -- Dave's Engineering Page: http://www.dvanhorn.org Got a need to read Bar codes? http://www.barcodechip.com Bi-directional read of UPC-A, UPC-E, EAN-8, EAN-13, JAN, and Bookland, with two or five digit supplemental codes, in an 8 pin chip, with NO external parts. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How MySQL proceses JOIN
Hello, I did not find anywhere the description of how MySQL processes multiple join. I'am attaching data for my actual db but those are not nesseesary for the question. I have a db which holds the data about CD Titles. The tables are: o - info about people su - info about persons associated with particular song s - info about songs ts - the table association Titles and songs t - info about titles The EXPLAIN shows: table type possible_keys key key_len ref rows Extra o range PRIMARY,Prijmeni Prijmeni 40 9 where used; Using temporary su ref IDSkladby,IDKategorieRole,IDOsoby IDOsoby 2 o.IDOsoby 560 where used s eq_ref PRIMARY PRIMARY 3 su.IDSkladby 1 where used ts ref PRIMARY PRIMARY 3 s.IDSkladby 1 Using index t eq_ref PRIMARY PRIMARY 2 ts.IDTitulu 1 where used The query is: SELECT t.IDTitulu, t.KC, t.Nazev, t.Medium, t.Cena FROM cOsoby AS o, SkladbyUmelci AS su, Skladby AS s, TitulySkladby AS ts, Tituly AS t WHERE t.IDTitulu = ts.IDTitulu AND ts.IDSkladby = s.IDSkladby AND s.IDSkladby = su.IDSkladby AND o.IDOsoby = su.IDOsoby AND s.Nazev LIKE '%e%' AND t.Nazev LIKE '%e%' AND o.Prijmeni LIKE 'no%' AND su.IDKategorieRole = 1 GROUP BY t.IDTitulu LIMIT 100, 20 I suppose that (correct me if wrong): It creates temp. table in which it places records from o which were selected using index Prijmeni. Then it opens the su table and finds all records matching IDOsoby from o (IDPerson) - from this list it automaticalli excludes rows restricted by su.IDKategorieRole = 1. Than it opens s and using the index (IDSkladby) it looks up all records from s (songs). From the "so-far-created" table it removes all records which does not match s.Nazev LIKE '%e%'. Or is that done on the row-bases - all tables are open in one time and the temp. table is created so that one row is composed from all the tables and then it proceeds to another? Thanx much Miroslav Renda - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.1?
That would be nice. I have been hoping for it since Nov 23 when there was a post saying that it would be out in the next week. http://lists.mysql.com/cgi-ez/ezmlm-cgi?2:mss:118:200111:nmfbdddincnalmjpnhng "Fournier Jocelyn [Presence-PC]" wrote: > > Hi, > > It should be really soon, Monty wrote me today he was building a > distribution with the current 4.0.1 code... > > Best Regards, > > Jocelyn Fournier > Presence-PC > > - Original Message - > From: "Franklin Schmidt" <[EMAIL PROTECTED]> > > > Does anyone know when 4.0.1 will be released? > > > > > > > > > > > > > > dear mail filter, use SQL to QUERY DATABASE TABLEs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
This is a very very good search engine for the mailing list!!! Great work Two things: 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. 2- Put the "Any Date" checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne Robert Alexander wrote: > > Hi everyone, > > Just want to make a very brief announcement. > > I've seen a few mentions in the recent past of the desire for a > searchable archive of the MySQL list. I've wanted one, too. > > So, being 'between contracts' right now, I decided finally to > write one. I've actually been keeping an archive of the MySQL list > for quite a while in anticipation of doing this some day. Just doin' > my bit... > > The archive is at http://archive.workmate.ca/myarchive > > It's still in BETA, so this is a test release to see how it holds up. > > It's fully searchable on Subject or Body, on the "From" address, and > by date range. It's running on a reasonably decent box (a Sun Ultra > 1), but on a fairly slow connection (for now). The pages are quite > compact, though, so as long as not everybody hits it at once, it > should give pretty decent performance. :> > > Written in Perl with MySQL as the backend, of course. :> The > archive is updated in real-time as the mails arrive, so it should > always be up-to-the-minute. > > Take a minute and let me know what you think -- it's a work in > progress, and feedback is appreciated. > > Thanks, all! > > /Rob > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
deleting records?
Is there a way to delete records in a table by specifying row numbers. for example: delete from tbl1 where row > 900 and row <1000; Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Blocked MySQL
Robert, You need to provide alot more data. How about platform and MySQL version to start, a copy of your config (my.cnf) file, and provide exactly what you're typing and the response. Scott Helms - Original Message - From: "robertix" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 7:02 AM Subject: Blocked MySQL > When I try to do anything with MySQL, I always see > "Ignoring query to other database" on my screen. When I type "status", the > computer prints: > "All updates ignored to this database". > after "Current user". > Could anybody help me ? Does anybody know how can I unblock MySQL ? > > robertix > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GCC downgrading problem
Hi all! Cold anyone tell me how to downgrade the gcc 2.96 compiler under linux red hat 7.2 to 2.95 ? I ended up messing my C libraries.. Anybody could tell me exactly what C related (cpp, gcc, gcc-c++, libstdc++, etc.. ??!!!) programs and libraries do I need in order to make it to work (compile) ? When trying to run .configure in order to build up MySQL 4.0, it says that it has gcc, c++, but it says that the C++ cannot build executables.. A link to where to find them all at once (rpm preferrable), would also be great, but I can find them if I know what I need. I did some rpm -ivh --force because I had some version conflicts.. anybody can enlight me a little bit :) ? Thank you ! DBI - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql++ api for linux
David Sheeks writes: > Is this where I would get some help using the mysql++ api for linux c++? > > dave > > It would be better if you would subscrube to mysql-plusplus mailing list. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql++ installation
Just ignore automake warnings. Regarding /opt/sfw/bin/ginstall problems, configure probably erred. Make a symlink so that the above ginstall points to the real one. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui, ?var? and quotes
Jean.Maupertuis writes:
> I try to use the ?var?'s to create a menu for inserting new rows in a table.
> for example:
> insert into personnel(first_name, last_name) values(?first_name?,
> ?last_name?)
> if i type jean in first_name and maupertuis in last_name the result is
> "unknow column
> 'jean' in 'field list' "because it's translated
> insert into personnel(first_name, last_name) values (jean,maupertuis)
> to correct i have to type 'jean' and 'maupertuis' this is tranlated
> insert into personnel(first_name, last_name) values('jean','maupertuis')
> which is the correct form.
>
> We can test this with a little sql:
> select ucase(?test?)
>
> I try different things to solve : concat, '?var?', ... but i don't find
> a way to bypass.
>
> Have anyone a better solution?
>
Just use quotes when inserting values.
I could (when I find time), do it automatically if column is
char/varchar/text/blob ...
Would that solve your problem ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation problem Windows98
Gitta, in Windows the error number 32 means: 32 The process cannot access the file because it is being used by another process. ERROR_SHARING_VIOLATION Maybe the installation left the MySQL server mysqld running in your system? When you try to start another mysqld instance, it rightfully complains that the ibdata file is already in use. You can try connecting to the first mysqld instance with the SQL client: C:...>mysql test Regards, Heikki Innobase Oy --- See http://www.innodb.com for the latest news about InnoDB Order commercial MySQL/InnoDB support at https://order.mysql.com/ >Hello, > >may I ask for help concerning the following problem: >I just installed mysql, created a my.cnf under c:/, containing >the information >[mysqld] >innodb data file path = ibdata1:50M. > >IBdata1 was created. > >But trying to start the server there is the following message: > >C:\mysql\bin>mysqld >InnoDB: Warning: operating system error number 32 in a file >operation. >InnoDB: Cannot continue operation. > >I already deinstalled, and installed again, but anyway there is still >the same error. > >I don´t have an idea, about the meaning of the message. >Is there someone who can help ? > >Regards >G.H. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max use of 'in'
Michael T. Babcock writes: > Is there an upper bound on how many items may be listed in an 'IN' clause? > > SELECT a,b,c from d where a in (1,2,3,4,5,6 ... 1123,1124); ...?? > > Thanks > -- > Michael T. Babcock > CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) > http://www.fibrespeed.net/~mbabcock/ Yes, max_allowed_packet -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL++/General Question
Mike Gleason Jr Couturier writes:
> Hello all !
>
> I've got 2 questions :
>
> Can we insert ASCII characters in an INSERT statement... like
> INSERT INTO guy(name) VALUES('ascii codes here'); so that the
> ascii code of a ';' will display a ';' in the database... understand !?
>
> And is there a place on the net that we can browse all errors no.
> of a Connection or Result or any objects that we can create...
>
> Thanks !
>
> Mike
>
You can achieve the above with ASCII codes with ostrstream class,
which is independent of MySQL, being a standard STL class.
Regarding the errors from Connection and Result, just browse our
on-line manual at www.mysql.com. Those are the same ones that come
from server or C API.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question on mySQL replication
Hi Jeremy: Thank you. At 02:05 AM 12/16/2001 -0800, you wrote: >On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: > > Greetings everyone: > > > > RE: http://www.mysql.com/doc/R/e/Replication.html > > > > How frequently does each slave get data from the master? > >The slaves have a thread running (the "slave thread") which is always >connected to the master, waiting for new queries. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui
Jean.Maupertuis writes: > hi > in the help file of mysqlgui we find that it has the functions for: > - Generating a menu with table fields based on tables that the user has > choosen > - Parametrized queries, where the user can put any number of ?var? > strings and getting a dialog with all ?var? specified, so that inputed > values replace ?var? s before execution > > How these 2 functions work? > > I try Commands ---> Table > Choose table > next Commands > Table -> Edit Table > > But nothing happen > > Thanks for your help > > Jean Maupertuis No, it does not work that way. If you have read all the docs, you would have known, but here is a summary : - Click on button or menu "Choose tables", choose the ones you want and then when in edit dialog click on the right mouse button. Click on the middle (or both left and right simultaneously) to see what you get - UPDATE table SET some_date=?What date did it happen? where id=?Which customer? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation problem Windows98
Hello, may I ask for help concerning the following problem: I just installed mysql, created a my.cnf under c:/, containing the information [mysqld] innodb_data_file_path = ibdata1:50M. IBdata1 was created. But trying to start the server there is the following message: C:\mysql\bin>mysqld InnoDB: Warning: operating system error number 32 in a file operation. InnoDB: Cannot continue operation. I already deinstalled, and installed again, but anyway there is still the same error. I don´t have an idea, about the meaning of the message. Is there someone who can help ? Regards G.H. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: row count for multiple tables.
Nissim Lugasy writes: > How do I retrieve the count for multiple tables with one sql command? > > Thanks Hi! Depends what is it exactly that you need. >From mysql database, you can : select count(*) from user,db where user.user=db.user; or select count(user.user), count(db.user) from user,db where user.user=db.user; -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Blocked MySQL
When I try to do anything with MySQL, I always see "Ignoring query to other database" on my screen. When I type "status", the computer prints: "All updates ignored to this database". after "Current user". Could anybody help me ? Does anybody know how can I unblock MySQL ? robertix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PCAnywhere like linux client - mysql data files administration
Jack A Fobel wrote: >I remember seeing a program awhile back that acts like pcanywhere or >terminal services, to connect to a linux or windows box. Anyone remember the >name? Depends what you mean: a. Terminal services, or b. pcanywhere(tm) If it's (a), then you've got a wide choice of: ocommand line services, telnet, etc. (the command line mysql client is pretty good imho). oX-windows, (using the DISPLAY variable) oVNC, etc... If you're looking for a PCAnyWhere-alike, then the only one I've found is x0rfbserver, which is available at http://www.hexonet.de/software/x0rfbserver/ (not tried it myself, but I've heard it's pretty good) This should allow you to control a server, (your database one?) from many clients, (it's supposed to be compatible with the VNC clients), from PalmPilots through to PC's etc. Note that VNC gives you (unless there's been a lot of changes since I last looked at it a year ago!) a desktop on the destination machine. It doesn't give you control of a particular screen, the same way that the Windows remote control software does. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish & Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: db and the web
Hi Frankie. Where did you created a db ? Which data will you add to your database ? A dump ? Be more specific. Greetz - Daniel Backhausen --- N2MEDIA web- & multimediadesign http://www.n2media.de - mailto:[EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: Frankie Cooke [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 17. Dezember 2001 11:20 An: [EMAIL PROTECTED] Betreff: db and the web Hello all I have created a database and now wish to make this available on the web, does anyone know what I need to upload and how I go about this processs. Is it a normal ftp process etc Please help & thanks for any help given Frankie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
db and the web
Hello all I have created a database and now wish to make this available on the web, does anyone know what I need to upload and how I go about this processs. Is it a normal ftp process etc Please help & thanks for any help given Frankie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Location of text file for loading data in to table
>> Hi, >> I am having problems loading data into a table and have 2 questions. >> >> 1) >> I want to load some data from a text file in to a table by using the >> following line: >> LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio; With this you have to save your text file inside the bin folder of your mysql folder e.g c:\mysql\bin. For it to work. >> >> this keeps giving me : File "st.txt" not found (ErrorCode: 2) >> >> Where should I store the st.txt file. I am using Windows and have >> mysql stored at c:\mysql. I have tried putting the file in the >> following locations: C:\mysql, C:\mysql\data, and >> C:\mysql\data\[DATABASE NAME](where the tables are stored) >> But keep getting the error. On the other way we just specify the full pathname to the file. If it's in D:\tmp\text.txt, use: LOAD DATA LOCAL INFILE "D:\\tmp\\text.txt" INTO TABLE tabname; Or: LOAD DATA LOCAL INFILE "D:/tmp/text.txt" INTO TABLE tabname; (courtsy : Paul DuBios) > > I'm using the same arrangement and found I had to put my data files > under my cgi-bin directory. But when I upload the code to my ISP, they > can be stored in the same directory as the script. This tells me it is > likely a configuration thing. > -- > Amer Neely [EMAIL PROTECTED] > Softouch Information Services: www.softouch.on.ca/ > Perl / PHP / CGI programming for shopping carts, data entry forms. "We > make web sites work!" > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what causes 'got error 127 from table handler'?
Hi, i encountered some problem with table: ERROR 1030: got error 1030 from table handler i found many solutions, how to temporarily fix it (myisamchk), but it appears again and again and makes our server unusable. so, the question is 'what can CAUSE it' and how to repair it forever? the machine is: intel celeron@400 with 256mb ram avgload: 0.05 0.03 0.00 1/54 24647 redhat 7.2 Linux version 2.4.13 (***) (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #1 Thu Oct 25 03:07:55 CEST 2001 mysql 3.23.41 the table, which gone damaged: CREATE TABLE counter ( id int(11) NOT NULL auto_increment, counts int(11) NOT NULL default '0', name varchar(80) NOT NULL default '', pridano datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (id,name) ) TYPE=MyISAM; does anybody know the answer? thank you JS -- jakub suchy [ [EMAIL PROTECTED] ] "Those who would give up a little freedom for a little safety, deserve neither freedom nor safety." --Benjamin Franklin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locked out
David VanHorn writes: > At 08:58 PM 12/16/01 -0700, Doug Thompson wrote: > >This should help: > > > >A.4.2 How to Reset a Forgotten Password > >http://www.mysql.com/doc/R/e/Resetting_permissions.html > > Works ok up through step 2. > mysql -h localhost mysql gives me error 1045 again. > Can't get in with mysqladmin either. What exactly are you doing and at what point does it fail? Could you post the contents of your terminal window after failing? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Monitor Mysql Server
Mike(mickalo)Blezien wrote: >Hello, > >Sorry for the OT,.. but I was hoping someone may suggest a script that can >monitor multiple mysql servers. We have two running and I would like to setup a >cron to check the servers once an hour or so to make sure it running and if not, >it would be capable of restart the server automatically in the event someone is >not available to restart it. I'm no shell script write... strictly Perl :) Not >sure this could be done with Perl. > >any suggestions would be appreciated. :) > Moodss (and the moomps daemon) can do that and more. You could set a threshold on an empty status for example for each server, get an email when the server becomes unreachable and execute a user defined script at that time (maybe using ssh to restart each server). Later, if you like, you can monitor any MySQL state (processes, queries, traffic, ...). Moodss is at http://jfontain.free.fr/ Jean-Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Couldn't fix table with quick recovery: Found wrong number of deletedrecords.
Subject: A random occur problem. Error message: Couldn't fix table with quick recovery: Found wrong number of deleted records. is reported when trying to execute DELETE/DROP TABLE and then INSERT... SELECT statement with thoursands of reocrds. >Description: Problem occurs when trying to execute: INSERT INTO Combinations_wBids (Combination_No, LicenseID, SubjectID, Bid_Value, Submit_Time) SELECT Combinations_details.Combination_No as Combination_No, Combinations_details.LicenseID as LicenseID, Combinations_details.SubjectID as SubjectID, TempStor_HighestBids_for_cal.Bid_Value as Bid_Value, TempStor_HighestBids_for_cal.Submit_Time as Submit_Time FROM Combinations_details, TempStor_HighestBids_for_cal WHERE Combinations_details.LicenseID=TempStor_HighestBids_for_cal.LicenseID AND Combinations_details.SubjectID=TempStor_HighestBids_for_cal.SubjectID; or INSERT INTO Combinations_for_display(Combination_No, Win_com_bid_sum, Total_Time) SELECT * FROM Combinations; Before executing the statements, contents of the tables will be cleared: DELETE FROM Combinations_wBids; DELETE FROM Combinations_for_display; Error report: Error number: 1034 Error message: Couldn't fix table with quick recovery: Found wrong number of deleted reords. Structures of related tables: CREATE TABLE Combinations ( Combination_No int(11) NOT NULL default '0', Win_com_bid_sum int(11) NOT NULL default '0', Total_Time bigint(20) NOT NULL default '0', KEY Combination_No (Combination_No) ) TYPE=MyISAM; CREATE TABLE Combinations_details ( Combination_No int(11) NOT NULL default '0', LicenseID char(3) NOT NULL default '', SubjectID int(4) NOT NULL default '0', KEY LicenseID (LicenseID), KEY SubjectID (SubjectID), KEY Combination_No (Combination_No) ) TYPE=MyISAM; CREATE TABLE Combinations_for_display ( Combination_No int(11) NOT NULL default '0', Win_com_bid_sum int(11) NOT NULL default '0', Total_Time bigint(20) NOT NULL default '0', KEY Combination_No (Combination_No) ) TYPE=MyISAM; CREATE TABLE Combinations_wBids ( Combination_No int(11) NOT NULL default '0', LicenseID char(3) NOT NULL default '', SubjectID int(4) NOT NULL default '0', Bid_Value int(11) NOT NULL default '0', Submit_Time timestamp(14) NOT NULL, KEY Combination_No (Combination_No) ) TYPE=MyISAM; CREATE TABLE TempStor_HighestBids_for_cal ( LicenseID char(3) NOT NULL default '', SubjectID int(4) NOT NULL default '0', Bid_Value double NOT NULL default '0', Submit_Time timestamp(14) NOT NULL, KEY LicenseID (LicenseID), KEY SubjectID (SubjectID) ) TYPE=MyISAM; Combinations, Combinations_for_display deal with about 2000 records. Combinations_details and Combinations_wBids deal with about 7000 records. TempStor_HighestBids_for_cal deal with about 30 records. Since the error message mentioned about "wrong number of deleted records", I 've tried to use to DROP and CREATE the tables instead of DELETE. However, the problem still occurs. The problem only randomly occurs. Sometimes, they work fine. Actually, it's a web application working with PHP. The DELETE, INSERT... SELECT statements are being executed repeatedly. Other queries will also be submitted to the database while executing the above statements, but those queries will not modify contents in the mentioned tables. What is going wrong? >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.43 (Source distribution) >Environment: System: Linux smartmarkets.ust.hk 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O -pipe' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 28 2000 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Oct 28 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Mar 1 2000 /usr/lib/libc.a -rw-r--r--1 root root
