RE: MySQL 4.0.18 has been released
Hi, Can anyone tell where to find documentation on myisam_ftdump? I would like to know what myisam_ftdump is and how it differs from mysqldump. John -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 4:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySQL 4.0.18 has been released -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.18, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site. This is a bugfix release for the current production version. Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version. News from the ChangeLog: Functionality added or changed: * Fixed processing of `LOAD DATA' by `mysqlbinlog' in remote mode. (Bug #1378) * New utility program `myisam_ftdump' was added to binary distributions. * `mysqlhotcopy' now works on NetWare. * `ENGINE' is now a synonym for the `TYPE' option for `CREATE TABLE' and `ALTER TABLE'. * `lower_case_table_names' system variable now can take a value of `2', to store table names in mixed case on case-insensitive filesystems. * For replication of `HEAP' tables: Made the master automatically write a `DELETE FROM' statement to its binary log when a `HEAP' table is opened for the first time since master's startup. This is for the case where the slave has replicated a non-empty `HEAP' table, then the master is shut down and restarted: the table is now empty on master; the `DELETE FROM' empties it on slave too. Note that even with this fix, between the master's restart and the first use of the table on master, the slave still has out-of-date data in the table. But if you use the `init-file' option to populate the `HEAP' table on the master at startup, it ensures that the failing time interval is zero. (Bug #2477) * Optimizer is now better tuned for the case where the first used key part (of many) is a constant. (Bug #1679) * Removed old non-working `--old-rpl-compat' server option, which was a holdover from the very first 4.0.x versions. (Bug #2428) Bugs fixed: * Fixed bug when -init-file crashes MySQL if contains large select (Bug #2526) * `SHOW KEYS' now shows `NULL' in `Sub_part' column for `FULLTEXT' indexes. * The size of the signal thread's stack was increased to enable `mysqld' to run on Debian/ia64 with a TLS-enabled glibc. (Bug #2599) * Now one need only `SELECT' privilege for tables that are only read in `UPDATE' statements with many tables. (Bug #2377). * Give proper error message if one uses `LOCK TABLES ... ; INSERT ... SELECT' and one used the same table in the `INSERT' and `SELECT' part. (Bug #2296) * `SELECT INTO ... DUMPFILE' now deletes the generated file on error. * Fixed foreign key reference handling to allow references to column names that contain spaces. (Bug #1725) * Fixed problem with index reads on character fields with `BDB' tables. The symptom was that data could be returned in wrong lettercase. (Bug #2509) * Fixed a spurious table corruption problem that could sometimes appear on tables with indexed `TEXT' columns if these columns happened to contain values having trailing spaces. This bug was introduced in 4.0.17. * Fixed a problem where some queries could hang if a condition like `indexed_TEXT_column = expr' was present and the column contained values having trailing spaces. This bug was introduced in 4.0.17. * Fixed a bug that could cause incorrect results from a query that involved range conditions on indexed `TEXT' columns that happened to contain values having trailing spaces. This bug was introduced in 4.0.17. (Bug #2295) * Fixed incorrect path names in some of the manual pages. (Bug #2270) * Fixed spurious table corrupted errors in parallel repair operations. *Note `myisam_repair_threads': SHOW VARIABLES. * Fixed a crashing bug in parallel repair operations. *Note `myisam_repair_threads': SHOW VARIABLES. * Fixed bug in updating `MyISAM' tables for `BLOB' values longer than 16M. (Bug #2159) * Fixed bug in `mysqld_safe' when running multiple instances of MySQL. (Bug #2114) * Fixed a bug in using `HANDLER' statement with tables not from a current database. (Bug #2304) * Fix for a crashing bug that occurred due to the fact that multiple-table `UPDATE' statements did not check that
RE: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?
Ask the person who gave you the file to do the work. Give them a list of formats you can read (i.e. SQL, csv, etc.) and let them decide which of those formats they want to export into. John -Original Message- From: Mark Graves [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL? ..I don't have MSSQL Zenzo [EMAIL PROTECTED] 12/5/2003 2:30:44 PM there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves [EMAIL PROTECTED] wrote: I run a website using MySQL, PHP, and CFMX. Someone recently gave a data file to me that they'd like to access. The problem is that it appears to be from MS SQL. How can I convert/import this into MySQL? I did some searching and found MSSQL-to-MySQL, but this program requires that I have MSSQL server, which I don't. Any help would be appreciated. mg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New Microsoft Critical Patch
Can we do anything about these? I am getting several ofthem a day. -Original Message-From: Microsoft Corporation Technical Services [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 11:07 AMTo: ConsumerSubject: New Microsoft Critical Patch Microsoft All Products| Support| Search| Microsoft.com Guide Microsoft Home Microsoft Consumerthis is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the most serious of which could allow an attacker to run code on your system. This update includes the functionality of all previously released patches. System requirements Windows 95/98/Me/2000/NT/XP This update applies to MS Internet Explorer, version 4.01 and laterMS Outlook, version 8.00 and laterMS Outlook Express, version 4.01 and later Recommendation Customers should install the patch at the earliest opportunity. How to install Run attached file. Choose Yes on displayed dialog box. How to use You don't need to do anything after installing this item. Microsoft Product Support Services and Knowledge Base articles can be found on the Microsoft Technical Support web site. For security-related information about Microsoft products, please visit the Microsoft Security Advisor web site, or Contact Us. Thank you for using Microsoft products.Please do not reply to this message. It was sent from an unmonitored e-mail address and we are unable to respond to any replies. The names of the actual companies and products mentioned herein are the trademarks of their respective owners. Contact Us | Legal | TRUSTe ©2003 Microsoft Corporation. All rights reserved. Terms of Use | Privacy Statement| Accessibility
RE: New Microsoft Critical Patch
Okay, let me ask a slightly different question. I am getting several of these Microsoft emails every day and I think that they are coming via this list. Is anyone else having similar problems or am I following a red herring? John -Original Message- From: B. van Ouwerkerk [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:17 AM To: John Griffin Subject: RE: New Microsoft Critical Patch Yes. Stop using email :-) or use procmail to send them to a safe place.. I don't really understand why you send this to a MySQL list.. B. At 11:11 04-12-2003 -0500, John Griffin wrote: Can we do anything about these? I am getting several of them a day. -Original Message- From: Microsoft Corporation Technical Services [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:07 AM To: Consumer Subject: New Microsoft Critical Patch SNIP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql disaster recovery
Hi Andrew, I am not a Guru. I would suggest that you look at MySQL's excellent replication facility rather than NFS mount a drive. Having your data on an NFS mounted drive will significantly degrade the performance of your database. Replication will not. John Griffin -Original Message- From: Andrew Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 4:51 PM To: [EMAIL PROTECTED] Subject: mysql disaster recovery Greetings Gurus, I have a mysql server that I need to create a disaster recovery system for. What I am planning on doing is putting the data dir on a NFS mounted directory so that I can start mysql on either of two servers in case one dies. The inbound connections would be load balanced in a fail over scenario, so the IP that clients will connect to will be on the load balancer. I'm wondering if there is anything already developed that would test mysql on the primary server, and if its not functioning, kill any remaining mysql processes if necessary, and start it on the secondary. This logic seems to be the biggest problem. Any suggestions, or other methodologies to implement this would be welcome. Thank you for your time in advance, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Export in XML
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay Blanchard Cc: [EMAIL PROTECTED] Subject: RE: Export in XML I think that to answer Todd's question, no there is no inherent way in MySQL to export results as XML the way that sqlserver and oracle do. Another solution that comes to mind (if you're using java) is to write a simple class that converts a result set to an array of hashmaps (row in array is row of data, hashmap for column name - data value mapping), then send that to either castor (pre-java 1.4) or to the xml- object APIs (1.4 on). -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: Monday, December 01, 2003 9:48 AM To: Jay Blanchard Cc: [EMAIL PROTECTED] Subject: Re: Export in XML Jay - I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. Todd Jay Blanchard wrote: [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little more complex than this. How much do you know about XML? -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL on Win32 vs Linux ?
I have been developing with Windows2000, Apache, MySQL and PHP (WAMP ?) platform for about two years now and have had no problems. However, I have been deploying onto a Linux server so my observations may not be valid for your purposes. John Griffin -Original Message- From: Paul Fine [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: MySQL on Win32 vs Linux ? Greetings. Can anyone comment on the stability of MySQL on Win32? Unfortunately I may have to use IIS for a project and am just wandering if I can expect the same sort of stability and performance using MySQL (and PHP) on a Windows Server. Thanks for any advice! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: periodic corruption problem
I had a similar problem with an Oracle database once. It turned out to be some memory in the process of going bad. John -Original Message- From: Jon Wagoner [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 2:24 PM To: [EMAIL PROTECTED] Subject: RE: periodic corruption problem It's been going on for months, so that doesn't seem very likely. On the other hand, we have had 2 or 3 other hard drives go bad with other servers at this host, so I'm not ruling it out. -Original Message- From: Big Brother [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:04 PM To: Jon Wagoner Cc: [EMAIL PROTECTED] Subject: Re: periodic corruption problem my experience with corrupted tables is usually followed by a failed harddrive aka the disk may be diing ... -- Quoting Jon Wagoner [EMAIL PROTECTED]: I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems with tables periodically getting corrupted. The one it happens most often on is a table I use for logging various status messages. This table receives mostly inserts, and very few selects. It is about 400MB in size, with about 1.3M rows. I just had it happen to another table, that receives mostly selects, and few inserts or updates. It is only about 60MB in size, with about 95k rows. Both of these tables rarely have deletes. The last time, I believe the error message said something about the index being the wrong size. Sorry I didn't write it down, but I was in a hurry to get things working again. Can anyone provide some help on this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Need help comparing MySQL to MS SQL Server
What about MySQL-max/SAPDB? I believe that it was completely omitted in the consultants report but has many of the features you need. I would also like to ask a question; do you need stored procedures, triggers or views for your application? There are a number of high volume, high quality sites that do very nicely without them. Why are you different? John Griffin -Original Message- From: KEVIN ZEMBOWER [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 1:53 PM To: [EMAIL PROTECTED] Subject: Re: Need help comparing MySQL to MS SQL Server Nestor, thanks for your question. The platform will actually be dictated by the SQL engine, not the other way around, which is more typically the case. If we go with MS SQL Server, we'll build a separate host, NT I would guess, to host it. I'm only responsible for Unix and Linux boxes here, so it'll be the responsibility of another group. If we go with MySQL or PostgreSQL (the only databases I have any familiarity with), I'll probably be responsible for setting up and configuring a new Linux (Debian) host, and maintaining it. The in-house database administer would be the administrator, and I would just offer any help that I could, which might not be much. Thanks, again, for writing. -Kevin Nestor Florez [EMAIL PROTECTED] 11/07/03 01:18PM I have not work with it but postgres is supposed to work great in /BSD/Linux/Unix/solaris environment Which platform are you using? :-) Nestor A. Florez Martijn Tonies [EMAIL PROTECTED] 11/7/2003 10:08:53 AM Hi Kevin, Martijn, thank you very much for your analysis. I hope others will continue to join in. So do I :-) With regard to your point quoted below, are you referring to PostgreSQL, and would that be a stronger competitor to MS SQL Server 2000 than either the current version of MySQL or MySQL 5? I have no experience with PostgreSQL - although, from what I've heard and read, it's quite capable - but not easy to get going on Windows. One other open source RDBMS would be Firebird - see www.firebirdsql.org Especially the newer release (1.5). Don't get fooled by that version number - it's a fork of the Borland InterBase code, which has been around for about 20 years now. I'm looking forward to MySQL5 to see what's new and how it's implemented. As for what engine would be the best for you - it all depends on what you're going to do. For example, I frequently use triggers and check constraints in my database applications, with MySQL, I can't do this. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Foreigner keys in MySQL?
Hi Martijn, With respect, I must disagree with your assertion that MySQL is not a relational database. I did a Google on definition of a relational database and found a good definition at http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci212885,00.html. If you read this you will find that MySQL fits this definition nicely. John Griffin -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 11:11 AM To: [EMAIL PROTECTED] Subject: Re: Foreigner keys in MySQL? Nevertheless, I received the information that MySQL don't support relacional functions between tables of the same database. I'm not sure about this, and I'd like to confirm this information. Does MySQL allow relacionl functions between tables recognizing foreign keys? Excuse me for asking a so simple question, If you are trying to determine whether MySQL is a relational database, the answer is yes. Ehm... the answer is no. It's getting better, that's for sure. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Slow results with simple, well-indexed query
Can you post your DDL to go along with your DML? -Original Message- From: Allen Weeks [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:51 PM To: Jesse Sheidlower; Cybot Cc: [EMAIL PROTECTED] Subject: RE: Slow results with simple, well-indexed query The only thing I can add is check you hardware and OS platform. Cheers -Original Message- From: Jesse Sheidlower [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:44 AM To: Cybot Cc: [EMAIL PROTECTED] Subject: Re: Slow results with simple, well-indexed query On Thu, Aug 21, 2003 at 06:01:31PM +0200, Cybot wrote: Jesse Sheidlower wrote: I'm struggling with speed issues on some queries that I would have expected to be relatively fast. Perhaps even more frustratingly, when I've tried to break these down into their components, they still execute very slowly. I've looked over all the relevant suggestions for optimization and so forth, and there's nothing I can tell that I'm missing. An example of a query is to get all the words (the cg.cw field) in a particular alphabetical range that have been added in some timespan (the sref.cd field). The cg table has about 3M rows, and the sref table about 70,000; the intervening tables are all indexed on the relevant id fields: - mysql SELECT cg.cw FROM cg,q,cit,sref - WHERE cg.q_id = q.id AND q.cit_id = cit.id AND cit.sref_id = sref.id - AND cg.cw BETWEEN 't' AND 'tzzz' - AND sref.cd DATE_SUB(CURDATE(), INTERVAL 6 MONTH) move your DATE before cw AND sref.cd DATE_SUB(CURDATE(), INTERVAL 6 MONTH) AND cg.cw BETWEEN 't' AND 'tzzz' cause sref.cd DATE_SUB(CURDATE(), INTERVAL 6 MONTH) should be faster than cg.cw BETWEEN 't' AND 'tzzz' and so the total rows are already limited when cg.cw BETWEEN 't' AND 'tzzz' will be executed I assume that the optimizer would take care of this, but in any case I gave it a try and it made no difference. also you can try an index with a length of 2 or 3 over cg.cw, this will result in smaller index and possible speed up things I also tried this (the current index is 25 characters on a 100-character field), and if anything it made things slower. Anyone have any other ideas or analysis? Thanks very much. Jesse Sheidlower -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: array/pointer question
Hi, MySQL, like other relational databases, does not support arrays or pointers. Arrays and pointers do not fit within the relational model. It would take quite a bit of text to describe what the relational model is and how to use SQL to manipulate data. I suggest that you read a good text on relational databases and the relational model first suggested by Dr. Codd and then come back and ask questions. Anyone on this list would be happy to answer them. Anybody got any good titles or URLs for Ioana? John Griffin -Original Message- From: Ioana [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 10:50 AM To: [EMAIL PROTECTED] Subject: array/pointer question Hello, I have just recently started learning mysql, and was wondering if it supports arrays/pointers(for linked lists) of any types, and if so, what is the syntax... could not find info on this in any manual. Thank you! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Duplicate records
Hello Steve, Do a select on the record before you insert it. If the record does not exist in the database (i.e. mysql_num_rows () == 0) than it is safe to do the insert. John -Original Message- From: Steve Marquez [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:41 PM To: MySQL List Cc: PHP eMail List Subject: Duplicate records Hello. I am adding a record to a MySQL Database using PHP. I have the records listed by the field: $id_num. I want the DB to be updated only with new id numbers, and return an error if there is a duplicate number already in the DB. Here is the code I am using: ?php $insert_data = INSERT into articles Values ( 'a href=\upload_form.php?id_num=$id_num\edit/a', 'a href=\delete.php?id_num=$id_num\delete/a', '$id_num', '$title', '$author', '$article_contents', '$start_date', '' );; $response = mysql_query( $insert_data, $dbh ); $get_table_data = SELECT * FROM ccfs; $response = mysql_query( $get_table_data, $dbh ); ? Can anyone help me? Hope this makes sense. Thanks! Steve Marquez Marquez Design [EMAIL PROTECTED] www.marquez-design.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copying
Hi Darryl, Why not use mysqldump --no-data [database] [table1] [table2] ... John Griffin -Original Message- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:49 AM To: [EMAIL PROTECTED] Subject: copying Greetings, in my last email nobody tackled the schema copy issue. Here is what I need to do: I have a live database that contains several tables. I need to create a history database with the same tables (without the data). I would like to do this without manually creating all the tables in the history db. Is there a more automated way to do this? thanks in advance, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Suggestions for choosing GUI Language that has a MySQL DB backend
Hi David, check out http://gtk.php.net/ It is a GUI toolkit with a PHP interface to allow you to build client applications. John Griffin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:25 AM To: [EMAIL PROTECTED] Subject: Suggestions for choosing GUI Language that has a MySQL DB backend Hi MySQL Listers, I'm wondering if someone might provide some guidance about what programming language might best accomplish the following. I have been asked to write an interactive GUI program that allows for the display of results from related queries. For example, launching the application wil generate the first query, which will return a list of names of individuals. Selecting a name triggers another query that returns demographic information about that person and a list of their interests. Selecting an interest from the list triggers another query that returns a list of venues such as museums or restaurants where the person can explore that interest. And selecting the venue triggers a query that returns information such as driving directions or food menu. I have the MySQL database designed and tested, and the queries work as intended. Also, the load on mysqld will be limited, so performance is not a major issue. Unfortunately, my employer does not want a web-based solution, so PHP is out. And all the activity has to occur in various sections of a single screen. My apologies if I'm posting to the wrong list. But if someone has accomplished something similar to the above using a MySQL backend, I would appreciate any advice or direction that might be provided. Thank you for reading this post. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: fail-safe queries
Hi, I have two alternative suggestions. 1. Test your code. Simple test cases will ferret out these problems before they hit a production environment. 2. Peer review. Let someone else look at your code before you migrate it to a production environment. This, in my experience, is an effective way of finding logic errors in code. Please don't take these suggestions as sarcasm. Relying on your tools to catch anything other than syntax errors is a bad idea. It builds in a false sense of security. John Griffin -Original Message- From: Dave Dyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: fail-safe queries I'm a little concerned by the possibilty of a malformed query accidentally destroying a whole databse. For example, a badly constructed boolean, intended to select exactly one row, but which actually modifies all rows. update mytables set data='who' where row='1234'; (updates 1 row) verses update mytables set data='who where row=1234'; (damages all rows) The obvious answer is to use a LIMIT clause to limit the damage, but (1) there is still damagage (2) the LIMIT clause is as likely to be damaged as the WHERE. update mytables set data='who where row=1234' LIMIT 1; (damages 1 row, gives no indication of error. Better I suppose.) So my proposal is a FAIL IF rows1 type clause, which would be syntactically FIRST in the string, and so unlikely to be damaged by errors constructing a complex query. FAIL IF rows1 update mytables set data='who where row=1234'; (fails, damaging no rows.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PL/SQL, Views, Functions, Proceedures
Hi, PL/SQL is an Oracle proprietary language and can not be used. I know that the good people at MySQL are planning to add a language to MySQL but I do not think that there is a target release for this. Views, Functions and Procedures are also on the list of things to add to MySQL but I do not think that there is a timeline for these things. Adding anything to the execution path of an application, a database application for example, will naturally make it slower. That said, the people at MySQL have been very good at maintaining and in some cases improving the performance of the database so I would not worry about new features slowing the database. Hopefully someone from MySQL can also respond and give more information than I have. -Original Message- From: hemanth [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:40 AM To: [EMAIL PROTECTED] Subject: PL/SQL, Views, Functions, Proceedures Hi, Why MySQL does not support PL/SQL, Views, Functions, Procedures, Sub queries. Will that be added in forthcoming MySQL version. If it above mentioned features are added will the database becomes slow. Pls. give me some information on this issue. Thanks in Advance. HEMANTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Could we make this a web discussion forum?
Hi, I would like to add my 2 cents worth. First, I like having a mailing list. I do not post very frequently but I do like to scan the posts of others. It is a great way to learn little tricks and tips about MySQL. Second, I don't see why you can't have both a mailing list and an on-line forum. I have used FuseTalk in the past and I remember receiving email on threads that I was interested in so it is possible. So the data can be retrieved and stored via a mail interface and a Web interface. Third, this is a general comment. Don't spout off unless you are willing to help be part of the solution. Asking a question in the form of a complaint or a rant may make you feel good but it is generally not well received. That said, does anyone have any suggestions on how this forum could be made more accessible? The one that seems to be most prevalent at the moment is the Web interface. Keep in mind that the good people at MySQL suffer from the same time and financial constraints as you do so don't ask for the moon unless you are willing to help go and get it. All appropriately tagged rants accepted. John Griffin -Original Message- From: Seth Brundle [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:38 PM To: [EMAIL PROTECTED] Subject: Re: Could we make this a web discussion forum? First people, please dont get all angry about my suggestion...please hear me out... I really hate on-line forums. They're difficult to track because I must remember visit them daily. OK this is the first issue - 95% of people who need MySQL info do not need it daily. Mailing lists are a poor tool for them. And I can't use them while disconnected. H...seems like some Yahoo! employee has never used Yahoo! Groups ;) There is plenty of web discussion software (like Yahoo! Groups, although I'm not necessarily recommending that one) where you can still have all of the features of a mailing list, yet also have all the features of web discussion, so there really is no reason to have a mailing list only, except to be old-school. A web discussion board is a much more powerful and flexible tool for this type of community. Hmm. E-mail has been around for a long, long time. I'm skeptical of this claim. Just because its been around longer means its better? Or should never be augmented? I'm just saying that usenet groups and discussion forums solved the problem of belonging to too many mailing lists. If every package I used involved a mailing list for discussion, I would need to track about 40 of them. Right now the only mailing lists I really am stuck using is MySQL and ImageMagick. ImageMagick is the worst, as there is no archive (well, there are monthly gz's - big help - gah) and requires subscription. If you want to ask a single question, you are obliged to subscribe and suck down all the daily traffic (more traffic then MySQL) until your thread is dead. I guess my hatred for mailing groups has more to do with that list then this one. Every time I want to get involved I have to go figure out - OK, h trying to remember do I need to subscribe? Whats that process? Thread tracking, archiving, searching E-mail gives you all of those. Unless you have the entire history of the mailing list downloaded to your mail spool and have a very powerful, feature-rich, and most importatly very fast email search tool, you cant both search archives and post messages with the same piece of software. Email is ok for thread tracking if subject integrity is maintained, but most email clients cant reliably collapse and expand threads. Cant we convert this into a discussion board or better yet just make the usenet group mirror postable from google groups? I believe there is already a read-only NNTP mirror of this group. The NNTP mirror is actually a double-edged sword - yes it takes care of archiving and searching (via Google Groups), I will agree, but it misleads infrequent users into thinking posting actually does something meaningful. There are 4 lists like this one where I have to continuously subscribe and unsubscribe throughout the year when I want to participate. Why must you subscribe and unsubscribe to participate? There's no membership requirement to post here. And you can always read the messages on-line. There are at least 2 web archives of this group. You've seen those, right? I know that Google has. Sorry, I didnt realize that I didnt need to subscribe to post - but again, this is one of those rules for each mailing list that you must remember, which is a PIA. Yes, if you live here, it is not a problem of remembering, but 95% of people who use MySQL dont require that level of involvement. Also emails get mirrored on google groups for convenient spam harvesting - its really a pain in the butt. How would using a web forum help that? Because most modern web forum software has an option to hide your email address. Also a web forum has a lot of other
RE: mySQL on Windows 2000 Server
Hi, I have MySQL running on a machine at work and a (dev) machine at home. Both machines are running W2K. The machine at home is an old PIII with 256Meg of memory, the machine at work is a new P4 2.0GHz with 512Meg of memory. My home machine also has a heavier load relative to the CPU than my machine at work. However, my machine at home executes MySQL faster than my machine at work. In my case it is not the W2K environment itself that is the problem it is another component interfering with MySQL. I suggest that if you ever have problems with MySQL performance on W2K you look to see what you can uninstall as MySQL on W2K is not the issue. BTW, I eventually solved my problem at work by moving MySQL over to a Linux box. That actually gave me better performance than my W2K box at home. John Griffin -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 7:34 AM To: [EMAIL PROTECTED] Subject: re: mySQL on Windows 2000 Server On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Serial column type
Has anyone got a way to implement column type 'serial' in a innodb table? -jpg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InterBase vs. Mysql
Hello David, Since you were kind enough to clarify some matters on licensing I was hoping you would also be open to suggestions. Instead of charging a flat fee for each copy of MySQL that is resold why not charge a percentage up to a certain point. It might make it a bit easier for developers with inexpensive applications to choose your product. If I know that MySQL is going to be, for example, a constant ten percent of my sale cost I can price more competitively for the market. The is defiantly a boon for developers who are selling applications for the forty to sixty dollar market. As they say, ten percent of something is more than ten percent of nothing. If this pricing scheme will not work for MySQL can you please explain why? I am genuinely curious. John -Original Message- From: David Axmark [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:14 PM To: Damir Dezeljin Cc: MySQL List Subject: Re: InterBase vs. Mysql On Wed, 2003-02-19 at 08:14, Damir Dezeljin wrote: Firstly excuse my poor english ;))) I read the entire mail thread. I'm useing MySQL for our own data storage (I use it to store our oceanographic data for internal use) - I guess that I don't need a commercial license for this. I have another question ... if I will do a commercial program in future which will use MySQL as backend, do I need to buy only one commercial license to link the program or does any customer need a commercial license if I don't want that my code to be GPLed? You need to buy a license for each distributed/sold version of your product that contains MySQL. But there are no limits on the number of clients that connects to that MySQL server of number of CPUs in the machine or so (like with our big proprietary competitors). /David (MySQL Co-Founder) - 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: InterBase vs. Mysql
Gerald, One hundred MySQL licenses still works out to $90.00 USD. Even if it worked out to half that would still leave me with no margin and so no compensation for my time. I am trying to find a way of using MySQL in a very low cost market and still have still have pocket change after each sale. The current pricing scheme does not support this market and I am hoping that MySQL is open to suggestions to allow it to support that market. John -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 3:13 PM To: John Griffin Cc: David Axmark; Damir Dezeljin; MySQL List Subject: Re: InterBase vs. Mysql Buy a hundred at a time. John Griffin wrote: Actually, I am trying to address the problem of having to buy a $200 MySQL license for every $50 software product I sell. If you have a solution for this problem I would like to know what it is. This is a licensing issue that I haven't found a good solution for. John -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:49 PM To: John Griffin Cc: David Axmark; Damir Dezeljin; MySQL List Subject: Re: InterBase vs. Mysql Well, then I would buy a $50.00 product using MySQL, and then your $5000.00 product. Oh, and subtract the $500.00 license fee. I already have a license. I prefer to pay a flat fee for each license, not a fee based on the price of your software. John Griffin wrote: Hello David, Since you were kind enough to clarify some matters on licensing I was hoping you would also be open to suggestions. Instead of charging a flat fee for each copy of MySQL that is resold why not charge a percentage up to a certain point. It might make it a bit easier for developers with inexpensive applications to choose your product. If I know that MySQL is going to be, for example, a constant ten percent of my sale cost I can price more competitively for the market. The is defiantly a boon for developers who are selling applications for the forty to sixty dollar market. As they say, ten percent of something is more than ten percent of nothing. If this pricing scheme will not work for MySQL can you please explain why? I am genuinely curious. John - 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: InterBase vs. Mysql
Actually, I am trying to address the problem of having to buy a $200 MySQL license for every $50 software product I sell. If you have a solution for this problem I would like to know what it is. This is a licensing issue that I haven't found a good solution for. John -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:49 PM To: John Griffin Cc: David Axmark; Damir Dezeljin; MySQL List Subject: Re: InterBase vs. Mysql Well, then I would buy a $50.00 product using MySQL, and then your $5000.00 product. Oh, and subtract the $500.00 license fee. I already have a license. I prefer to pay a flat fee for each license, not a fee based on the price of your software. John Griffin wrote: Hello David, Since you were kind enough to clarify some matters on licensing I was hoping you would also be open to suggestions. Instead of charging a flat fee for each copy of MySQL that is resold why not charge a percentage up to a certain point. It might make it a bit easier for developers with inexpensive applications to choose your product. If I know that MySQL is going to be, for example, a constant ten percent of my sale cost I can price more competitively for the market. The is defiantly a boon for developers who are selling applications for the forty to sixty dollar market. As they say, ten percent of something is more than ten percent of nothing. If this pricing scheme will not work for MySQL can you please explain why? I am genuinely curious. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing binary
Hello, First install. Acquired the mysql-max-3.23.55-pc-linux-i686.tar.gz file. Uncompressed and installed into /usr/local Would like to have Innodb tables activated and set the datadir to '/usr/local/mysql_db_files' In viewing the /usr/local/mysql/scripts/mysql_install_db file the option --skip-innodb is hard-coded into it. I will include the option '--datadir=/usr/local/mysql_db_files' to my initial call to /usr/local/mysql/scripts/mysql_install_db. However do I modify the /usr/local/mysql/scripts/mysql_install_db script and remove the hard-coded --skip-innodb to get the Innodb table to be activated?? Thanks, jpg - 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: Looping through parent and childs
Hi Jakob, You can not do this in MySQL. MySQL does not support hierarchical joins nor does it support Transact-SQL. You will need to do this with a combination of SQL and your favorite host language. Substituting Transact-SQL for Java, Perl, PHP or any other language and you will get the same results. John Griffin -Original Message- From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 6:39 AM To: [EMAIL PROTECTED] Subject: Looping through parent and childs I'm new to mySQL and would like to know how do a SELECT where I get all child records whose root parent=1 Here's my table (project_group_list): group_idparent_group_id 1 0 2 0 3 1 4 3 5 4 6 4 This is how my output should be: 1 / 3 / 4 / \ 5 6 I was thinking of something like this: SELECT PGL1.project_group_id, PGL1.ref_parent_project_group_id FROM project_group_list PGL1 JOIN project_group_list PGL2 ON PGL1.group_id = PGL2.parent_group_id WHERE PGL1.group_id = 1 The reason for my subject contain looping is because I'm also interested in if mySQL have any way of looping SQL queries? Below query is taken from MS-SQL newsgroup: WHILE @@ROWCOUNT0 BEGIN INSERT INTO [table] SELECT FROM [table] etc. etc. END /Jakob - 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: rollback a table?
Yes, Back up your data every night. Then you will only have to perform a single simple restore instead of rebuilding from four months ago. I know that this sounds like a smart ass reply but I am serious. Disk space is cheap. CD's are cheap. Other media like DVDs are getting cheaper every day. Unless you have a monster database containing gigabytes of data the cost of a nightly archival should be far less than the cost of your time doing a four month restore of the data. Do the math and show your boss if he needs any convincing. The numbers should speak for themselves. John Griffin -Original Message- From: Mark [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:14 PM To: [EMAIL PROTECTED] Subject: rollback a table? Hi, Something bad happened the other day, a query hosed all the data in my table, but luckily I had an original dump of the table from 4 months ago and binlogs from then on. I had to load the original table into a separate db and then grep through the binlogs for queries to update it with, stopping at the one that hosed my data. Anyway, it was a project and it seems like there should be a better way. Is there? - 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: rowid
MySQL supports _rowid. _rowid is defined as a synonym for the primary key if the primary key consists of one column and is an integer. Hope this helps, John Griffin -Original Message- From: geeta varu [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 11:54 PM To: [EMAIL PROTECTED] Subject: rowid i would like to use rowid in my query does mySQL support this ..if s how do i give in query please help... __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.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 - 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: The Security of MySQL
Hi, The problem is not with MySQL. The problem is with the users having access to the database files. Lock up the directory that the files are stored in so that only user MySQL and the administrator (root) can access them. Also, revoke the privileges of any user, other than MySQL and the administrator, to start or stop the MySQL server process. If it is possible, remove all user access to the box your database is running on. John Griffin -Original Message- From: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:13 PM To: [EMAIL PROTECTED] Subject: The Security of MySQL I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem... My users is hacking the database because the MySQL system tables are stored in .MYD format and to hack database is simple , only rename the database and copy the blank database... restart MySQL and the permissions is FULL FOR ALL USERS... Exists in MySQL routines to ENCRYPT tables ? or the data inside tables ? the functions like ENCODE and DECODE print a password in log file ( IN CLEAR TEXT) and this is terrible for me ! Exists the PASSWORD on CREATE TABLE STATEMENT but i'm using and is same without the clause. Please MySQL-Team and users... The security of MySQL is too simple ? only rename and the database is opened for world ? please help in advance ;) Tanks Tanks very much sql,query,innodb,mysql - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 221602060 $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re[2]: The Security of MySQL
Hi, You have a terrible problem. If your competitors can copy your database it is the fault of your ISP. The ISP should not give them access to your files. This is possible. If your ISP will not do this get another ISP in another country that will do this. If your competitors are users of your system have them sign a contract before they can use your system. The contract should state that your users can not copy your software and they can not compete against you for a period of time after they are no longer your customers. If you are using a scripting language see if you can compile it. PHP has the Zend compiler. This will keep your competitors from easily stealing your code. It will also allow you to add code to protect your application from easily being pirated. John Griffin -Original Message- From: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 1:58 PM To: Jeremy Tinley Cc: [EMAIL PROTECTED] Subject: Re[2]: The Security of MySQL Respondendo, quarta-feira, 26 de fevereiro de 2003, 14:46:45, Mensagem Original: JT Why does a user on your system have access to rename the database? Your JT database files should be readable only by the user that your database is JT running as. I work with notary officers on brazil ... and my product i sell ! , the users (competitors) can be copy my system to sell to other users... this is terrible to my software house... the MySQL is not prepared for this ? JT Why don't you post more information about your OS and installation so that JT users can help you secure your site. T JT I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem... JT My users is hacking the database because the MySQL system tables are JT stored in .MYD format and to hack database is simple , only rename JT the database and copy the blank database... restart MySQL and the JT permissions is FULL FOR ALL USERS... JT Exists in MySQL routines to ENCRYPT tables ? or the data inside tables JT ? JT the functions like ENCODE and DECODE print a password in log file ( JT IN CLEAR TEXT) and this is terrible for me ! JT Exists the PASSWORD on CREATE TABLE STATEMENT but i'm using and is JT same without the clause. JT Please MySQL-Team and users... The security of MySQL is too simple ? JT only rename and the database is opened for world ? JT please help in advance ;) JT Tanks JT Tanks very much - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 221602060 $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: From Win2000/IIS to Linux/Apache ?
Hi Gary, Where I work we use Windows2000/Apache/MySQL/PHP in development and Linux/Apache/MySQL/PHP in production. We move any database stuff via mysqldump with no problems what so ever. BTW, the reason we went with Linux in production is that MySQL performance seems to be vastly superior on Linux, at least for the Web applications we are running on the hardware we are running. If at all possible, I would suggest you do some timing tests with both Linux and Windows and see which works better for you. John Griffin -Original Message- From: Theisen, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 12:59 PM To: '[EMAIL PROTECTED]' Subject: From Win2000/IIS to Linux/Apache ? Hi all, I have PHP MySQL installed on a Win2000/IIS system. I may be moving (due to requirements at work) to a Linux/Apache system in the near future. I'm wondering if it's a hassle, or even possible, to move the MySQL database from the windows/IIS box to the Linux/Apache box? Any corruption, or other problems associated with this type of move? Thanks! P.S. I also have the option of leaving Win2000 in place but switching to Apache service. Would this be worth it? In other words, would that setup be a better web server environment (for PHP MySQL) than the Win2000/IIS setup? - 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: Row numbers
I think I know what you are asking for. Create an int field with auto_increment set. Make that field the first field in your table. i.e. CREATE TABLE my_table ( id int(11) auto_increment NOT NULL, other_data ... PRIMARY KEY (id) ); Then, when you want rowid for something use: SELECT _rowid, ... FROM my_table WHERE ... This will return a unique identifier for each row in _rowid. It is not a raw pointer like Oracle's ROWID but it will give you what you want (I think). John Griffin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 2:09 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: AW: Row numbers I stated to implement something like Oracle's ROWNUM ... but noone's listening ... therefore I build an UDF ... -Ursprüngliche Nachricht- Von: Luc Foisy [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 13. Februar 2003 20:00 An: MYSQL-List (E-mail) Betreff: RE: Row numbers There is no relevant data or use to this number. It is the row number of the returned result set, purely for display. I was hoping there was some kind of function just to drop a number in there, regarless of any data that is stored in the table or regardless of the order the resultset appears. -Original Message- From: Jerry [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 1:48 PM To: Luc Foisy Subject: Re: Row numbers Have to have one in the row and select that along with the query, if your going to use it for some other sql command it probally should be in the table already - Original Message - From: Luc Foisy [EMAIL PROTECTED] To: Jerry [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 5:59 PM Subject: RE: Row numbers No language, just straight mysql -Original Message- From: Jerry [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 12:53 PM To: Luc Foisy Subject: Re: Row numbers using what language ? or the mysql client ? - Original Message - From: Luc Foisy [EMAIL PROTECTED] To: MYSQL-List (E-mail) [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 5:48 PM Subject: Row numbers Is there a way to get a row number returned with any select 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 - 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
RE: Can MySQL handle 120 million records?
Hi Guys, I'm a lurker on this list but I have decided to come out of my shell for a moment. I a previous job I was the Oracle DBA for my development team. We had a persistent problem with Oracle corrupting the development database. Oracle had no idea with the problem was even after I sent them a copy of the data files. I eventually traced the problem to a flaky memory chip in the development database server. We replaced the chip, reinstalled Oracle and the problem went away. Now, the lessons learned from this story; No database server software can account for all possible conditions. Regardless of the database, you will have an event at some point in time that causes database corruption. It's like death and taxes. It's going to happen. Deal with it. Create a good backup strategy, a good disaster recovery plan and practice doing restores at least once a month. Expecting the software to save you from all situations is just a bad idea. John Griffin -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:36 PM To: Michael T. Babcock Cc: [EMAIL PROTECTED]; Muruganandam Subject: Re: Can MySQL handle 120 million records? I guess you can say I'm a follower. Other DB systems have been in use for years, so their reliability has been generally proven through use. It's good to know that a lot of people have had success with MySQL, but considering MySQL is the new comer, I'm still a little tepid! At 01:22 PM 12/18/2002 -0500, Michael T. Babcock wrote: Michael She wrote: X-MDRcpt-To: [EMAIL PROTECTED] X-Return-Path: [EMAIL PROTECTED] X-MDaemon-Deliver-To: [EMAIL PROTECTED] 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable, things like that shouldn't happen. Comments like those in the MySQL manual scared me. 1) Do you believe this doesn't ever happen with other 'enterprise' level DB systems? 2) What do you think Microsoft's pages would look like if they allowed arbitrary user comments (read their newsgroups ...) 3) Those reports should be filed as bugs to be fixed, not added as comments in the manual. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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
Possible date bug
Hi All,
I ran the following commands:
DROP TABLE IF EXISTS test_date;
CREATE TABLE test_date (test_date datetime);
INSERT INTO test_date (test_date) VALUES ('2002-02-31');
SELECT * FROM test_date;
I got the following results:
mysql DROP TABLE IF EXISTS test_date;
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE test_date (test_date datetime);
Query OK, 0 rows affected (0.03 sec)
mysql INSERT INTO test_date (test_date) VALUES ('2002-02-31');
Query OK, 1 row affected (0.01 sec)
mysql SELECT * FROM test_date;
+-+
| test_date |
+-+
| 2002-02-31 00:00:00 |
+-+
1 row in set (0.00 sec)
mysql
Am I mistaken or does 2002-02-31 translate into February 31, 2002? If it does ...
I am running MySQL 3.23.41 on Windows 2000.
John
-
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 AB has reached a settlement with NuSphere Corporation
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002 UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer of the world's most popular open source database, and NuSphere Corporation, an independent operating company of Progress Software Corporation, today announced a settlement of the dispute between the two companies regarding use of the MySQL trademarks, copyrights, and compliance with the GNU General Public License (GPL). The settlement resolves all outstanding issues between the two companies including ownership and use of trademarks and domain names and assignment to MySQL AB of copyrights for all NuSphere contributions to the MySQL program, and MySQL AB has issued a letter to NuSphere Corporation verifying GPL compliance. We are happy to resolve this dispute, said Olivier Beutels, Sales Executive, Northern Europe, MySQL AB. These past months of discussion with NuSphere regarding trademark rights and GPL issues have confirmed for us all that open source software can flourish free under the GPL license and commercially when the situation merits it. We are pleased to reach this amicable settlement and resolve the issues between the two companies, said Dmitri Dmitrienko, General Manager Europe, NuSphere Corporation. We look forward to getting back to the normal run of business and plan to continue shipping the MySQL database in the NuSphere Technology Platform, and remain focused on our flagship product. About MySQL AB MySQL AB develops, markets and supports the MySQL database server, the world's most popular open source database. With over 4 million installations and 27,000 downloads per day, MySQL is the de facto open source database leader and is quickly becoming the core of many high-volume, business-critical applications. The MySQL database is available under the free software/open source GNU General Public License (GPL) or a non-GPL commercial license. For more information about MySQL, please go to www.mysql.com. MySQL is a registered trademark of MySQL AB in Sweden and other countries. MySQL is a trademark in the United States and other countries. About NuSphere Corporation NuSphere delivers the first Internet Application Platform (IAP) based on open source components, providing an integrated foundation that allows companies to deploy reliable, cost-effective, enterprise-class applications across Windows, UNIX and Linux environments. NuSphere® PHPEd(tm) Advantage is an integrated software suite that pairs the reliability and cost-effectiveness of PHP, Apache, Perl and open source databases with PHPEd, the leading PHP development environment for building business-critical web applications and web services. Based in Bedford, Mass., the company's commercial software services include technical support, consulting and training. For more information, visit www.nusphere.com or call +1-781-280-4600. NuSphere is a registered trademark of NuSphere Corporation in the United States and other countries. PHPEd is a trademark of NuSphere Corporation in the United States and other countries. Other marks mentioned in this press release are the trademarks of their respective owners. -Original Message- From: Leonardo Javier Belén [mailto:lbelen;afip.gov.ar] Sent: Thursday, November 07, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: Christopher Hicks [EMAIL PROTECTED] To: Michael Widenius [EMAIL PROTECTED] Cc: Mysql List [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation On Thu, 7 Nov 2002, Michael Widenius wrote: MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html The press release sounds like typical PR puffery. Is any meat going to come out beyond it's settled? -- /chris Programming is a Dark Art, and it will always be. The programmer is fighting against the two most destructive forces in the universe: entropy and human stupidity. They're not things you can always overcome with a methodology or on a schedule. -Damian Conway, Perl God - 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:
RE: Marketing materials ??
My point was that unless you were worried about tens of thousands of simultaneous connections, MySQL is a better choice in terms of costs. If you are worried about tens of thousands of connections, MS-SQL still isn't a good solution because it won't handle the load and it will cost even more money; one lot to convert to MS-SQL, another lot to convert to Oracle because Oracle can handle the load. The reason I brought Oracle up in the first place is because a properly tuned Oracle database will outperform everybody in high load conditions. Twenty five years of experience tends to give people a bit of an edge when designing databases ;) John -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:49 PM To: John Griffin Cc: Yuri; [EMAIL PROTECTED] Subject: Re: Marketing materials ?? On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote: Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core functionality, are the same. The same rules of database design apply to all databases. There is a SQL standard that all databases conform to (to varying degrees). All backups, etc. still need to done regardless of the database. In fact, the only real differentiator that management should worry about is scalability. If your management is worried about thousands of simultaneous requests (i.e. 25,000) than I would suggest you look at an Oracle solution. You lost me on that last part. The hardware required to make Oracle handle 25,000 connections efficiently is FAR more expensive than for MySQL. Money talks, right? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 43 days, processed 914,113,484 queries (242/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
RE: Marketing materials ??
Hi Yuri, Money talks. Point out that MySQL is an open source initiative and can save them money. As for knowing another product, such as MS-SQL, being a deciding factor; it really isn't an issue. All databases, at their core functionality, are the same. The same rules of database design apply to all databases. There is a SQL standard that all databases conform to (to varying degrees). All backups, etc. still need to done regardless of the database. In fact, the only real differentiator that management should worry about is scalability. If your management is worried about thousands of simultaneous requests (i.e. 25,000) than I would suggest you look at an Oracle solution. John -Original Message- From: Yuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 5:36 PM To: [EMAIL PROTECTED] Subject: Marketing materials ?? Hi, I may get in position to protect my choice of MySQL being confronted by completely non-technical management. Management is likely to argue in favor of MSSQL (nice GUI, many people who know it, they are used to it, you can do any project on any DB, blah blah blah). All this crap. Anyone has web references to different DB servers comparison (performance/feature-rich /other...)? Marketing materials/diagrams/tables that would be able to convince non-tech guys that MySQL is superior to MSSQL? Selling points (like ease of administration, high performance, robustness of SQL language, cross platform-nnes) ? Any other considerations. I mean I know by heart that MySQL is better but management has totally different mindset. So any such convincing information will be GREATLY appreciated )) Yuri. - 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: Info on 4.0.x release date
Okay, This is getting very nasty. There is no need for harsh words. Let's take a step back and look at the problem a bit differently. The story, as I understand it, is this; Will made a decision some time ago to develop applications on MySQL. Will based his decision at least partially on the fact that the developers at MySQL stated/estimated/guessed/hoped that they would have a stable version of MySQL 4.0 in January or February. It is now August and no stable version seems to be forthcoming. From this, I draw the following conclusions: - Will has a schedule he has to meet but he will not be able to unless he has a stable version of 4.0 - The MySQL team has found the last few outstanding problems in 4.0 very difficult to fix and so they can't say when a stable 4.0 will go out the door I think know what your problem is Will. You made your purchasing decision based on a beta version of the software. This is a big no no. MySQL AB is not the first company to miss the mark when it comes to a release date. Always, always, always make your decision based on the current version of the software. You can never know what may happen to completely derail another companies project or a feature. Now, to the boys with the goods. What's the hold up guys? Saying it will be stable when it's stable kind of sounds like go ask someone who cares. Getting a little visibility on the outstanding issues and exit conditions would give everyone the warm-fuzzies. Is there a specific Web page or email you can point us to? Looking forward to an answer from MySQL AB, John -Original Message- From: Dean Ellis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 2:15 AM To: [EMAIL PROTECTED] Subject: Re: Info on 4.0.x release date -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 09:51 pm, Will French wrote: accepting this is part of growing up. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. Just curious: Are you a customer of or investor in MySQL AB? Have you actually purchased a license or support agreement from them? Or are you, like so many others, expecting to have everything precisely the way you want it, before you even realize that you want it, even though you are not paying a dime for it? Really. Just curious. Ironically, the fact that I pay no license fees to MySQL AB is based upon Ahhh, I see. So, you are _completely irrelevant_. You are fully entitled to your opinion. Yes, communication with regard to the 4.x series needs some improvement. Yes, they have taken considerably longer than they originally projected. But you are not a customer. You have no right to demand anything of them. They are not accountable to you in any way, shape or form. You get what you pay for. Accepting this is a part of growing up. Dean Ellis -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9bGprRU3T/K5ORe8RAuqrAJwLiBdMvZzRXY7ttCfyAzVUGJAEPQCfRml/ /KYoxBSm4mmMnAieLXFPH2s= =I7h3 -END PGP SIGNATURE- - 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: MySQL vs. Oracle (not speed)
Hi Elizabeth, The first question I would ask why don't you want Oracle? If you can't come up with a good business reason why your company shouldn't go with Oracle I would say you have already lost the battle. The second question is who is making the purchasing decision? If it's middle management or the bean counters then you have pretty well lost again because nobody ever lost their job for buying Oracle. Oracle has a number of advantages that make it a very safe purchasing decision; it's a market leader, it's widely supported, it's robust, it scales well, and it comes with a full suite of development and deployment tools. The only weakness Oracle has is its price tag. And the price goes beyond the cost of the database. Oracle's development tools are pricey, a large hardware platform is needed to support not only the production box but also developers workstations and, if you are doing a client/server deployment, the end users machines. Also the price of a good Oracle DBA and development team is fairly steep. MySQL on the other hand is fairly inexpensive over all. There is no special training required in order to set up an instance and start playing. It can be easily integrated with a number of scripting languages giving your development team a boost in performance. It also has a very small footprint. Our production box is a PIII 800 with 256MB of RAM running Linux as the OS. We have over 100 users and over 100 tables and we have not yet had any performance issues. MySQL also has a very responsive support staff and a mailing list chock full of talented people who like answering questions ;) MySQL also has what some people consider fairly serious drawbacks. MySQL does not support triggers or foreign key constraints (yet) so data integrity is always at risk. There is no equivalent of PL/SQL in MySQL, all database procedures etc. must be written in a 3GL, such as C, and then linked in. If you feel your shop should become a MySQL shop I suggest you look at the business reasons why and use those reasons to argue your case for you. Technical coolness or altruistic support of the open source movement doesn't cut it with most managers. Productivity, cost, and support usually does. John Griffin -Original Message- From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:25 PM To: [EMAIL PROTECTED] Subject: MySQL vs. Oracle (not speed) A company I work with is in the process of upgrading its databases from some motheaten system to something current. My impression is that they want to go with Oracle, and I'm not sure if this is based on anything other than being impressed with the size and presumed quality support of Oracle. I'd like to encourage them to at least seriously consider using MySQL instead. I don't think that speed is a huge factor here; we do a lot of XML publishing and content management, but at most we'd have several gigabytes of data and several dozen simultaneous users, so well within the capabilities of MySQL. I've looked at various things I could find, like the benchmarks pages (probably not relevant) and the MySQL myths page, which was somewhat helpful, but I couldn't find anything more along the lines of How to Convince my Management to go with MySQL. I don't even know what to expect from them, but I'm imagining they'll say, But MySQL doesn't support sub-selects, to which I can reply, But you can write most of those as joins anyway, so it won't matter because the software will all be written from scratch. Etc. Are there pointers anyone can give me? E. Bognewitz - 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: MySQL vs. Oracle (not speed)
Hi Mary, It's not a question of approval. If you are having problems with MySQL there is an entire list of people who are willing to offer support for free. Post your query and some table information and let's see if we can clear up your performance issues. John Griffin -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 10:28 AM To: Mark Matthews; [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed) What exactly is Trolling I find MYSQL to be slow , sorry if that doesn't met with your approval. -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:15 AM To: Mary Stickney; [EMAIL PROTECTED] Subject: Re: MySQL vs. Oracle (not speed) Mary Stickney wrote: I have been doing speed tests the same query ran on MYSQL took 45 minutes on MS-SQL it took 11 minutes.. yes you do get what you pay for Why not post the queries and the schemas here? My guess is you don't have something indexed correctly, or are using a query that gets optimized well by MS-SQL Server, but not MySQL. We all know that SQL is not absolutely portable, and that when you move queries from database to database, that there is some work to re-optimize them. There are some queries that just work better on databases other than MySQL, but they are very few and far-between. Without any way to backup your claim, it is hard for anyone here to believe that you have done everything possible to make a fair comparison. Given your previous comments in this forum, it appears that you must be trolling. -Mark - 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
Slow connect under Windows2000
Hi All, I am hoping this question has already been answered somewhere and I just can't find it. I recently had my machine upgraded from WindowsNT to Windows2000. Since this upgrade my access to my MySQL database is degraded noticeably. There seems to be a constant delay when I connect to the database. Here is the code PHP I am using as a test: ? $host = 142.226.186.222; $user = root; $pass = ; mysql_connect($host,$user,$pass); ? Has anyone else encountered this problem before? I am using MySQL 3.23.41, PHP 4.0.6, and Apache 1.3.20. John Griffin - 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
Does mysqlgui depend on DNS?
I am trying to connect to my database with mysqlgui as root. I have gone into options and entered the port number and the path to the socket. I have ask for password checked on and am using the same password that works when I do mysql -u root -p. I have tried accessing the mysql db and a test one, both with the same results. When I try to connect and enter the password the error is: Access denied for user: 'root@host.domain' (Using password: YES) When ask for password is off, I get the same error plus more saying I have corrupt files, or no privileges. The entire mysql package was recently installed, and just one test database exists with one table. It works fine so I don't think I have corrupt files, and I know I have privileges. I have verified that mysqld is using the port with fuser port#/tcp The only problem I can think of is that this system's name is not resolvable via dns. It is on a non-routable network address behind a firewall, and just static files are used for internal hosts. Does mysqlgui _have_ to verify the host via dns? If so can that be turned off somehow? Thanks -- John Griffin-Wiesner [EMAIL PROTECTED] It said, Windows 95 or better, so I installed Linux. - 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
