Re: ANN: Upscene releases Database Workbench 5.4.4
Sent from my Samsung Galaxy smartphone. Original message From: "Martijn Tonies (Upscene Productions)" Date: 09/07/2018 13:17 (GMT+00:00) To: firebird-to...@yahoogroups.com, mysql@lists.mysql.com Subject: ANN: Upscene releases Database Workbench 5.4.4 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a custom report writer, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! Here's the full list of changes http://www.upscene.com/go/?go=tracker&v=5.4.x&id=12 For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
RE: Machine Learning
Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 23 August 2012 20:14 To: Martin Gainty; ag4ve...@gmail.com Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: Re: Machine Learning That is in fact a very interesting approach... I like it very much. Any architectural thoughts on an auto-population attempt? Odly I have not created a db like this before, not from this large of an import anyway... Please share some thoughts there and I will get that rolling... seems that if we can get something physical going I would like to offer it up as a sandbox to all those interested. I have a few X336's lying around my house just collecting dust, they would be a great testing environment for all to work on. garotconk...@yahoo.com From: Martin Gainty To: ag4ve...@gmail.com; garotconk...@yahoo.com Cc: webmas...@lisol.co.uk; "mysql@lists.mysql.com" Sent: Thursday, August 23, 2012 11:30 AM Subject: RE: Machine Learning Shawn and Garot I like the parsing capability of the lucene and its ability to stem incoming queries.. If you are able to start populating your data then we *should* be able to start identifying which root terms we can pull for building lucene-indexes I have an upcoming stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as long as I can find a wifi connection (and an AC connection within 6 hours) and use a working MySQL JDBC connection string..I should be able to bang out a quick prototype.. Let me know how i can help out, Martin Gainty __ ..place long-winded disclaimer here.. > From: ag4ve...@gmail.com > Date: Thu, 23 Aug 2012 10:42:55 -0400 > Subject: Re: Machine Learning > To: garotconk...@yahoo.com > CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com > > just a few thoughts (things to look into) > > if you want to populate a db with command parameters, i'd mine the man > pages. it's a consistent format and you should be able to find a > parser for whatever language you prefer. > > if you want to see what has been entered and statistics about that > process, look at the audit framework. it won't tell you success or > failure, but you might be able to derive that based on the time, > memory, and process usage that you can get from audit. auditd also > maintains a db - you might look into the engine and schema they use. > > you might also find some interesting topics looking into language > processing (after all, commands are a type of language). people > generally use other database engines to do this type of thing - > elastic search or some other things people have done with lucene > maybe. > > do let us know where you go with this. it sounds quite interesting > (and might help me with something i've been looking into)... and > getting zsh to autocomplete options might be a bonus if you parse man > pages and shove it into a db (i might do that part for you if i get a > lazy afternoon). > > On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin wrote: > > I am going to work up a visual diagram for this to better... > > visualize (LOL) the lay of the land. I will forward it when i have > > it completed then I hope we can continue the architectural > > discussion here! Thanks > > > > -Garot > > > > > > garotconk...@yahoo.com > > > > > > > > From: Garot Conklin > > To: Garot Conklin ; "webmas...@lisol.co.uk" > >; 'Martin Gainty' ; > >"mysql@lists.mysql.com" > > Sent: Tuesday, August 21, 2012 4:40 PM > > Subject: Re: Machine Learning > > > > to elaborate: > > > > I would almost rather qualify from the OS perspective what will work in > > advance, but take into consideration any failing condition. I may be > > getting a bit too specific at this juncture however as I am already apply > > this logic to issues I see in MY environment rather than total ambiguity, > > which is a best position here. > > > > I am ultimately expecting the learning algorithm to create new and > > excitingly effective ways of stringing commands together to solve issues, > > this being a notable aspect in and of itself, then creating some > > centralization based on what the machine determines as a best solution. > > > > Seems a relative "snapshot of the system" pre and post execution would be > > favorable as well so long as resources are not taxed as a result. This > > discussion is leading me to believe that this will be a multifaceted db > > solution without a doubt comprised of multiple layers of abstraction > > ultimately rolling up into a single master clu
RE: Machine Learning
Ah, Getting clearer and clearer. So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For instance, N1 runs a command in ‘domain’ D20 which it successful – it send information to node N20 that is the authority on domain D20 and N20 records it as success; N5 runs a command in domain D20 which goes wrong, and sends info to N20 and N20 records failure and sends a correct call to N5. Is this what you have in mind ? There are a lot of variables to be considered, for instance: 1) Command A version 1 can run very happily on operating system version 2, but fails in OS version 1 2) Command A version 1 can run happily on OS version 2 on a 2G RAM, but fail on OS version 2 on 1G RAM 3) etc I think the DB design issues will become straightforward once the model is quite clear. Justin From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 21 August 2012 17:14 To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com Subject: Re: Machine Learning 1)Refer to it for ‘knowledge’ (for instance, of what the latest version of a command is) It would most likely end up being "central" in this sense: A distributed collection of systems; i.e. (possible defined in roles) DB's FE's REPL's Cache's Each DB would have its own collection of remediation's that would then be indexed to populate a central db for trending/correlation etc... The "Collective" itself would function as a single conceptual implementation. A VIP for example might be associated with a specific role, say Web FE's and remediate only/all of them, but only have some relative access to the core db of say the Network from a Primary index perspective to make/draw associations/conclusions to issues at hand. 2)Send their ‘knowledge’ (for instance, of the latest command versions) to it for storage and distribution to others Rather than "latest command versions" I envision this to be more encapsulated as "latest successful invocation of the command string" and it inverse as well (to trend/metric-ize the failures thus lending to perpetual optimization). I like how this is fleshing out... This is helping me to define what I am really trying to accomplish. Thanks very much for everyone responding here, this is wonderful, please keep this going... garotconk...@yahoo.com _ From: "webmas...@lisol.co.uk" To: 'Martin Gainty' ; garotconk...@yahoo.com; mysql@lists.mysql.com Sent: Tuesday, August 21, 2012 11:19 AM Subject: RE: Machine Learning Hi Garot, Ok, the concept is getting clearer, but let’s bring this down to earth a little bit more. I love DB design and problem-solving and am quite curious about this. Is the idea that you have a central computer (not HAL J) somewhere so that other computers can: 1) Refer to it for ‘knowledge’ (for instance, of what the latest version of a command is) 2) Send their ‘knowledge’ (for instance, of the latest command versions) to it for storage and distribution to others If this is the model, then the knowledge base can build up organically over time – I think. Or is this too simplistic ? Thanks, Justin From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: 21 August 2012 00:25 To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: RE: Machine Learning When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to "take another stress pill" Sounds like a fun project Keep us apprised, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. _ Date: Mon, 20 Aug 2012 13:50:04 -0700 From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com Ya the idea is not anything new, but must be apparently quit difficult or not a priority as I have yet to find it already i
RE: Machine Learning
Hi Garot, Ok, the concept is getting clearer, but lets bring this down to earth a little bit more. I love DB design and problem-solving and am quite curious about this. Is the idea that you have a central computer (not HAL J) somewhere so that other computers can: 1) Refer to it for knowledge (for instance, of what the latest version of a command is) 2) Send their knowledge (for instance, of the latest command versions) to it for storage and distribution to others If this is the model, then the knowledge base can build up organically over time I think. Or is this too simplistic ? Thanks, Justin From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: 21 August 2012 00:25 To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: RE: Machine Learning When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to "take another stress pill" Sounds like a fun project Keep us apprised, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. _ Date: Mon, 20 Aug 2012 13:50:04 -0700 From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com Ya the idea is not anything new, but must be apparently quit difficult or not a priority as I have yet to find it already implemented anywhere... Far be it from me to not make some attempt here anyway... I am creating a fully automated framework from which a distributed infrastructure can be maintained. I have been writing automation scripts/code for some time now and the logical progression is to embark on a full concept of systems health auto remediation. I have numerous "monitoring" solutions under my control however none that properly (in my opinion) implements any real learning algorithms from which to draw even a minimalists view of automation. I like mySQL therefor began thinking about creating the aspects (lobes) of the "brain" as a relational database(s). So this is only one facet of what I am trying to do, however leveraging a full command set of shell utilities/commands/programs seemed to be a good starting point before I get into the "hard" stuff ! -Garot garotconk...@yahoo.com _ From: "webmas...@lisol.co.uk" To: 'Martin Gainty' ; garotconk...@yahoo.com; mysql@lists.mysql.com Sent: Monday, August 20, 2012 3:55 PM Subject: RE: Machine Learning Hi Garot, You'll have to elaborate some more ... I understand you may want to protect the idea as well, so if you can narrow it down to some technical specifics then it'll help. What is the objective of this system, for instance ? Thanks, Justin From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: 20 August 2012 19:23 To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: RE: Machine Learning From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns MG>which trends or patterns will you be modelling? and begin either an indexing methodology MG>which indexes are you considering: Unique index, primary index or foreign index? additional table/db creation process or both to further optimize the calls being made MG>optimize based on execution time or diskspace allocated, EliminatingFTS or some other criteria? MG>https://dev.mysql.com/doc/refman/5.5/en/optimization.html and build in some internal levels of redundancy. MG>what about replication MG>http://dev.mysql.com/doc/refman/5.5/en/replication.html I am actually approaching this with some degree of biological conception in the multipathing within our own brains however until I have something up and running under some substantial load however I may not get a complete picture. Thanks, Garot Interesting Martin
RE: Machine Learning
Hi Garot, You'll have to elaborate some more ... I understand you may want to protect the idea as well, so if you can narrow it down to some technical specifics then it'll help. What is the objective of this system, for instance ? Thanks, Justin From: Martin Gainty [mailto:mgai...@hotmail.com] Sent: 20 August 2012 19:23 To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com Subject: RE: Machine Learning From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns MG>which trends or patterns will you be modelling? and begin either an indexing methodology MG>which indexes are you considering: Unique index, primary index or foreign index? additional table/db creation process or both to further optimize the calls being made MG>optimize based on execution time or diskspace allocated, EliminatingFTS or some other criteria? MG>https://dev.mysql.com/doc/refman/5.5/en/optimization.html and build in some internal levels of redundancy. MG>what about replication MG>http://dev.mysql.com/doc/refman/5.5/en/replication.html I am actually approaching this with some degree of biological conception in the multipathing within our own brains however until I have something up and running under some substantial load however I may not get a complete picture. Thanks, Garot Interesting Martin _ From: webmas...@lisol.co.uk ; To: 'Garot Conklin' ; 'Martin Gainty' ; ; Subject: RE: Machine Learning Sent: Mon, Aug 20, 2012 7:13:25 AM Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating system. Each program comes with its own options and acceptable inputs. I don't know if there is a rule or convention for structuring these commands. Are you then looking to build a system that 'knows' all commands and 'how to' call them ? Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 20 August 2012 03:39 To: Martin Gainty; mysql@lists.mysql.com Subject: Re: Machine Learning The initial goal is to provide a working framework from which to call all UNIX shell command combinations as the underlying storage mechanism for a machine learning algorithm. I would like to build a completely self aware instantiation that will maintain itself on all levels... I postulate that the first place to start would be in determining a method for maintaining all possible remediation combinations including the unknown to eventually be learned from and populate new knowledge into the database. Thank you for the reply, Garot
RE: Machine Learning
Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating system. Each program comes with its own options and acceptable inputs. I don't know if there is a rule or convention for structuring these commands. Are you then looking to build a system that 'knows' all commands and 'how to' call them ? Thanks, Justin -Original Message- From: Garot Conklin [mailto:garotconk...@yahoo.com] Sent: 20 August 2012 03:39 To: Martin Gainty; mysql@lists.mysql.com Subject: Re: Machine Learning The initial goal is to provide a working framework from which to call all UNIX shell command combinations as the underlying storage mechanism for a machine learning algorithm. I would like to build a completely self aware instantiation that will maintain itself on all levels... I postulate that the first place to start would be in determining a method for maintaining all possible remediation combinations including the unknown to eventually be learned from and populate new knowledge into the database. Thank you for the reply, Garot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Database design help
Hi Neil, May be your question is too vague. You have already identified the 'real world' objects that you want represented in the database. Have you identified the specific pieces of information that you want stored for each object ? After you do that, you can then start to see what the relationships between the objects are. And you can then ask people that don't know anything about your application more specific questions like: - this is what I have in this and that object : how do I get this and that to relate to this and that ? Thanks, Justin -Original Message- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: 01 September 2010 12:52 To: [MySQL] Subject: Fwd: Database design help Looking for some help / comments if possible ? Cheers Neil -- Forwarded message -- From: Neil Tompkins Date: Tue, Aug 31, 2010 at 8:48 PM Subject: Database design help To: mysql@lists.mysql.com Hi I've a soccer application consisting of managers, teams players and fixtures/results. Basically each manager will get points for each game which will depend on the result. What would be the best table design bearing in mind that a manager can move to a different club. My thought was to have a field in the fixtures/results table for the manager points but i think that I will also need a users field so that I can remember which points belong to which manager. Is this the correct approach?? Cheers Neil __ Information from ESET NOD32 Antivirus, version of virus signature database 5414 (20100901) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __ Information from ESET NOD32 Antivirus, version of virus signature database 5414 (20100901) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Count Query question
Hi Keith, The way I would go about this is to try and pinpoint what the issue is, by breaking the query up. For instance, if you remove the 'product_quantity > 0' condition, do you get any more rows in your result ? I also notice that your 'products_date_avaiable' is defaulting to '2008-10-01 00:00:00' which is the same date in your two sample rows. Run a query like SELECT distinct (products_date_available) FROM products and see if there are there are any other dates ... if there are only 2, then you'll get only two rows. Thanks, Justin Tifang -Original Message- From: Keith Clark [mailto:keithcl...@k-wbookworm.com] Sent: 13 May 2010 14:11 To: mysql@lists.mysql.com Subject: Re: Count Query question Bob, Here are a few rows of my data: 17462, 0, '0929998596', '/GraphicNovels/0929998596.jpg', '8.5000', '2010-05-12 19:02:47', '2008-10-01 00:00:00', '2008-10-01 00:00:00', '0.50', 1, 1, 7429, 0, '1', 17461, 1, '1561481912', '/Cooking/1561481912.jpg', '3.', '2010-05-12 19:00:17', '2008-10-01 00:00:00', '2008-10-01 00:00:00', '0.50', 1, 1, 7428, 0, '1', Here is the query I ran: SELECT date(products_date_available) as Date, COUNT(products_quantity) as 'Titles Available', SUM(products_quantity) as 'Books Available' FROM products WHERE products_quantity > 0 GROUP BY date(products_date_available); And I only got back two rows from over 2 years of daily entries: '2008-01-01', 3327, '3736' '2008-10-01', 2739, '2904' I'm not sure I understand where I'm going wrong. Keith On Wed, 2010-05-12 at 21:54 -0500, Bob Cole wrote: > Kevin: > I assumed the following data: > products_id products_date_available products_quantity > 112010-05-01 1 > 112010-05-02 0 > 112010-05-03 3 > 112010-05-04 3 > 112010-05-05 3 > 112010-05-06 1 > 112010-05-07 0 > 112010-05-08 3 > 112010-05-09 3 > 112010-05-10 3 > 112010-05-11 3 > 112010-05-12 3 > 222010-05-01 1 > 222010-05-02 2 > 222010-05-03 0 > 222010-05-04 3 > 222010-05-05 3 > 222010-05-06 1 > 222010-05-07 0 > 222010-05-08 3 > 222010-05-09 0 > 222010-05-10 3 > 222010-05-11 3 > 222010-05-12 3 > 332010-05-01 1 > 332010-05-02 2 > 332010-05-03 3 > 332010-05-04 3 > 332010-05-05 3 > 332010-05-06 0 > 332010-05-07 0 > 332010-05-08 3 > 332010-05-09 3 > 332010-05-10 0 > 332010-05-11 3 > 332010-05-12 3 > > and used the following query: > SELECT products_date_available, COUNT(products_quantity), > SUM(products_quantity) > FROM products > WHERE products_quantity > 0 > GROUP BY products_date_available > > and got the following results: > products_date_available COUNT SUM > 2010-05-01 00:00:00 3 3 > 2010-05-02 00:00:00 2 4 > 2010-05-03 00:00:00 2 6 > 2010-05-04 00:00:00 3 9 > 2010-05-05 00:00:00 3 9 > 2010-05-06 00:00:00 2 2 > 2010-05-08 00:00:00 3 9 > 2010-05-09 00:00:00 2 6 > 2010-05-10 00:00:00 2 6 > 2010-05-11 00:00:00 3 9 > 2010-05-12 00:00:00 3 9 > > One line for each day except that 2010-05-07 is missing because each product > had 0 quantity on that day. > For example, on 2010-05-01, there were 3 products (each with a quantity of 1) > for a total quantity of 3. > I wonder if I am representing your situation correctly. What am I missing? > Bob > > On May 12, 2010, at 8:00 PM, Keith Clark wrote: > > Hi Bob, > > No, actually it does not. I'm looking for the count of items. From > > your query example I only get two rows. This table has over 2 1/2 years > > of daily sales data. > > Maybe I'm not stating my question correctly...h > > Thanks for responding though, greatly appreciated. > > Keith > > On Wed, 2010-05-12 at 19:46 -0500, Bob Cole wrote: > >> Keith: > >> Does this work? > >> SELECT products_date_available, COUNT(products_quantity) > >> FROM products > >> WHERE products_quantity > 0 > >>GROUP BY products_date_available > >> Hope this helps, > >> Bob > >> On May 12, 2010, at 3:06 PM, Keith Clark wrote: > >>> On Wed, 2010-05-12 at 10:13 -0400, Keith Clark wrote: > Chris, > Here is my full table definition: > > CREATE TABLE `products` ( > `products_id` int(15) NOT NULL AUTO_INCREMENT, > `products_quantity` int(4) NOT NULL, > `products_model` varchar(15) NOT NULL DEFAULT '', > `products_image` varchar(64) DEFAULT NULL, > `products_price` decimal(15,4) DEFAULT NULL, > `products_date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
Re: Upgrade Mysql
Thank You for all the help. I was upgrading from 4.0.x to 5.0.x The new mysql recognized the old databases without problems. Bye :)
Upgrade Mysql
Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be "recognized and imported" to work with the new version automatically. Thank You.
Joins with sums
I'm missing something really silly in a query. I want to produce a list of accounts, the invoices and receipts and the balance against them. Simply, there is an accounts table, invoices and receipts. I want to show the account details, sum(invoices), sum(receipts) and the balance. There is a situation where there maybe receipts and no invoices, and visa-versa, hence the if statement. SELECT account.accountId, account.name, if(count(invoices.invoiceId)=0,0,sum(invoices.amount)) as debits, if(count(receipts.receiptId)=0,0,sum(receipts.amount)) as credits, if(count(invoices.invoiceId)=0,0,sum(invoices.amount))-if(count(receipts.rec eiptId)=0,0,sum(receipts.amount)) as balance FROM family LEFT JOIN invoices ON invoices.accountId=account.accountId LEFT JOIN receipts ON receipts.accountId=account.accountId WHERE invoices.invoiceDate<=CURDATE() GROUP BY account.accountId For some reason, I'm getting results with multiple invoices etc against them - normally 3. Can anyone point out where I've gone wrong? Cheers Nunners -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)
Hello, Not wanting to "hijack" this thread, but what is the best source for a zip code database? The "best" free one I could find was from census data from the last census. Sometimes it won't recognize all the zips from large cities. Thanks, R -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One question about Perl DBI interface.
Good morning! Important: SQL Server used: MySQL (version 4.0.17) on UNIX FreeBSD. Answer this question please: Can I make a request, consisting of several SQL commands at one step, like this: use DBI; my $db = DBI->new(); $db = DBI->connect(...) or die "Can't connect to DataBase:", "error code", "\n"; $db->do("CREATE TEMPORARY TABLE tmptable (field1 INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,field2 DOUBLE(16,2) DEFAULT '0.00' NOT NULL); LOCK TABLES table1 read; INSERT INTO tmptable SELECT field1, MAX(field2) FROM table1 GROUP BY field1;"); I can do it by sending these commands one by one in series, like this: use DBI; my $db = DBI->new(); $db = DBI->connect(...) or die "Can't connect to DataBase:", "error code", "\n"; $db->do("CREATE TEMPORARY TABLE tmptable (field1 INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,field2 DOUBLE(16,2) DEFAULT '0.00' NOT NULL);"); $db->do("LOCK TABLES table1 read;"); $db->do("INSERT INTO tmptable SELECT field1, MAX(field2) FROM table1 GROUP BY field1;"); I think last solution is more time expensive. # Truly yours Sviridov Vladislav. [EMAIL PROTECTED]
It is possible to copy the database of mysql-3.22.32 on version 4.0.20? There is possibility that they work?
It is possible to copy the database of mysql-3.22.32 (/usr/local/mysql/var) on version 4.0.20 (/usr/local/mysql_new/var)? There is possibility that they work? My O.S. is Solaris 8 Thank's Alessio P.S. In that case I must use the function "mysqlhotcopy"? I don't have the possibility to use "mysqldump --all-databases > all_databases.sql"
Fw: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client
> Yare sure that this resolves my problem? > My problem is the client graphical (webmin or phpmyadmin), working from > shell (SSH) is all to place. > Thanks > Alessio > > > - Original Message - > From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, November 16, 2004 9:34 PM > Subject: RE: Mysql-4.1.7 and client library - Client does not support > authentication protocol requested by server; consider upgrading MySQL client > > > > You need to reinstall your mysql api library to talk to mysql-4.1.7: 4.1.7 > > has a different auth implementation that is more secure then the 3.23 > mysql > > protocol which your using. I suggest you link against the C-api that comes > > with 4.1.7. > > > > > > > > DVP > > > > Dathan Vance Pattishall http://www.friendster.com > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, November 16, 2004 11:38 AM > > > To: [EMAIL PROTECTED] > > > Subject: Mysql-4.1.7 and client library - Client does not support > > > authentication protocol requested by server; consider upgrading MySQL > > > client > > > > > > They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to > the > > > suggestions > > > of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin > > > (last version -2.6.0-pl2) I have this problem: > > > > > > "DBI connect failed : Client does not support authentication protocol > > > requested by server; consider upgrading MySQL client" > > > > > > From shell it works all the solution to the problem exists? Or it is > > > better install the version 4.0.21? > > > > > > > > > Thank's > > > Alessio > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the suggestions of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin (last version -2.6.0-pl2) I have this problem: "DBI connect failed : Client does not support authentication protocol requested by server; consider upgrading MySQL client" >From shell it works all the solution to the problem exists? Or it is >better install the version 4.0.21? Thank's Alessio
Mysql-4.1.7 Start - Ended error - Solaris 8
Sorry form my english, I am Italian. They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the suggestions of Gleb Paharenko. Now I have this problem: When start the command "mysqld_safe &" mysql start and ended immediately. In the log file I find this error: "041115 20:43:42 mysqld started 041115 20:43:42 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. 041115 20:43:42 mysqld ended" Help me, thanks Alessio
Solaris 8 error make on mysql_4.1.7
Sorry form my english, I am Italian. I have a problem when run "make", the error is following g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include -g -DSAFE_MUTEX -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/download/mysql_4.1.7/mysql-4.1.7/include -DHAVE_RWLOCK_T -c -o mysql.o `test -f 'mysql.cc' || echo './'`mysql.cc ../depcomp: exec: g++: not found *** Error code 127 make: Fatal error: Command failed for target `mysql.o' Current working directory /download/mysql_4.1.7/mysql-4.1.7/client *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /download/mysql_4.1.7/mysql-4.1.7 *** Error code 1 make: Fatal error: Command failed for target `all' __ Help me, thanks Alessio
Help query with MySQL 4.0.11
Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma The query is: SELECT U.usu_id, U.usu_login FROM cva_usuario U WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U usu_id Where GU.gru_id=4) Help please. Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem Query EXISTS and IN
Hi (Sorry by my english, i speak spanish) I have problem with a Query. It does not recognize EXISTS nor IN nor NOT IN My version is MySQL 4.0.11a-gamma But I do not know if it recognizes those clauses. I have dealed with the two forms: 1. SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT * FROM grupo WHERE usuario.g_id=grupo.g_id AND grupo.g_id > 5) 2. SELECT usu_id FROM usuario WHERE g_id NOT IN (SELECT g_id FROM grupo WHERE grupo.g_id > 5) Thanks by your help. Juan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Signal 11 shortly after upgrading to 4.0.12
The problem appears to be caused by inadvertently running mysql_convert_table_format on a database which had a few Berkeley DB tables. The other databases seem to work well. The comment given in http://www.mysql.com/doc/en/Upgrading-from-3.23.html about the use of the script should be more clear. Carlos Amengual - 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
Signal 11 shortly after upgrading to 4.0.12
>Description: I upgraded Mysql from 3.23 to 4.0.12, and everything went well. I even installed MySQL-Max, and the server restarted and apparently was well. However, when I stopped the daemon with service mysql stop" and then tried to start it again ("service mysql start"), refuses to start complaining about a signal 11. Same problem (refuses to start with signal 11) once reverted back to 3.23. The 4.0.12 version likely corrupted some of the databases. >How-To-Repeat: I was unable to reproduce the problem with a Red Hat 8.0 machine where I did the same upgrade. >Fix: >Submitter-Id: >Originator:Carlos Amengual >Organization: Healthnet SL >MySQL support: none >Synopsis: Signal 11 when starting the database after upgrade to 4.0.12 >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.56 (Official MySQL RPM) >Environment: System: Linux xxx.healthnet.es 2.4.18-18.7.x #1 Wed Nov 13 20:29:30 EST 2002 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-112.7.2) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 mar 20 12:30 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x2 root root 1285884 mar 6 16:03 /lib/libc-2.2.4.so -rw-r--r--1 root root 27338566 mar 6 15:05 /usr/lib/libc.a -rw-r--r--1 root root 178 mar 6 15:05 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' my.cnf: [mysqld] datadir=/var/lib/mysql #log-bin server-id=84 binlog-ignore-db=mysql innodb_data_file_path = ibdata1:1000M set-variable = innodb_mirrored_log_groups=1 innodb_data_home_dir = /var/lib/mysql/innodb innodb_log_group_home_dir = /var/lib/mysql/innodb/logs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /var/lib/mysql/innodb/logs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=250M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - 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
Load Data Infile problem.
Hi List. I have been working on a problem that is driving me crazy. I have to create a process in which I upload some info to a table. Since I have to add some different information to that table, I decided to do it like this. 1.I create a temporary table copying the structure of my final table. I.E. $query_temp_table="CREATE TEMPORARY TABLE tguias SELECT * FROM guias WHERE 1=0"; $temp_table=mysql_query($query_temp_table, $cosmo_logistic) or die(mysql_error()); I do this in PHP. It works fine It seems. 2. I populate the temporary table. $query_populate_tguias="LOAD DATA LOCAL INFILE 'c:/cosmo/www/upload/guias.txt' INTO TABLE tguias FIELDS TERMINATED BY ',' ENCLOSED BY '\"' (cliente,asesora,extra1,peso,albaran,gerente,tipo,imprimir)"; $populate_tguias=mysql_query($query_populate_tguias, $cosmo_logistic) or die(mysql_error()); 3. Then I pass the information along with some other variables to the real table. mysql_select_db($database_cosmo_logistic, $cosmo_logistic); $query_poblar = "SELECT * FROM tguias"; $poblar = mysql_query($query_poblar, $cosmo_logistic) or die(mysql_error()); $row_poblar= mysql_fetch_assoc($poblar); $totalRows_poblar= mysql_num_rows($poblar); do { mysql_select_db($database_cosmo_logistic, $cosmo_logistic); $query_poblar_guias="INSERT INTO guias (cliente,asesora,peso,albaran,gerente,tipo,imprimir,manifiesto,Status) VALUES (\"".$row_poblar['cliente']."\",\"".$row_poblar['asesora']."\",".$row_poblar ['peso'].",\"".$row_poblar['albaran']."\",\"".$row_poblar['gerente']."\",\"" .$row_poblar['tipo']."\",".$row_poblar['imprimir'].",\"".$manifiesto."\",\"A \")"; $poblar_guias=mysql_query($query_poblar_guias, $cosmo_logistic) or die("No pude insertar el registro ".mysql_error()); } while ($row_poblar=mysql_fetch_assoc($poblar));?> with this source file: "13DAN010","D79406","13DAN010", 1 ,"20430002201","75301;753","PAQUETE","1" "13DAN010","D55816","13DAN010", 1.32 ,"20430003101","100201;1002","PAQUETE","1" it Does not work at all. I wonder if it is because it has a . in the number even as the field receiving it is a decimal(10,2) or if it is because in one of the field I have ;. The thing is that it will import one, and skip one full record each time. But the one it inserts, is correctly inserted with the ; and the decimal point correct. Any idea why it might be pasing one row and adding one? This is driving me crazy. When I do this same procedure on another table with source code like: "D79427","LOPEZ DURAN ELISA","ACUEDUCTO TARRAGONA 59","15","PASEOS DEL BOSQUE","NAUCALPAN","53297"," ","LOPEZ DURAN ELISA","",F,T it Works correctly even as it has two false or true fields. - 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 : Dropping foreing key without losing data
Hello Zak, Thanks for your response. I try the way you told me, but it seems there is another problem : The old foreign keys always exist. In consequence, there are double references. How can i resolve that problem ? Thanks in advance. JeanClaude -Message d'origine- De : Zak Greant [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 30 janvier 2003 23:16 À : Webmaster LLBfrance Cc : [EMAIL PROTECTED] Objet : Re: Dropping foreing key without losing data On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: > Hello, > > Can you tell me how to drop or desactivate a foreign key without > losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - 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
Dropping foreing key without losing data
Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - 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
ÓòÃû×¢²á,ÐéÄâÖ÷»ú
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǺͿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.onway.net email:[EMAIL PROTECTED] лл£¡ ¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS P¡¢JSP£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ×££º¿ªÐÄ£¡Ë³Àû£¡ ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾ µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã µç»°:0592-5819328¡¢5815780¡¢5814120 ´«Õæ:0592-5888462 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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 : Optimizing
The server is mainly a Web server (Linux RedHat 7.3, P3 1GHz, server chipset, 500M) with CPU usage <5% CPU states: 1.7% user, 0.3% system, 0.0% nice, 97.8% idle Mem: 513900K av, 502676K used, 11224K free, 0K shrd, 114640K buff Swap: 522072K av, 0K used, 522072K free 321032K cached The used RAM moves from 470M tp 510M up and down. --- my.cnf is very basic: [root@webserv1 etc]# more my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-innodb [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid --- >From phpMmyAdmin SHOW STATUS I get: Max_used_connections 9 Other info sounds complicated but I could dump here. --- SHOW VARIABLES back_log 50 basedir /usr/ bdb_cache_size 8388600 bdb_log_buffer_size 32768 bdb_home /var/lib/mysql/ bdb_max_lock 1 How can I change bdb_home /var/lib/mysql/ to avoid link to /home/database/ ? Then shall I have to changed datadir /var/lib/mysql/ as well? (I want my DBs to be in /home/database/) Also get: max_allowed_packet 1048576 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 256 myisam_max_sort_file_size 2047 myisam_recover_options 0 myisam_sort_buffer_size 8388608 net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 open_files_limit 0 --- In phpMyAdmin I saw an "optimize table" but don't find detail in the doc...is it worth it? --- I also find phpMyAdmin slow to display table content... --- Any idea? JM -Original Message- From: Simon Windsor [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 12:26 PM To: MySQL Subject: Re: Optimizing Hi What else is running on the machine ? What processes are using the computers resources ? Use top to find out. What are the memory parameters used in my.cnf ? The answers to these questions will provide some helpfull answers to your problem. Simon On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote: > I migrated my site from a low end PC mutualized hosting to a brand new > P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL > slower now, the time for a PHP page is now about 6 seconds and was > about .6 before!!! > > I haven't done any optimization and the DB is the same, so the size > (about 10,000 records). > > The only 2 weaknesses I saw is that: > 1- I use a RedHat 7.3 RPM (haven't compiled myself) > 2- the database folder is on another partition linked from /var/... to > /home/... but on the same disk (a fast 10Krpm UW-SCSI). > > What would you advise? > > JM > > An example at http://www.labdv.com/forum/index.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
Optimizing
I migrated my site from a low end PC mutualized hosting to a brand new P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL slower now, the time for a PHP page is now about 6 seconds and was about .6 before!!! I haven't done any optimization and the DB is the same, so the size (about 10,000 records). The only 2 weaknesses I saw is that: 1- I use a RedHat 7.3 RPM (haven't compiled myself) 2- the database folder is on another partition linked from /var/... to /home/... but on the same disk (a fast 10Krpm UW-SCSI). What would you advise? JM An example at http://www.labdv.com/forum/index.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[2]: temporary and merge tables
Hi, sorry, didn't look at the changelog... ;) thanks! corin Monday, December 30, 2002, 9:29:12 AM, you wrote: PD> At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote: >>Hi, >> >>when trying to create a temporary table of type merge, mysql >>2.23.53 fails with an error like this: >>Can't find file: '#sql24b_776_0.MRG' (errno: 2) >> >>when not using the temporary keyword, everything works fine. >>so i assume this is a missing feature (not documented that this >>is forbidden/not supported yet) or a bug. PD> Looks like it's documented to me: PD> http://www.mysql.com/doc/en/News-3.23.54.html >> >>Corin - 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
temporary and merge tables
Hi, when trying to create a temporary table of type merge, mysql 2.23.53 fails with an error like this: Can't find file: '#sql24b_776_0.MRG' (errno: 2) when not using the temporary keyword, everything works fine. so i assume this is a missing feature (not documented that this is forbidden/not supported yet) or a bug. Corin - 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
ÓòÃû×¢²á,ÐéÄâÖ÷»ú
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǺͿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.onway.net email:[EMAIL PROTECTED] лл£¡ ¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS P¡¢JSP£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ×££º¿ªÐÄ£¡Ë³Àû£¡ ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾ µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã µç»°:0592-5819328¡¢5815780¡¢5814120 ´«Õæ:0592-5888462 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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
MySQL on virtual hosting
Dear list, Does any of you guys operate a mysql server in virtual hosting environment? I need some advice on tuning and restriction based on system resources. My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1 giga of RAM. I have 2 hd's in raid 1 mode (hardware). I currenly run MySQL 3.23.53 Here are few questions I have in mind, any other advice on keeping this system in a sane state will be appreciated. 1. From the following, what would be the best OS to run MySQL as of today? FreeBSD, Linux, OpenBSD 2. Is it possible to limit number of connections per user or database? MySQL can eat pretty much resources, if webmasters write bad code, I need to restrict them or charge extras for the usage as well as to protect the system against DOS attacks, which in this case will need to exploit a bad script which accesses the database. Restricting httpd connections is irrelevant here, so I must be able to control MySQL connections. 3. A lot of ready scripts or novice webmasters know very well how to open a connection but closing it... that's beyond them :) What is a sensible timeout and what exactly is the parameter that can kill these connections? 4. If you run a similar system, what would be the most important parameters for load tuning, and how would you set them? Thanks for all answers, Justin Grindea [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 : RE : Duplicate key delete record with same key
Victoria, So I looked deeper in my PHP code (I wrote it in February 2002) and saw I use a REPLACE statement: class persistent { // put method to save properties into the DB function put($thePrefix) { // job not done yet $returnValue = FALSE; // build table name and start the SQL REPLACE statement $sqlQuery = "REPLACE INTO ".$thePrefix.get_class($this)." SET "; // build the SQL REPLACE query foreach(get_object_vars($this) as $property=>$value) { $sqlQuery .= $property." ='".$value."', "; } // remove the ", " at the end of the string $sqlQuery = substr($sqlQuery, 0, strlen($sqlQuery)-2); // connect to the DB, put the object and close the DB if( $dbLink = mysql_connect(DBHOST, DBUSER, DBPASSWD) ) { if( mysql_select_db(DBNAME, $dbLink) ) { if( mysql_query($sqlQuery, $dbLink) ) $returnValue = TRUE; // job done } } mysql_close($dbLink); return($returnValue); // boolean } Etc This is PHP object code to make my member profiles (PHP objects) persistent in the DB. I use REPLACE so the member->put() method can be used to create or store change on member profiles. Therefore I looked at MySQL Manual: http://www.mysql.com/doc/en/REPLACE.html#IDX1431 << REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a UNIQUE index or PRIMARY KEY, the old record is deleted before the new record is inserted. >> So the result was predictible, sorry having sollicited the list. JM -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 6:01 PM To: [EMAIL PROTECTED] Subject: re: RE : Duplicate key delete record with same key BPF, Thursday, November 21, 2002, 4:36:58 PM, you wrote: BW> CREATE TABLE `reg_member` ( BW> `account` bigint(20) NOT NULL auto_increment, BW> `userid` varchar(48) NOT NULL default 'Your name', `uilogin` BW> tinyint(4) NOT NULL default '0', `id` varchar(48) NOT NULL default BW> '', `password` varchar(10) NOT NULL default '', BW> `joined` bigint(20) default NULL, BW> `expired` bigint(20) default NULL, BW> `status` varchar(20) NOT NULL default '', BW> PRIMARY KEY (`account`), BW> UNIQUE KEY `id` (`id`) BW> ) TYPE=MyISAM I tested it with 3.23.53 and it worked fine for me: mysql> update `reg_member` set id=4 where id=2; ERROR 1062: Duplicate entry '4' for key 2 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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 - 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 : Duplicate key delete record with same key
Sure: CREATE TABLE `reg_member` ( `account` bigint(20) NOT NULL auto_increment, `userid` varchar(48) NOT NULL default 'Your name', `uilogin` tinyint(4) NOT NULL default '0', `id` varchar(48) NOT NULL default '', `password` varchar(10) NOT NULL default '', `joined` bigint(20) default NULL, `expired` bigint(20) default NULL, `status` varchar(20) NOT NULL default '', PRIMARY KEY (`account`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM A+ JM -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 3:31 PM To: BPF Webmaster; MySQL Subject: Re: Duplicate key delete record with same key Hi, Could you give us SHOW CREATE TABLE your_table ? Greetings from France too ;) Jocelyn - Original Message - From: "BPF Webmaster" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, November 21, 2002 2:25 PM Subject: Duplicate key delete record with same key > Using PHP 4.2.3 with MySQL 3.23.52 > > Report: > --- > - Table has 2 keys: 'account' as PRIMARY and 'id' as unique > - I make an SQL update on an existing a record with id="anid" setting > id="anotherid" but another record exists with id ="anotherid" > - The update is performed and the record already existing with > id="anotherid" is deleted!!! > > Expected behavior: > -- > - Update failed with "Duplicate key attempt message" > I guess it's a bug, isn't it? > > The workaround is very easy but I really guess the behavior is weird. > > Greetings from France, > JM > > > - > 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
Duplicate key delete record with same key
Using PHP 4.2.3 with MySQL 3.23.52 Report: --- - Table has 2 keys: 'account' as PRIMARY and 'id' as unique - I make an SQL update on an existing a record with id="anid" setting id="anotherid" but another record exists with id ="anotherid" - The update is performed and the record already existing with id="anotherid" is deleted!!! Expected behavior: -- - Update failed with "Duplicate key attempt message" I guess it's a bug, isn't it? The workaround is very easy but I really guess the behavior is weird. Greetings from France, JM - 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 Process ID & Unix PID
Hi, Is there a way to compare between a mysql process ID showed in top or ps with a process ID from mysqladmin processlist ? I'm asking this because we operate a mysql machine used for webhosting and it has many users and many databases. If users do crazy stuff that result in high usage of resources, we need to determine who is the user, which database is it accessing and finally what script causes the problem. Any ideas or utils/scripts for digging this info apreciated. Tnx. Justin Grindea System Administrator SweetHome.co.il - 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
Crystal Reports & MySQL
Hi, does anyone knows if Cristal reports is a good reporter to make reports out of MySQL, or does anyone knows a good reporter for PHP MySQL? Thanks The Vampmaster - 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
Fw: FLOAT EQUAL OPERATOR
fuck you! this is the four time! can you say me before! -- INFOTEL TELEMATICA Srl Tel 0541 775927 - Fax 0541 775933 Sede operativa : Via Nuova Circonvallazione 57/c - 47900 Rimini (RN) Sede legale : Via Mazzoni 38 - 47900 Rimini (RN) Internet : http://www.infotel.it e-mail : [EMAIL PROTECTED] --- --- - Original Message - From: <[EMAIL PROTECTED]> To: "WebMaster - Infotel Telematica S.r.l." <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 9:52 PM Subject: Re: FLOAT EQUAL OPERATOR > Your message cannot be posted to [EMAIL PROTECTED] because it did not > follow the format expected by our spam/off-topic filter. To this list we > accept only repeatable bugs reports, meaning that you can describe a > set of steps we can follow to repeat the bug on our systems. > > If you are having problems with MySQL but are unable to provide the required > description, and have not purchased a support contract from MySQL AB, > you should send your message to [EMAIL PROTECTED] and possibly one of our > knowledgable users or developers will help you. However, we do not guarantee > that every message on [EMAIL PROTECTED] will be answered. We can afford > to provide free code, but unfortunately, we cannot afford to provide > guaranteed free support on top of that. We do, nevertheless, fix our bugs > regardless of who reports them and whose systems they affect, and will > investigate your problem if you can prove to us with a test case that the > error is in our code and not yours. > > If you have purchased a support contract from MySQL AB, you should follow > the standard support request procedure to report this problem. Support > contracts are available at https://order.mysql.com/. > > If you are able to describe how we can repeat the problem, include the string > "How-To-Repeat:" in the body of your message, followed by the detailed > description of what we need to do to make it happen, and our filter will > accept your message. If you use mysqlbug script, which comes with the MySQL > distribution, to post the message, it will be automatically accepted. > > You have written the following: > > ---start of your message > MySQL don't detect the equal float numbers if aren't ineger, left float > alwais greater then right float es. 1.1 > 1.1 = true. > > o mysqladmin version > > mysqladmin Ver 8.21 Distrib 3.23.39, for slackware-linux-gnu on i386 > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 3.23.39-log > Protocol version10 > Connection Localhost via UNIX socket > UNIX socket /var/run/mysql/mysql.sock > Uptime: 14 days 16 hours 30 min 5 sec > > Threads: 1 Questions: 93427 Slow queries: 0 Opens: 658 Flush tables: 1 > Open tables: 64 Queries per second avg: 0.074 > > o manufacturer and model of the machine > hp netserver lc 2000 > > o uname -a > Linux intranet 2.2.19 #59 Wed Jun 20 21:47:29 PDT 2001 i686 unknown > > o top > 1:06pm up 15 days, 29 min, 3 users, load average: 0.14, 0.10, 0.13 > 77 processes: 76 sleeping, 1 running, 0 zombie, 0 stopped > CPU states: 2.4% user, 0.8% system, 0.0% nice, 0.7% idle > Mem: 257412K av, 245084K used, 12328K free, 113944K shrd, 46844K > buff > Swap: 530104K av, 552K used, 529552K free 106924K > cached > > o compiler > gcc 2.95.3 > > o problems with SELECT statements > > mysql> SHOW VARIABLES; > +-+- > -- -- > --+ > | Variable_name | Value > | > +-+- > -- -- > --+ > | ansi_mode | OFF > > | > | back_log| 50 > | > | basedir | /usr/ > | > | binlog_cache_size | 32768 > | > | character_set | latin1 > | > | character_sets | latin1 dec8 dos german1 hp8 koi8_ru > latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr > win1251ukr greek win1250 croat cp1257 latin5 | > | concurrent_insert | ON > | > | conn
using php to connect to a 2nd mySQL server
Hello all, I am new to this list ... and hope to find an answer to a question which has come up. On the server for my websites at my ISP, a mySQL server is installed to handle different customers' databases (1 database setup for each customer) Now, as I have a need for a mySQL server where I can create/delete databases, my ISP agreed to install a 2nd mySQL server that can be dedicated to my sole use ... but I am told it would run on a different port number ... My question now is this: How can I tell a php script to not use the standard mySQL server that exists on this server computer, but to use the 2nd mySQL server that runs on the different port number ? Currently I use info set up in variables like this: # MySQL database config stuff $host="localhost"; $username="abcdefg"; $database="database"; $password="123456789"; Is it possible to add the port information somwhere? or does a php connection always use the standard mySQL port settings? Any help is greatly appreciated. Thanks! God bless you with His grace and peace Wolfgang Schneider -- BibelCenter: http://www.bibelcenter.de/ - "Come and See!" -- Bookstore: http://www.worthy.net/BibelCenter/ - "Great offers! Check it out!" -- email: mailto:[EMAIL PROTECTED] -- http://awesome.crossdaily.com/vote.php3?sid=952 -- Your Vote! - 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
RV: off-topic informix to oracle.
Sorry but I'm sure one of you guru's knows about the best software (ltl) to migrate informix database to Oracle, I need to link then oracle to MySQL, and then to report via crystal reports. EJB - 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
install mysql on osx 10.2
Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james - 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 : How to see warning messages for load data infile
Maybe try one line... I got this tons of warnings this morning making an import from Excel. But it was apparently successful...but all decimal value where store truncated like 128.00 , the reason is I'm in France and Excel exports decimal with coma 128,34 but MySQL expects 128.34 so I just replace all , with . in my CSV file with Ultraedit. Greetings, JM -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: re: How to see warning messages for load data infile David, Saturday, September 28, 2002, 2:37:00 AM, you wrote: DY> Hi all. I'm trying to load a file into mysql using "load data DY> infile" and got a ton of warnings. Is there any way to see what the DY> warnings are? MySQL doesn't store warnings anywhere. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ 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 - 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
Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ÏêÇéÇëä¯ÀÀ£ºhttp://www.onway.net ÁªÏµemail:[EMAIL PROTECTED] лл£¡ ×££º¿ªÐÄ£¡Ë³Àû£¡ ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾ µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã µç»°:0592-5819328¡¢5815780¡¢5814120 ´«Õæ:0592-5888462 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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
Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬ ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£ ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ Âú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ÏêÇéÇëä¯ÀÀ£ºhttp://www.onway.net ÁªÏµemail:[EMAIL PROTECTED] лл£¡ ×££º¿ªÐÄ£¡Ë³Àû£¡ ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾ µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã µç»°:0592-5819328¡¢5815780¡¢5814120 ´«Õæ:0592-5888462 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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
MAX_ROWS
Hello, I created a table using: "CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (pa)) TYPE=HEAP MAX_ROWS=10" Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned 16 records. Why this??? Does i should return only the last 10 records I inserted??? Please help me Nuno Lopes - 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
HEAP tables
Hello everybody, I have two questions: 1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I insert more 3 records. Does mysql delete older records and insert new ones?? 2) I created a table using this: CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (pa)) TYPE=HEAP MAX_ROWS=10 Then I have 16 (SIXTEEN) records. Why this. I think the max rows is 10?!?!?!? Can anybody help me??? Thanking in advance, Nuno Lopes - 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 some direction please
Here's my dilema. Our website runs a quarterly prize giveaway. Currently we have an ASP form that gathers the inputed info into a database and then sends us an e-mail confirmation of the entry. Our rules specifically state that only one entry is allowed per quarter. As I am not a programmer (just a dabbler in programming) I have no idea on how to do the following and need some help. What we need is a script that will check our current database against an e-mail, last name, and first name entry. If that entry is in our database a message pops up telling them that they have already registered with us. If there entry is not located in our database then the new info passes along unhindered. We are on a Cobalt RaQ4r with ChiliAsp 3.62 installed and are using MySQL. Thanks in advance for the help. Sincerely, Stephen M. LaBar, Jr. (770) 381-3826 Computer Specialist Please Visit Our Site At: http://www.csi-atl.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: Re: mysql uses 99% cpu under freebsd 4.3
> So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - 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: Using RAND()
Hi When I used the RAND() function (MySQL 3.23.45) I found the results were not very random, instead I use an extra bit of php code to make sure the results are more random. mt_srand((double)microtime()*100); $sql = "select order by RAND(".mt_rand(0,32767).") limit 50" $rs = mysql_query($sql); $num=mysql_num_rows($rs); if($num>1) mysql_data_seek($rs,mt_rand(0,$num-1)); $row=mysql_fetch_array($rs); To get a random record from earlier versions of MySQL you could do something like this. mt_srand((double)microtime()*100); $sql = "select... ..where limit 0,50" $rs = mysql_query($sql); $num=mysql_num_rows($rs); if($num>1) mysql_data_seek($rs,mt_rand(0,$num-1)); $row=mysql_fetch_array($rs); if you have a lot of records you can always put random numbers in the limit clause, (select ... where ...limit random_number, random_number + 50) this will return a random block of records, then use the seek functions to randomly pick a record from the record block, just make sure random_number isn't greater than the total records in your recordset. Pete Kelly - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:11 PM Subject: RE: Using RAND() > You have to have MySQL 3.23 or greater.. > > http://www.mysql.com/doc/M/a/Mathematical_functions.html > > Gurhan > > -Original Message- > From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 07, 2002 11:33 AM > To: [EMAIL PROTECTED]; Ulf Harnhammar > Cc: [EMAIL PROTECTED] > Subject: Using RAND() > > > > > The RAND() syntax does not appear to be working for me. > > What version mySQL is required? > > > At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote: > > >Hi! > > > > > "Ulf" == Ulf Harnhammar <[EMAIL PROTECTED]> writes: > > > >Ulf> On Sun, 27 Jan 2002, Michael Widenius wrote: > > >> One way to do this is to do as follows: > > >> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY > > >> RAND() LIMIT 10 > > > - > 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 > > > > - 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 performance issues - PLEASE ADVICE!!
I am having performance problems with my MySQL installation - what would be an appropriate channel for requesting help to such a problem? I have posted to this list twice and another one as well. Volumes are very high on using MySQL/standard SQL questions, but not an single suggestion has been submitted to my request. Is the only valid alternative to go for an annual support deal with MySQL.org? My site can't afford that. Lots of enthusiastic 'community' members will be disappointed if it should go down because I cant afford proper support. Please respond if you have any suggestion where it might be wise to direct my request! All the best; Eivind :-) - 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: Maximum number of rows in the table
> I don't think there is a limit. > Just as long as your harddisk can contain the data there should be no > problem. Yes, I guess this should be the case. Theoretically, though; the limit would be the number of indexable rows, wouldn't it? Since the integer length used to store this is 11 digits, this would amount to 10^11 = 100 000 000 000... Although probably not practially achievable; at least its quite far from 1500... Best regards, Eivind :-) mysql, query - 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
Problems with MySQL on FreeBSD4.5
(Sorry if I am reposting this now, guys...ehe) I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 3.23.49). >From time to time top shows that it runs >98% of CPU time, and of course the site's >response gets sluggish... Sometimes queries even times out or MySQL reports that no sockects are free to complete the request. This actually does not happen anymore, but it did a few times earlier...short time after we had a disk crash... ;-) I had a comment from one of the users regarding this: >I seriously suspect that mySQL under FreeBSD is your problem. On another heavily >loaded website I use (www.perlmonks.org), we're experiencing >similiar problems. >Current speculation is that it has to do with the way the FreeBSD flock() function is >broken. >I imagine what you're seeing is lots of blocked mySQL processes, or where a query >takes an exceptionally long time to complete. CPU utilization is >remaining pretty >low during the event. Just want to know if anybody has something to say to this matter, perhaps suggestions on where to start for debugging the problem? I have no clue where to begin looking for reasons, so any tip could very well be a good tip for me right now! Debugging tools or approaches to recommend...? Anybody? Best regards, Eivind, [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
Problems with MySQL on FreeBSD4.5
I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 3.23.49). >From time to time top shows that it runs >98% of CPU time, and of course the site's >response gets sluggish... Sometimes queries even times out or MySQL reports that no sockects are free to complete the request. This actually does not happen anymore, but it did a few times earlier...short time after we had a disk crash... ;-) I had a comment from one of the users regarding this: >I seriously suspect that mySQL under FreeBSD is your problem. On another heavily >loaded website I use (www.perlmonks.org), we're experiencing >similiar problems. >Current speculation is that it has to do with the way the FreeBSD flock() function is >broken. >I imagine what you're seeing is lots of blocked mySQL processes, or where a query >takes an exceptionally long time to complete. CPU utilization is >remaining pretty >low during the event. Just want to know if anybody has something to say to this matter, perhaps suggestions on where to start for debugging the problem? I have no clue where to begin looking for reasons, so any tip could very well be a good tip for me right now! Debugging tools or approaches to recommend...? Anybody? Best regards, Eivind, [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: What is `Aborted Clients` ?
Hi >> Can anyone explain me what is an Aborted Client ? I begin to wonder about this because this number was about 20 or 30 last week, and now suddenly it got above 200 ! I have no idea of what it means, so any help would be appreciated. << This is incremented if one of the following has happened: The client program did not call mysql_close() before exit. The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests. The client program ended abruptly in the middle of the transfer. Peter Kelly http://www.TrafficG.com - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "João Paulo Vasconcellos" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 7:31 PM Subject: Re: What is `Aborted Clients` ? > On Mon, Apr 29, 2002 at 02:52:16PM -0300, João Paulo Vasconcellos wrote: > > Hello Everybody, > > > > can anyone explain me what is an Aborted Client ? I begin to > > wonder about this because this number was about 20 or 30 last week, > > and now suddenly it got above 200 ! I have no idea of what it means, > > so any help would be appreciated. > > I believe that's the message generated when a client disconnects > abnormally. > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 81 days, processed 2,094,002,365 queries (298/sec. avg) > > - > 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: general query
Hi >>We say MySQL is open source database, so it can easily be adjusted to your requirements. But I wonder how many administrators have actually gone into the source code and made any modifications to match their specific needs, if any. << The point is you "can" make modifications if you want to, try making modifications to Microsoft SQL server source code, and because you have the source code you can compile the software to suit your own needs, try doing that with a commercial database product. >>If no, then why is MySQL better than other databases available in market, if we leave the cost alone.<< Commercial databases get updated by a limited number of programmers once per year if your lucky, opensource projects get updated many times per year by an unlimited about of programmers. If you find a bug in MySql you have the "choice" to fix the bug yourself and have your bug fix included in the release software. If you find a bug in say Microsoft SQL server all you can do is report the bug to Microsoft and hope they fix it, then to get a copy of the bug fixed software you will have to buy a new version of the software. >>I do not intend to challenge MySQL, but just wanted to know how this elite group can help someone if such a need arises !!<< This is not an elite group, its just normal people helping each other out, if you have a problem people will try to help you if they can, opensource is all about community sprit and not just about dollars in pockets. Peter Kelly - A Happy MySql User. http://www.TrafficG.com - Original Message - From: "Paras Mukadam" <[EMAIL PROTECTED]> To: "MySQL" <> Sent: Monday, April 29, 2002 1:58 PM Subject: general query > Hi Guru's, > > We say MySQL is open source database, so it can easily be adjusted to your > requirements. But I wonder how many administrators have actually gone into > the source code and made any modifications to match their specific needs, if > any. If no, then why is MySQL better than other databases available in > market, if we leave the cost alone. > I do not intend to challenge MySQL, but just wanted to know how this elite > group can help someone if such a need arises !! Has anyone other than the > core development team tried any changes before ?? > > With regards, > Paras > > > - > 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
Sorts
Hi List, If I run the sql query SHOW STATUS how can I tell how many queries required sorting? Here are some of the variables SHOW STATUS returns Questions 6623371 Sort_merge_passes 357 Sort_range 29213 Sort_rows 11271509 Sort_scan 231944 I want to try and calculate the percentage of sorts that required more than one pass!! Any help would be welcome. Thanks Peter Kelly - 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 first or last row
Hi MySql Details My server is running MySQL 3.23.45 and I have 4.0.0-alpha-nt on my local test machine. What is the fastest way to select the first or the last row from a database? I have tried queries like this (id is an auto incrementing primary key) select * from names order by id desc limit 1 select * from names order by id asc limit 1 select * from names limit 1 if I run the following sql queries with the explain command it returns the following results table type possible_keys key key_len ref rows Extra - - --- --- --- - names index NULL PRIMARY 4 NULL 61368 * No matter what I do, and what indexes I use, I cannot seem to find a way of selecting the last or first row without scanning the whole table. A few times recently I've wished for a new table type, a table that acts more like a pipe or stack just to solve this problem. Thanks Pete Kelly Other Items on my MySql wish list. 1 . It would also be nice to combine a select and a delete command together to form a whole new command, (Retrive data and auto delete the row) 2 . Another new command I would like to see is "Show Processlist History", basically this would show the last 30 or so queries run on the server. 3. I often run queries like this SELECT id FROM users WHERE name = 'pete' if the row exists UPDATE users SET visits=visits+1 WHERE name = 'pete' else INSERT INTO users (name) VALUES ('pete') It would be nice to make this type of code quicker. - 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: ADO API & ODBC Alternative help
Hi! Check the "MySQL with ASP" Forum at www.dwam.net/mysql/ in particular a thread called "Multiple Step Error" You can also find working ADO code samples on the site (using AddNew method) Finally you should consider using the latest MyODBC drivers 2.50.39 if you want to stick to 2.xx version 3.51.02 recommended for ADO support / D W A M W 3 S P A C E / Guillaume de Lafontaine - [EMAIL PROTECTED] . Services Internet : http://www.w3space.com . Annuaire Aquitaine : http://www.aquitanet.com . Espace TeleTravail : http://www.w3workers.com . DWAM.NT Docs & Resources : http://www.dwam.net -Message d'origine- De : Kelvin Lam <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : mercredi 13 mars 2002 23:13 Objet : ADO API & ODBC Alternative help |Hi, | |I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO |library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter). | |Here is my configuration: |- mySQL ODBC Version 02.50.38 |- mySQL server Version 02.50.38 |- Windows NT 4.0 with SP6 | |It seems like, mySQL does not implement all the ADO functionality. My |questions will be: |1- what is the set of functions in ADO that mySQL supports? Can I find |documentation about it? |2- If ADO is not fully supported, what other ways have people used for |database programming? DAO? RDO? Raw ODBC API call? | |Now for the specific problem I have, I have this code in VB: |rsTest.AddNew |rsTest.Fields("login").Value = CStr("kelvin") |rsTest.Update |rsTest.Fields("Password").Value = CStr("testing") |rsTest.Update |rsTest.Fields("Fullname").Value = CStr("my name") |rsTest.Update |rsTest.Fields("securitylevel").Value = 1 |rsTest.Update | |- I get an adStateOpen for both connection and recordset. |- The ADO connection opened correctly. The ADO recordset opened correctly |as well. |- The AddNew executed without error. |- The setting of "login" value executed without error. |- When I hit the line setting value of "password", I get the following |message: |Run-time error '-2147217887 (80040e21)': |Multiple-step operation generated errors. Check each status value. | |What did I do wrong? | | | | |Kelvin Lam |Software Engineer |Orbit Technology Corp |1528 Brookhollow Dr, Suite 66 |Santa Ana, CA 92705 |Phone: (714)427-0555 |Fax: (714)427-0556 | | | |- |Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before |posting. To request this thread, e-mail [EMAIL PROTECTED] | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail [EMAIL PROTECTED] instead. | - 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
update a row without affecting timestamp-type column
Hello all, I have a question which just may very well be ridiculous. In one table, we have a column of type "timestamp". In normal cases, we want any changes to this row to update this timestamp (hence the nature of this datatype). However, there is one case where we do NOT want the timestamp to update if we make a change to some data in that row. Is there any way to temporarily avoid updating a timestamp type? Thanks for your time. -Ian - 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: Hoe to create indexes on existing tables
|Hi, | |I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual |Basic application. | |I had a set of tables which I exported from Access database. |But now, I want to index these tables. How do I go about that? | Hi! the simplest solution is to get a GUI client for MySQL, in which indexing or any other operation are as easy to do as with Access... The most famous GUIs are : MASCON, MySQLFront, MySQLGui, DBTools... Otherwise, you can still use the CREATE INDEX clause with commandlines. Check the doc it is very well explained... All urls for GUIs at www.mysql.com or www.dwam.net/mysql/ | |Also, any suggestions of how cursors work with mysql would be of great |help. | Quite the same as for Access, and the next release of MyODBC (announced for this month end) should provide full compatibility with ADO. / D W A M W 3 S P A C E / Guillaume de Lafontaine - [EMAIL PROTECTED] . Services Internet : http://www.w3space.com . Annuaire Aquitaine : http://www.aquitanet.com . Espace TeleTravail : http://www.w3workers.com . DWAM.NT Docs & Resources : http://www.dwam.net |Thanks a lot | |Princy. | | |- |Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before |posting. To request this thread, e-mail [EMAIL PROTECTED] | |To unsubscribe, send a message to the address shown in the |List-Unsubscribe header of this message. If you cannot see it, |e-mail [EMAIL PROTECTED] instead. | - 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
Updating tables via cron
I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis. Currently I am resetting the appropriate fields to 0 on a daily and monthly basis (not fun). Is there a way to set a command in the cron table to do this for me automatically? Here are the details. db name: activity daily field name: dr (needs to be reset to 0) monthly field name: mr (same as above) I know how to tell cron the date/time I want an event to trigger, but I don't know the syntax of the command to send. Any help would be appreciated. Thanks, David - 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: help bad
i meant 3.23.. just so you all know -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 10:26:50 -0500 >i went through my code 20 times.. hit the help sites and all to see if it was a linux >problem or what.. >i am running 4.05 php >2.23.37 mysql (i believe, been awhile sine i touched it *l*) >its definately 2.23 i can say >i even got the 2.1 gd installed with it thought took a week >still shows as 1.6 though so guess it doint matter. aint had time to play to see if >it works better.. but wouldnt know cause never had time to play with old gd >i do this crap for a living.. and why this is acting up i dont understand.. its a >simple while loop that should count as it goes.. i am missing something dumb i >guess.. just help if ya can.. and thaks if you even bother to look it over.. > > >-- >Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ >Come Cruisin with the Angels http://www.AngelCruise.com >Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ > >- >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 > > -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - 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
help bad
i went through my code 20 times.. hit the help sites and all to see if it was a linux problem or what.. i am running 4.05 php 2.23.37 mysql (i believe, been awhile sine i touched it *l*) its definately 2.23 i can say i even got the 2.1 gd installed with it thought took a week still shows as 1.6 though so guess it doint matter. aint had time to play to see if it works better.. but wouldnt know cause never had time to play with old gd i do this crap for a living.. and why this is acting up i dont understand.. its a simple while loop that should count as it goes.. i am missing something dumb i guess.. just help if ya can.. and thaks if you even bother to look it over.. -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - 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
help please!-- i -hate imail! *l* which is why ask a cc to my reg account
Back | Next | Reply | Reply All | Forward | Delete | Move To database / sql/ mysql Message: 1 of 11122 Printable Version From: [EMAIL PROTECTED] Save Address Date: 25 Dec 2001 15:14:07 - To: "Webmaster" <[EMAIL PROTECTED]> Subject: Re: Re: Need Help bad!.. today.. of all days! Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: brad.. no the site kicks ass.. its also currently running another room thats a chat site that runs over 18,000 people and i have no proplems ever with theem logining in or anything.. its nothing to do with that.. it may be my math but i dont think so as i have done math 20 times tougher then this and the php ran it fine.. this is a simple draw out and count.. i dont get why it freaks unless i am missing something -- Original Message -- From: Brad Beaubien <[EMAIL PROTECTED]> Date: Tue, 25 Dec 01 09:12:19 -0600 >>Hello.. of all days i have a project thats to be shown tomorrow. >> >>i cannot get the dam thing to work >>it should be simple i'd think >> >>i would post code and all and if asked will > >[snip] > >Is the performance of your code "data independent"? >That is to say, if you remove the set of data where it stops, does it >stop there again? >Does the code stop "in the same place" with different data? > >Brad -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - 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 Help bad!.. today.. of all days!
hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough "alot dont" -- Original Message -- From: "Webmaster" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 09:53:50 -0500 >the code is huge i'll post whats relevant. there may be a few irrelevant things >in there... but hell... if your willing to look i'm willing to post > >i know what works so will skip down lower to prevent wasting your time >and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble >i understand > >i thought i was close.. but then compared the data and it doesnt match.. for instance >its spitting out the right subcluters.. and untill i asked for the coomparison it was >fine.. i cant do a percentage match or trial till it gives right info.. > > > > while($i_sub<$num_sub){ > $sub_id = >@mysql_result($result_sub,$i_sub,"subcluster_id"); >$result_per = >mysql_query("select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id >AND subcluster_id='$sub_id'",$db); > $num_per = >mysql_num_rows($result_per); > $i_per=0; //this >seems wrong but will count all subclusters equally 1 at a time through the while >"should" > $i_per1 = 0; // need >a double count so need two seperate > $cper = 0; > >while($i_per<$num_per){ >// so we >need to run the while, probably need to cut the ending out here to add to end of total > //gonna >change this into an include so its not listed 3 times here-maybe > // do >math function > $nper = >$num_per; > $nper2 = >($nper*5); // max reading to devide by > //answer >= // need to add all the answers here > >while($i_per1<$num_per){ > > $cper = $cper; > > $cper1 = @mysql_result($result_per,$i_per1,"ques_ans"); > > $i_per1++; > > $cper2 = @mysql_result($result_per,$i_per1,"ques_ans"); > > $cper = ($cper+$cper1+$cper2); > > // $cper3 = $cper; // this is just an easy extraction >// i think this actualy might work > > echo >"sub=$sub_id = $cper"; > > $i_per1++;}; // this should loop through output to count the results total >//TEST >//echo "cper3 = $cper3"; > > $i_per++; > }; > $i_sub++;}; > >i know theres some redundant code in there etc.. but hey.. till it works i dont like >to delete > > > >-- Original Message -- >From: Justin Farnsworth <[EMAIL PROTECTED]> >Date: Tue, 25 Dec 2001 09:28:53 -0500 > >>I think you need to post the code. The description of the >>problem is a bit ambiguous. >> >>_justin >> &g
Re: Need Help bad!.. today.. of all days!
the code is huge i'll post whats relevant. there may be a few irrelevant things in there... but hell... if your willing to look i'm willing to post i know what works so will skip down lower to prevent wasting your time and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble i understand i thought i was close.. but then compared the data and it doesnt match.. for instance its spitting out the right subcluters.. and untill i asked for the coomparison it was fine.. i cant do a percentage match or trial till it gives right info.. while($i_sub<$num_sub){ $sub_id = @mysql_result($result_sub,$i_sub,"subcluster_id"); $result_per = mysql_query("select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id AND subcluster_id='$sub_id'",$db); $num_per = mysql_num_rows($result_per); $i_per=0; //this seems wrong but will count all subclusters equally 1 at a time through the while "should" $i_per1 = 0; // need a double count so need two seperate $cper = 0; while($i_per<$num_per){ // so we need to run the while, probably need to cut the ending out here to add to end of total //gonna change this into an include so its not listed 3 times here-maybe // do math function $nper = $num_per; $nper2 = ($nper*5); // max reading to devide by //answer = // need to add all the answers here while($i_per1<$num_per){ $cper = $cper; $cper1 = @mysql_result($result_per,$i_per1,"ques_ans"); $i_per1++; $cper2 = @mysql_result($result_per,$i_per1,"ques_ans"); $cper = ($cper+$cper1+$cper2); // $cper3 = $cper; // this is just an easy extraction // i think this actualy might work echo "sub=$sub_id = $cper"; $i_per1++;}; // this should loop through output to count the results total //TEST //echo "cper3 = $cper3"; $i_per++; }; $i_sub++;}; i know theres some redundant code in there etc.. but hey.. till it works i dont like to delete -- Original Message -- From: Justin Farnsworth <[EMAIL PROTECTED]> Date: Tue, 25 Dec 2001 09:28:53 -0500 >I think you need to post the code. The description of the >problem is a bit ambiguous. > >_justin > >Webmaster wrote: >> >> Hello.. of all days i have a project thats to be shown tomorrow. >> >> i cannot get the dam thing to work >> it should be simple i'd think >> >> i would post code and all and if asked will >> >> but it comes down to this.. i am using php 4 and mysql.. and doing math >> i have say 40 entries in the database, 20 for two differant surveys.. anytime anew >person fills out the survey they get a unique id >> i have it set to grabe the results from each unigue id for each question through >mysql.. but it seems to stop shot about 4 questions.. >> i even tried dropped the while loop
Need Help bad!.. today.. of all days!
Hello.. of all days i have a project thats to be shown tomorrow. i cannot get the dam thing to work it should be simple i'd think i would post code and all and if asked will but it comes down to this.. i am using php 4 and mysql.. and doing math i have say 40 entries in the database, 20 for two differant surveys.. anytime anew person fills out the survey they get a unique id i have it set to grabe the results from each unigue id for each question through mysql.. but it seems to stop shot about 4 questions.. i even tried dropped the while loop 4 questions shorter "-4" and it still stop the same place.. of all days for this to occure.. i know but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] with your reply.. thanks -- Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ Come Cruisin with the Angels http://www.AngelCruise.com Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ - 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
html ina text feild
I've set up a database with a text feild and want to call that information with html code embeded into the text( eg. ). Do I need to change the type of field ?. At the moment the html code is being returned as plain text. - 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
question!!!
Hi All: I have Mysql,Php and apache webserver running on Freebsd 4.3 RELEASE, I need to connect via Web to an application done in php but that requests me user and password. - 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 A book for dynamic website
Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - 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
Problem mysql installation
Hi all; i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, when I execute a make i get an error "make: no target to make". Thanks and have a great day! - 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: ASP & MySQL
YES!!! I use ASP and MySQL... Works Great (Win2K, IIS5.0) John (www.smalltownworld.com) - Original Message - From: "L_U_I_Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 2:08 PM Subject: ASP & MySQL > I'm developing an application and I have to choose a good database > server. > > I'm considering MS SQL Server and MySQL. > I haven't heard very much about MySQL, but from I've read on the web I > think MySQL is Unix/Linux orientated and works well with PHP. > > I'm going to use a NT platform, with the IIS as web server, and I > wanted to use ASP. Does MySQL fit good with IIS and ASP? > > Thaks. > > ___ > Consigue tu e-mail gratuito TERRA.ES > Haz clic en http://www.terra.es/correo/ > > > - > 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: Can some PLEASE tell me what this error means
ASP question... not MySQL (if I understand correctly...) But just do a replace... variabletoinsert = replace(thevariablecomingin,"'","\'") INSERT INTO ASP (title, description, code, user, email, date_created) VALUES ('title', 'description', '" & variabletoinsert & "', 'user', 'email', 'now') you could write a quick function that you could call at will... function fq(string) fq = replace(string,"'","\'") end function mystr = "insert into asp (blah,blah,blah) values ('" & fq(inblah) & "','" & fq(inbalh) & "','" & fq(inblah) & "')" conn.execute mystr - Original Message - From: "Deryck Henson" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, September 07, 2001 10:10 PM Subject: Re: Can some PLEASE tell me what this error means > Except the problem is, this is done through an Active Server Page (ASP). > The user does the inserting, I just use variables and insert them. > TRANSLATION:: I have no control over what goes in the database until it's > there. So how can it be changed in the connection or sending process? > > - Deryck H > - http://www.comp-u-exchange.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 > > > - 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 Advice
I am using ASP and MySQL and am very happy with the performance! If you are on a Windows box, and have IIS5, there is no reason not to use ASP and the MySQL/MyODBC set up... it really does work well... (you could, of course, install PHP on your Windows box... (www.php.net)... I do like PHP... and use it in certain circumstances)... really, in my opinion, both set-ups perform equally well... and it comes down to a C++ "feel" or a VB "feel" when you are scripting... John Shipp SmallTownWorld.com - Original Message - From: "Shaji Khan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 07, 2001 11:10 AM Subject: Please Advice > Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop > a shopping cart and other components of a full blown ecommerce site. Is this > a good choice for this kind of work or do you guys think some thing like SQL > Server and ASP is a better choice. > > Experienced users, please advice. > > Thanks for all the help. > > Khan > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > - > 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
Missing libmysqlclient.so.6
Hi: How I can install or copy mysqlclient.so.6 without reinstall?? I'm trying to execute PHP script (Phorummail) from shell, but I receive that this lib is missing. [root@corotu docs]# ./phorummail > > php: error in loading shared libraries: libmysqlclient.so.6: cannot open shared > > object file: No such file or directory I have MySQL 3.27.23, PHP 4.0.6 and Red Hat Linux 6.0 Thanks for your help. Peter Brumvig - 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 without taking all items
Hi I am trying to write a query that pulls all the items from a database except two here is what I am using: $query = 'SELECT DISTINCT Type FROM Products WHERE Type != "System, Upgrade"'; This populates the drop down box with all including the System and Upgrade. What do I have to do to make this work? Thanks Kevin Internet Designer O'Dell Web Design http://www.odellwebdesign.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
Drop Down Boxes
HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design http://www.odellwebdesign.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
New member question
I have just subscribed to this list, so forgive me if my question has been answered many times before but I was not sure where else to find this information. I am new to mysql and am going to be using it on a website that I maintain. My question is, is there a program/utility or easy way to convert an MS Access database to mysql format? Thanks, Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01 - 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
Cobalt raq4 and mysql
Hi all, I'm looking for a beginners resource for working with Mysql on a raq4 linuxbox. Any suggestions? Bye, Patje... Behandel mij met zachtheid, ik ben een overlevende van het vorige millennium! Handle with care, I'm a survivor of the previous millennium! - 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 to round
> >How to round the result number after the multiplication, >below are the PHP codes, > >any help greatly appreciated > > > > >If (@$rcurr =="") >{ echo (""); > >?> > >while ( $row = mysql_fetch_array($result) ) >{ echo(""); >echo("" . $row["Room_Category"] . ""); >echo("" . $row["Room_Size"] . ""); >echo("" . $row["xsp"] . ""); >echo("" . $row["xan"] . ""); >echo(""); > >} >echo(""); > >?> >} >else >{ >?> >while ( $row = mysql_fetch_array($result) ) > >{ echo(""); >echo("" . $row["Room_Category"] . ""); >echo("" . $row["Room_Size"] . ""); >echo("" . $row["xsp"]*$rcurr . ""); >echo("" . $row["xan"]*$rcurr . ""); >echo(""); > >} >echo(""); > >} > > >?> > > - 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 to ROUND numbers
How to round the result number after the multiplication, below are the PHP codes, any help greatly appreciated "); echo("" . $row["Room_Category"] . ""); echo("" . $row["Room_Size"] . ""); echo("" . $row["xsp"] . ""); echo("" . $row["xan"] . ""); echo(""); } echo(""); ?> "); echo("" . $row["Room_Category"] . ""); echo("" . $row["Room_Size"] . ""); echo("" . $row["xsp"]*$rcurr . ""); echo("" . $row["xan"]*$rcurr . ""); echo(""); } echo(""); } ?> - 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
encrition /security
I have a customer who needs to have a very secure site, more secure than usual, he thinks that having a secure server is not enough so what kind of security for his transactions can I offer him? we are not talking about money transfers, his bussines is not about money is about information, I need to implement for him a very secure way in wich the infromatino inserted in to a database (oracle) be encripted, wheren can I get info about this= cheers Ps my customer in in europe, cheers - 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
Challenging SQL Problem
Hello, I am having a lot of trouble trying to find the best way to write the SQL to do the following: I have a table called "referrals." In this table I have a column called "ref." The data in the ref column are of the form "p/$promo_id/$date". An example would be "p/26/20010629" which says promotion number 29 occuring on June 29th 2001. My task is to find a way to do a group by of all the promotion IDs within a certain date range. The following code is INCORRECT (BETWEEN 'p/%/2001...' IS NOT VALID), but gives a good picture of what I am trying to do: SELECT ref,SUM(clicks) AS num_clicks FROM referrals WHERE ref BETWEEN 'p/%/20010601' AND 'p/%/20010630' GROUP BY ref The code above is meant to do a group by of all the clicks generated by each promotion occuring between June 1 and June 30 I realize that I could hypothetically loop over each promotional ID and do ref BETWEEN 'p/3/XXX' AND 'p/3/YYY',,p/888/XXX AND p/888/YYY', but this method is very bad in performance when the promotion IDS goes into the tens of thousands, so the GROUP BY is important to keep for me. Is there a way to account for the date range WITHOUT having to create a new date column which copies the date over from ref codes in the column ref? My Best Wishes. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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
Question about weird filenames...
I have weis in my mysql data directory, and I was hoping someone could tell me what they were... I understand that most tables will have 3 files associated with them (in my mysql setup anyway): .ISM, .ISD and .frm files. However, I have files like this in my directory: B-431a.ISM, B-431a.ISD, B-431a.frm.. The problem is : I have no tables named "B-431a" in my schema. Anyone have an idea of what those files are ?
Clarification wanted
Hi, We are developing a portal which has pictures of machines in the form of HTML pages. I want to know whether I can store HTML in Database & can I do search in the HTML pages stored. Please let me know at the earliest. Thanks in advance Infiniti. Infotech India Powered by MediaRing
setting an index
I'm not sure if an index would help me or not in this case.. and not sure how to set one at creation. So I'll explain it all My main select is select * from on_db where time>$t_tim ORDER BY place DESC I also run the query select * from on_db where time>$t_tim AND place='thisplace' $t_tim is the current unix time -5 mins the updates are simply update on_db set time='$time',place='$place' where person='$person'; as you can see by the table below 'person' is the primary key so is indexed this table is updated nearly every second and 'time' is the unix time input so is very possible to get same results so cannot make that unique nor 'place' unique.. mysql> describe on_db; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | person | char(50) | | PRI | | | | time | int(20) | | | 0 | | | place | char(50) | | | | | ++--+--+-+-+---+ 3 rows in set (0.02 sec) this is the command i used to create the table; CREATE TABLE on_db ( person char(50) DEFAULT '' NOT NULL, time int(20) DEFAULT '0' NOT NULL, place char(50) DEFAULT '' NOT NULL, PRIMARY KEY (handle), UNIQUE id (handle) ); what would be the syntax used to create indexes for time and place at table creation? I looked through the docs but it seemed a bit confussing and since this is a production system i didnt want to just guess. Also, will the index help or hurt since the time and place keys are updated constantly is there and advantage or do you think it would be a waste of time. The table itself usually ends up with around 15,000 entries which constantly update based on the person and the time and place they are. any thoughts are welcomed. -- Sign up for your free AngelHaven E-mail Today... Join the growing community, http://www.AngelHaven.com Come Cruisin with the Angels http://www.AngelCruise.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
sql manual
is there any sql manaual over the internet0' no matter that is not a mysql specificly, I would like to have a good manual for beguiners, cheers - 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 Problem
Hi Here is my my.cnf. pls suggest the changes to make the performance better. I am upgrading to the latest version. === # Example mysql config file. # You can copy this to one of: # /usr/local/mysql/etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=8M set-variable= back_log=25 set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= max_connections=50 set-variable= table_cache=32 set-variable= sort_buffer=500K set-variable= record_buffer=100K set-variable= net_buffer=5K # Start logging log [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=16M = with best wishes Arun Date sent: Sun, 13 May 2001 18:41:50 -0700 From: Jeremy Zawodny <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Subject:Re: Mysql Problem Send reply to: [EMAIL PROTECTED] > On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote: > > > > I am facing great problems beacuse of Mysql server which is not able > > to take load. > > > > My apache is working fine even when the load average shoots of to > > 130 but my mysql server goes sleep when the load of apache shoots > > above 30. I am on a dedicated server. > > > > My Mysql Ver 3.22.32 > > You may try upgrading to 3.23.xx. There were some performance > improvements in the newer versions. > > > I have red hat linux 6.2 as OS and memory of 256 MB . > > > > I am attaching my my.cnf file , pls look into it and suggest ways > > for improving my server performance. > > Attachements are filtered by this list, in case you didn't notice. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 > > MySQL 3.23.29: up 130 days, processed 804,119,056 queries (71/sec. avg) > - 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 Problem
Hi I am facing great problems beacuse of Mysql server which is not able to take load. My apache is working fine even when the load average shoots of to 130 but my mysql server goes sleep when the load of apache shoots above 30. I am on a dedicated server. My Mysql Ver 3.22.32 I have red hat linux 6.2 as OS and memory of 256 MB . I am attaching my my.cnf file , pls look into it and suggest ways for improving my server performance. I greatly depend on Mysql for efficient running of my site Hoping to hear from you all and thanks in advance for your support with best wishes Arun - 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: SQL help
i dont follow step #3. At 11:42 PM 5/8/2001, Tony Shiu wrote: >i think it is more suitable to do it in programming level in mysql, though I >know there is a function is M$sql server. > >if your table schema has a unique id field, before submit a query to DB, >1) select count(*) from it >2) from the above resultset, program to draw whatever number of records you >want. >3) submit the query, select * from it where id in (your random record ids); > > >- Original Message - >From: "Webmaster" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, May 09, 2001 11:38 AM >Subject: SQL help > > >> How do I write SQL in MySQL to randomly select 5 records from 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 > > >- >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
SQL help
How do I write SQL in MySQL to randomly select 5 records from 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: database problems
I have a similar problem to this.. What happens is somehow something is causing mysql to hang which forces it to reach max connections.. if i shutdown and restart mysql using safe_mysqld --skip=networking it starts fine.. will do selects fine but not inserts because the tables that were being inserted to while the hang caught have become currupted.. I shutdown mysql, myisamchk -r the tables, it reports the tables were fixed. I then restart mysql and when trying to insert into the fixed table it just hangs forever.. if i do a drop on the table and recreate it it goes back to working fine.. so it seems the myisamchk is not fixing the tables.. any clues? -- Webmaster AngelHaven.com Gerald Clark wrote: > > Shut down the server before repairing tables. > > Robert Clugston wrote: > > > List, > > I'm having some serious problems with MySQL. I have some PHP and perl > > scripts that do INSERTs into MySQL. Multiple times during the day various > > tables become corrupted. > > Repairing the table using myisamchk with "-r" usually fixes the problem, > > but sometimes I have to restart mysqld to get things working again. Any > > ideas as to what is going on or how to fix this? > > > > /var/site/mysql/libexec/mysqld -V > > /var/site/mysql/libexec/mysqld Ver 3.23.36 for unknown-openbsd2.7 on i386 > > /var/site/mysql/bin/myisamchk: ISAM file > > /var/site/mysql/var/MailingList/MailingList.MYI > > /var/site/mysql/bin/myisamchk: error: Size of datafile is: 280400 Should be: > > 281328 > > /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to > > record outside datafile > > /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4723 Should > > be: 4738 > > /var/site/mysql/bin/myisamchk: warning: Found 4723 parts Should be: 4738 > > parts > > MyISAM-table '/var/site/mysql/var/MailingList/MailingList.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > /var/site/mysql/bin/myisamchk: ISAM file > > /var/site/mysql/var/bob/announcements_mailinglist.MYI > > /var/site/mysql/bin/myisamchk: error: Size of datafile is: 203460 Should be: > > 204312 > > /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to > > record outside datafile > > /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4783 Should > > be: 4804 > > /var/site/mysql/bin/myisamchk: warning: Found 4783 parts Should be: 4804 > > parts > > MyISAM-table '/var/site/mysql/var/bob/announcements_mailinglist.MYI' is > > corrupted > > Fix it using switch "-r" or "-o" > > /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/contest.MYI > > /var/site/mysql/bin/myisamchk: error: Size of datafile is: 195772 Should be: > > 196040 > > /var/site/mysql/bin/myisamchk: error: Found key at page 35840 that points to > > record outside datafile > > /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4358 Should > > be: 4364 > > /var/site/mysql/bin/myisamchk: warning: Found 4358 parts Should be: 4364 par > > ts > > MyISAM-table '/var/site/mysql/var/bob/contest.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > /var/site/mysql/bin/myisamchk: MyISAM file > > /var/site/mysql/var/bob/bob_eval.MYI > > /var/site/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed > > the table properly > > /var/site/mysql/bin/myisamchk: error: Size of datafile is: 3276 Should be: > > 3344 > > /var/site/mysql/bin/myisamchk: error: Found key at page 1024 that points to > > record outside datafile > > /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 96 Should > > be: 98 > > /var/site/mysql/bin/myisamchk: warning: Found 96 parts Should be: 98 parts > > MyISAM-table '/var/site/mysql/var/bob/bob_eval.MYI' is corrupted > > Fix it using switch "-r" or "-o" > > > > > > > > - > > 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 > > -- > Gerald L. Clark > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (
Ever heard of anything like this?
I can't connect to my database via mysql This is the load of crap I'm getting... I would appreciate any input or feedback you have. We are on a virtual server..we set up with this company AITcom.net to be resellers. First of all we are getting this error message when we try to connect to the database. Can't connect to local MySQL server through socket '/tmp/mysql.sock' Here is their version of an answer to my problem I wanted to get back to you as soon as possible with an answer. Here is what I found. The Pearl modules will not run in a change root file system. The user name that is being called does not exist on your server. Also, there may be a problem with the version of Pearl being used. The only solution is to have a dedicated server where you have root access to the box. Our shared hosting solution is designed for a virtual server using a proprietary Linux operating system. With a dedicated server, you can have any version of Linux you would like and any version of Pearl. This would allow you full control over the server and as you have stated this works on every other server you have installed. I know this has been a frustrating time for you and I would like to offer a solution. I will transfer all monies paid to AIT over to the cost of a dedicated server 4. If this solution is acceptable, please let me know and I will have the necessary paper work sent to you. I look forward to your response. Our people are saying that the solution is this... > > > > Tony, > > > > > > > > If your still getting the .sock error, ask your ISP to > > > > recompile DBD::mysql on the server... > > > > > > > > There is NO configuration within our programs that > > > > interacts with DBD::mysql in any way that can cause or > > > > effect that error. When DBD::mysql is compiled (installed), > > > > it makes a note of where MySQL is and always referrs > > > > back to that note for connecting. If its not connecting, its > > > > likely that DBD::mysql was either installed from RPM or > > > > binaries or copied from another server rather then actually > > > > compiled on that one, OR, the MySQL server has been > > > > moved, changed, upgraded, or otherwise. Help! Please! Anthony Giuliani Director of Operations 21st Century Marketing & Training Solutions, Inc. [EMAIL PROTECTED] voice...407-831-8722
INSERT PROBLEM
Hello all I am running linux mandrake with Mysql vers 3.23.23-beta, for pc-linux-gnu on i686 I've had a problem with recieving to many connections which i am working on but my MAIN problem currently is that it will not allow me to insert into tables. I cleared out all the connections and can query the database and recieve the answers.. but when i do a standard insert into one of the tables it just seems to hang there.. its like it catches a lock or something. This is an old table and these are the same query's its been using for over a year.. other then fixing the table with myisamchk nothing has changed. The table needed to be fixed due to the too many connections error which currupted it appearantly. Any idea's why it would be hanging on an insert statement? Ter -- Join the growing community of AngelHaven.com. Sign up for your free AngelHaven E-mail Today... Visit us at http://www.AngelHaven.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
MYSQL Problem
Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. Under this circumstances MYSQL failed to respond or get hanged. We have to restart MYSQL then. We are on a dedicated server with 256 MB of RAM and 10 GB disk space. We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address [EMAIL PROTECTED] Best Wishes, The Development Team http://www.gcards.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
MySQLGui for macintosh?
Hi! I am currently building a web site for Sciences-Espace. We work on macintosh computers. I found a version of MySQL for mac but not the MySQLGui (the API), or MyODBC. Please tell if a version for mac exists and how I can get it. Sincerely, SCRIPT - 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
URGENT - daemon dying frequently
Running mysql 3.22.32-log on Apache virtual server (FreeBSD) I can restart my mysql daemon with ./bin/safe_mysqld - but it only runs for a few hours before dying. Following hints from both the manual and the list, I've tried several things... I've deleted my mysql database and manually re-installed all the tables (instead of using the mysql_install_db script which wanted me to do a make compile) I've looked at the error log, and see nothing that shows why it is dying ( though when it starts it does have two messages - could they be related?) Warning: setrlimit couldn't increase number of open files to more than 164 Warning: Changed limits: max_connections: 30 table_cache: 62 I've had the logging on but see no queries that should be the problem. Nothing in the cron file Any suggestions? - 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
Double your website traffic
Do you want to double the number of visitors to your homepage everyday? The perfect solution is PopUp Window Exchange! It's a brand new concept from LinkExchange. It will pop up websites instead of traditional banners. As a result, it can bring you REAL web traffic instead of raw banner impressions which do not give you unique hits. Here is how it works. Let's assume your website currently has 100 visitors daily. If you join our free popup exchange, 30 days later, your website can have up to 100*(1+50%)**30days=19175105 visitors/day! The above calculation is very simple. Since every member needs to insert a simple HTML code in their homepage, when other website pops up in your homepage, your homepage will also popup in a member's website. Essentially giving you a free visitor everytime someone visits your page. If you used to have 1 visitor, now you will have 2 (The 2nd visitor is brought to you by other members) More Information can be found at.. http://GoPopUp.com - [EMAIL PROTECTED] http://GoPopUp.com To be removed from our mailing list -> http://gopopup.com/unsubscrib.php?[EMAIL PROTECTED] ---Chinese-Big5 ·Q§ó¦h¤Hª¾¹D§Aªººô¯¸¶Ü¡S §ÚÌ¥i¥HÀ°§A¨C¤Ñ±N§Aªººô¯¸¤H¼Æ¼W¥[Âù¿. °²¦p§A¨C¤Ñ²{¦³100Ó³X«È, ¦pªG§A¥[¤JPopUp Exchange, 30¤Ñ«á¡M §Aªººô¯¸±N·|¦³19175105Ó³X«È. 100 * (1 + 50%) ** 30 days = 19175105 vistors/day PopUp Exchange ªº¹B§@«D±`²³æ¡C ¨C¦W¦¨û¥u»Ý¦b¥Lªººô¯¸¤¤¥[¤J ¤@¬qPopUp HTML_CODE¡C ³o´N¬O»¡, ·í¨ä¥¦·|ûªººô¶¦b§Aªººô¯¸¤¤ PopUp¤@¦¸¡M ¦P¼Ë¦a¡M §Aªººô¶¤]·|¦b¨ä¥¦·|ûªººô¯¸¤¤PopUp¤@¦¸¡C ´N¬O»¡, ¦pªG§A¦³¤@Ó³X«È¡M ´NÅܦ¨ÇÓ¡C ¥t¥~¡M PopUp¤£·|¼vÅT³X«È°ÑÆ[§Aªººô¯¸¡C¼u¥Xµ¡¤fÅã¥Ü¤_§A즳µ¡¤fªº©³³¡¡C ½Ð¨ì¥H¤Uºô§}¥[¤J http://GoPopUp.com/chinese.php [EMAIL PROTECTED] http://GoPopUp.com ¨ú®ø¹q¤l³ø¡H -> http://gopopup.com/unsubscrib.php?[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
Too Many Connections
I have been on occasion recieving "Too Many Connections" errors which lock up mysql.. I know i can set the connections in my.cnf.. atleast thats what i've seen on this listover the past few months.. For starters.. i dont seem to have a my.cnf according to mysqladmin Default options are read from the following files in the given order: /etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf None of these files excist so am assuming its running at the defualt 100 connections. My main concern is I should never currently be near 100 simultanious connections. When all is running well i show maybe 5-15 tops since most connections are processed then dropped. My thoughts are someone was purposely trying to take up all connections. This happened 4 times in a day and a half.. I only access mysql through php so decided to start safe_mysqld with --skip-networking This seemed to help.. as i didnt have any trouble for over a week after.. but then it did happen again. and once more a couple days later. Also.. the last time it happened I couldnt even get into mysql at all from the command line and I believe 1 connection is always left open for just that purpose. I also had a problem because in order to solve the too many connections I was forced to do a mysqladmin shutdown.. This messed up all my auto-increments on all tables tat were in use at the time of the problem and caused duplicate entry errors forcing me to dump and remake the tables to correct the problem.. I am running 3.23.23-beta, for pc-linux-gnu on i686 Any thoughts. idea's, help on how i could correct the problem or fix it if it happens again without dropping all messed up tables would be appreciated. Also.. I imagine I should put a my.cnf file in.. I havnt checked the mysql site yet to see if they have example my.cnf but if someone could possibly lead me that way i'd appreciate it (but not important since i myself havnt looked) Ter -- Join the growing community of AngelHaven.com. Sign up for your free AngelHaven E-mail Today... Visit us at http://www.AngelHaven.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
mysql error
I have suse linux 7.1, I installed mysql and php, I tyr to connect to the database and I get a socket error why? is there any kind of special confg? I type mysql on a terminal window and get the error msg, cheers - 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