Several general questions
Hello all, I have several questions in general since I recently started using MySQL. From the manual I cannot find where these questions are covered. I hope someone can assist me. Firstly though, if this is not the correct mailing list for my questions, please advise correct one. Secondly, thank you in advance for any assistance offered. Lastly; Background; I'm developing a website to be hosted when ready. The HSP I'm planning to use, provides MySQL facilities. I chose MySQL because I can develop said website and become familiar with it, then make use of the exact same technology once ready and live. Questions; 1. Assuming the website grows very large with high volumes and a database exceeds disk space, please advise what is the remedy? 2. Seeing as for the said website I use transactions, thus also the innodb options, please advise whether I can place individual databases at different locations. Note; it seems the filename.sym, does not apply to the innodb files, therefore only the database table definitions are placed in the filename.sym redirecting location. 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? 4. Please advise, with different databases do they all share one set of innodb files - thus if this is the case, how is data for different databases backed up separately? Over to you. Kind regards Emmanuel - 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 AB][MyODBC] ERROR: Unknown MySQL Server Host thinkhost 11001
Dear List, My question is about this error message obtained during a query from word to mySQL: [MySQL AB][MyODBC] ERROR: Unknown MySQL Server Host thinkhost 11001 SITUATION ms word-query to import data from mySQL [correct myODBC installed] ACTION in ms word, choose TOOLS --MAIL MERGE--- [1 main document] CREATE ENVELOPES--- [2 data source] OPEN DATA SOURCE--- click MS QUERY-select the one I created from the list: peter_test. then this shows up: === TDX mysql Driver connect === - I intered my peter_test DNS name - MySQL host: I entered thinkhost which is the name for my server [for a webquery, I use this URL: http://mysql.thinkhost.com - I enter the correct db name, along with UN and PW - check use compressed protocol ON THE BOTTOM OF THIS WINDOW IT SAYS: [MySQL AB][MyODBC] ERROR: Unknown MySQL Server Host thinkhost 11001 QUESTION: What do I need to put in the SECOND FIELD where it asks for the MySQL host name? Thank you in advance, Peter Reck - 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
General database questions
Hello all, I have several questions in general since I recently started using MySQL. From the manual I cannot find where these questions are covered. I hope someone can assist me. Firstly though, if this is not the correct mailing list for my questions, please advise correct one. Secondly, thank you in advance for any assistance offered. Lastly; Background; I'm developing a website to be hosted when ready. The HSP I'm planning to use, provides MySQL facilities. I chose MySQL because I can develop said website and become familiar with it, then make use of the exact same technology once ready and live. Questions; 1. Assuming the website grows very large with high volumes and a database exceeds disk space, please advise what is the remedy? 2. Seeing as for the said website I use transactions, thus also the innodb options, please advise whether I can place individual databases at different locations. Note; it seems the filename.sym, does not apply to the innodb files, therefore only the database table definitions are placed in the filename.sym redirecting location. 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? 4. Please advise, with different databases do they all share one set of innodb files - thus if this is the case, how is data for different databases backed up separately? Over to you. Kind regards Emmanuel - 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: Syntax error with a JOIN
Here's the simplified query: SELECT members.name, group.id, group.name FROM members LEFT JOIN members AS group ON group.id = members.group_id WHERE members.id = 6 And here's the error I get: You have an error in your SQL syntax near 'group ON group.id = members.group_id WHERE members.id = 6' at line 3 group is a reserved word. Use a different alias for the 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: Syntax error with a JOIN
Hi, Try to change the alias - group is a reserved word and it is causing the syntax error This one should work SELECT members.name, gr.id, gr.name FROM members LEFT JOIN members AS gr ON gr.id = members.group_id WHERE members.id = 6 Dobromir Velev Web developer http://www.websitepulse.com/ -Original Message- From: Keegan Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, December 29, 2001 08:03 Subject: Syntax error with a JOIN I'm pulling my hair out about a query that should be simple. I have a table members with columns id, group_id, and a few more that aren't important here. group_id refers to another row in the same members table, but not all members have a group_id. What I want to do is select, for a particular member, the member's name and (if the member is in a group) the group's ID and name. Here's the simplified query: SELECT members.name, group.id, group.name FROM members LEFT JOIN members AS group ON group.id = members.group_id WHERE members.id = 6 And here's the error I get: You have an error in your SQL syntax near 'group ON group.id = members.group_id WHERE members.id = 6' at line 3 Can anybody explain to me how I can get this to work? Is there some kind of trick to joining a table to itself? Thanks, Keegan Miller - 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: query error
HI, The 127 error message is Record-file is crashed - use myisamchk -r table_name to fix it. For further information on this topic check http://www.mysql.com/doc/R/e/Repair.html Hope this helps Dobromir Velev Web Developer http://www.websitepulse.com/ -Original Message- From: WANG_FAITH??îÈõ-þì?L [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Saturday, December 29, 2001 03:25 Subject: query error Hi, all When I query data from a table ,the following error occurs: ERROR 1030: Got error 127 from table handler. Would you please tell me the reason to cause the error and how to deal with it? Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Newbie trying to optimizing a join search
Hi, using LIMIT can speed up the things significantly. If you know the aproximate number of rows in your query just add LIMIT number_of_rows at the end of your query - it will look like SELECT products.return FROM products,prodcat WHERE products.prodno=prodcat.prodno AND products.Store=0001 AND products.Class=0002 AND prodcat.category=Animal AND prodcat.subcategory=Bear ORDER BY products.Title LIMIT 100 Check http://www.mysql.com/doc/L/I/LIMIT_optimisation.html for further information on how MySQL deals with LIMIT Hope this helps Dobromir Velev Web Developer http://www.websitepulse.com/ -Original Message- From: Charley L. Tiggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Saturday, December 29, 2001 01:04 Subject: Newbie trying to optimizing a join search I'm new to mysql and have gotten most things to work satisfactorily thus far. One of the things that is stumping me at the moment is how to perform queries using joins and how to optimize them for speed. the query is structured as follows: SELECT products.return FROM products,prodcat WHERE products.prodno=prodcat.prodno AND products.Store=0001 AND products.Class=0002 AND prodcat.category=Animal AND prodcat.subcategory=Bear ORDER BY products.Title The above query takes approximately 3 seconds to complete (which is better than the 27 seconds without indexes, i admit but still a little slow). Is there a way to optimize this kind of search? Setup of the tables used in this particular area are below: Setup: products table with the following fields: -ID (primary key) -prodno -store -class -title -designer -sugretail -discount price -return prodcat (contains categories associated with each product) with the following fields: -ID (primary key) -prodno -category -subcategory All fields except for ID fields and sugretail and discount price fields are varchar fields. Category and subcategory fields are longest at 50 chars each. In products, the ID field has it's own index, product number, store, class, designer, and title are inside an index called index_product. In prodcat, product number, category, and subcategory are part of an index called index_category. Thanks in advance for your attention and time. Charley - 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 source command question
I have a .sql file that I want to use to create tables and load data via the MySQL utility. The source command seems to be the way to do this but I haven't been able to discover where to copy the .sql file to in order to make it accessible to MySQL. Example; MySQL- source path?MyFile.sql Do I have to put the .sql file in some particular directory or can I specify a path to it? How do I know what path to specify? Thanks in advance... Michael Wood - 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: Hi. Here is the An-san City of the South Korea.
Just a thought. It is a well known fact that MySQL is being used as the backend software for Yahoo Finance. However, the response as mentioned in this mail is also typical from a customer looking at commercial application development. How can the larger business community perception be changed with regards to products like MySQL which are better than or atleast comparable to any other commercial products like say Oracle? Lets face it, in these times of recession, it is important for the businesses to reduce costs of automation theough application development. Using a free software would certainly reduce the costs involved in software. But is it worth it? What would be the typical percentage of software costs in any custom application development in relation to the total costs of Hardware, Software and Development costs? Anybody care to share their thoughts? Rgds, Durga Prasad Placed At : À̼º°è [EMAIL PROTECTED] on 12/29/2001 12:48:50 PM Please respond to À̼º°è [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Durga Prasad/Satyam) Subject: Hi. Here is the An-san City of the South Korea. Hi. Here is the An-san City of the South Korea. We are the company which is developing the programs #8211; ERP(ENTERPRISE RESOURCE PLANNING) and has been concerned with MY_SQL DATABASE. Recently, we suggested to the client of Korea that we want to develop the programs(ERP, MIS, MRP) with adapting your MY_SQL DB, but we are rejected by the client. We took the response to the client ,after we discussed the problem with the client, that if we offer to the client an efficiency test table of MY_SQL and the rest of data, the client will examine this data. Thus, we would like to take the data with the following questions from yours. - Brief yours and what is your adapted businesses? - If the ERP is developed with MY-SQL, is it possible for the ERP to adapt with MY_SQL ? - What is the representative company which is adapted? - User number of MY_SQL, speed, efficiency and stability (in the Window 2000 Server and Linux) - The price list for the user number (in the case of Window 2000 and Linux) - If the client agrees to our company ?s using your DB, can you recognize us to the main agency of Korea? So far, thank you for reading our letter. We wanna receive your response as soon as possible. 2001. 12.28 Arcline. Cor. A principal administrative officer Mun-choel Shin === ¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net - 2002 ´ëÀÔ 1:1»ó´ã,¿ø¼Á¢¼ö,ÇÕ°ÝÀÚ¹ßÇ¥ ¢Ñ http://hmm.daum.net/daeip_0112 - ÀÎÅͳݿ¡¼ 'ÅäÁ¤ºñ°á' º¸¼¼¿ä~ ¢Ñ http://hmm.daum.net/fortune_0112 - 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
print LABELS or ENVELOPES with DATA from MySQL
Dear List, As I don't seem to get MySQL data from my server to my local drive into word, where I would be printing envelopes for a mailing, I wonder what other options are out there? I can easily get the data into EXCELbut I haven't figured out if EXCEL prints envelopes or labels? What is the simplest solution for this function? Thanks, Peter Reck - 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 setup Mysql multiple instances
Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [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: print LABELS or ENVELOPES with DATA from MySQL
Peter I suggest getting hold of the MyODBC drivers (you'll find reference to it in the mysql manual) Once installed you can attached to mysql tables in MS Access, then use the report wizard in there to create your labels or if you are more confortable in word you can open the access mdb file with the newly attached tables directly in the Mail Merge function in word. Hope that helps. John. John Lucas All-Holiday-Brochures.com Find your ideal holiday. Search and View holiday brochures online and order them through the post for free at http://www.All-Holiday-Brochures.com/?ref=96 -Original Message- From: Peter Reck [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 09:56 To: [EMAIL PROTECTED] Subject: print LABELS or ENVELOPES with DATA from MySQL Dear List, As I don't seem to get MySQL data from my server to my local drive into word, where I would be printing envelopes for a mailing, I wonder what other options are out there? I can easily get the data into EXCELbut I haven't figured out if EXCEL prints envelopes or labels? What is the simplest solution for this function? Thanks, Peter Reck - 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
Nothing happens
To whom it may concern, I am trying to use the following statement, select table1.* from table1, table2 where table1.id=table2.id; This just ends up in what looks like the computer hanging, but all my computers resources get used up, so something must be going on. I am running mysql version 11.15 Distrib 3.23.42. for Win95/98. I am running Windows 98 4.10.1998. Have you got any ideas what could be wrong, Hope to hear from you soon, Phil. - 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: print LABELS or ENVELOPES with DATA from MySQL
Peter, You can create a link to M$ Access or M$ Excel via ODBC and then use this in your M$ Word as a MailMerge data source. There is no option in Word to use an ODBC data source. HTH Norman -Original Message- From: Peter Reck [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 09:56 To: [EMAIL PROTECTED] Subject: print LABELS or ENVELOPES with DATA from MySQL Dear List, As I don't seem to get MySQL data from my server to my local drive into word, where I would be printing envelopes for a mailing, I wonder what other options are out there? I can easily get the data into EXCELbut I haven't figured out if EXCEL prints envelopes or labels? What is the simplest solution for this function? Thanks, Peter Reck - 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: how to setup Mysql multiple instances
Thanks for your reply. I have read the mysql manual, but i can only found how to setup multiple servers not multiple instances in one server. BTW, can you tell me can different mysql instances share one dictionary --mysql database? Thanks. Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [EMAIL PROTECTED] -Original Message- From: Sammy Lau [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 6:06 PM To: Li, Robert; [EMAIL PROTECTED] Subject: Re: how to setup Mysql multiple instances http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ L_Database_Adm inistration.html#Multiple_servers - Original Message - From: Li, Robert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 5:58 PM Subject: how to setup Mysql multiple instances Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, RD Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 [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
FULLTEXT indexing / ACID transactions
I am writing an application which requires FULLTEXT indexing capability, and ACID transaction support would also be a plus. I am currently developing on MySQL 4.0.1. As I understand it, MyISAM tables support FULLTEXT indexing but do not support ACID transactions. Also, InnoDB tables support ACID transactions but do not support FULLTEXT indexing. Is this correct? Is there another table type I can use to enable both FULLTEXT indexing and ACID transactions or is there some sort of workaround? Also, as a side issue, is anyone able to compare the pros and cons of MyISAM / InnoDB (or is there a good online resource?) Many thanks, from Duncan Maitland [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: NetBSD versus RedHat versus Solaris x86
Hank, I suspect some of the NetBSD threading comments you found in the archives may be mine. We run NetBSD/Alpha for our site (motorsport.com) on the web server, our work server, plus several other boxes. We originally did the same for the database server, but, at the time (this being early 2000) MySQL appeared not to be happy on a 64-bit machine, at least on NetBSD. (I think this is now much better ...) So we switched to generic Intel hardware. And things ran OK, except that we had increasing numbers of MySQL restarts (5-20 times/day). Automatic, true, but they would always cause a delay in service, and we have a reasonably busy site -- we serve a few million pages per month, all database-driven. (I suspect threading issues, but I have no absolute proof of that.) So this past summer I switched to FreeBSD 4.3, on the same hardware, and moved the MySQL server over. I installed FreeBSD on the new server over FTP, added a preconfigured MySQL binary from http://www.freebsd.org/, and got it running in less than two hours. As a result, MySQL is now rock-solid. We run on a P3/750 on an ASUS motherboard with 384 MB of memory and IBM's 7200 rpm IDE disks. Right now the server uptime is 69+ days (I rebooted in October to change the hardware configuration), and the mysqld process (version 3.23.36) has since then accumulated some 250 hours of CPU time without a glitch. MySQL on NetBSD may have improved since last summer, but I can definitely vouch for FreeBSD at this point. The only question mark is the effectiveness of SMP -- I can't say anything about this, really, since we run on a single CPU. Configuring a dedicated MySQL server is straight-forward (much more so than a web server with integrated Apache and PHP or Apache::ASP). Once you have the OS and MySQL installed and tested, you should be able to just move your databases over, and point your web server at the remote database. Good luck with your choice ... Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Henry Hank [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 01:18 To: [EMAIL PROTECTED] Subject: NetBSD versus RedHat versus Solaris x86 Hello all, I just ordered a new server to act as a database-only server for my website (wheresgeorge.com). I'm currently running mysql 3.22.29 (I'm stuck there due to my web hosting provider). I plan to upgrade to the latest stable version of mysql, but have the following questions about the choice of Operating System. The hardware is a Dell PowerEdge 2550 Dual 1GHZ Pentium/1GB Memory, 3x18GB SCSI disks and will be set up as RAID 5 via a PERC3/Di card. I also require large file size support (2GB). My current database has over 16 million records and processes about 80 queries per second (on average). Peak usage could be around 300 queries/second (estimate). It is running on Linux on a dual PIII-800. Performance is very good, but I'm going to hit the 2GB limit soon, and need to expand beyond what my ISP can provide with their managed solutions. So I am going to co-locate this new DB server as a backend to the current webserver. On to the questions: I was considering Net/FreeBSD, but read about threading problems in the archives, so I don't know if they have been resolved. I was then thinking about RedHat7.2 with the 2.4 kernel (large file size support, I think). I then read about Solaris x86.. which is where I'm leaning, but I was told Solaris x86 might be slower than Linux of Free/NetBSD. I'm also thinking of installing Oracle 8i as a side-by-side comparison to mySQL running on the same HW/OS. Anyway, I'm not a UNIX whiz/admin by any stretch... I know enough to *NIX to manipulate files, jobs, processes, etc. I've even compiled a few packages in the past and got PHP/mysql installed and running on a linux box last year. I can write rudimentary shell scripts. I'm looking for general comments regarding the current status of any of these choices of OS on this hardware in relation to running a fast and stable mySQL installation. Are there any pitfalls I need to watch out for on any one OS? Is any one significantly more favorable for mysql that the other? As I've said, I have searched the archives, but can not find any real-current comments on OS selection. Thanks in advance, -Hank Eskin ([EMAIL PROTECTED]) __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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)
RE: mySQL Issues
Matthew, Without any more information, I would put money on this being either a database design issue or a query design issue. I really expect that database optimization would buy you a lot of performance. But without knowing what kind of database structure you have, what kind of queries you run, what kind of optimization you have done, what you consider to be a LOT of traffic, what kind of server settings you are using and what kind of hardware you run on -- I really can't say much more than that. Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Matthew Hale [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 00:15 To: [EMAIL PROTECTED] Subject: mySQL Issues I run a site that gets a LOT of traffic and uses mySQL. But for some reason, mySQL is making MAJOR load on my server. I have tried it on several servers, and they all end up with load averages like 10+! We have optimized our code as much as possible and STILL are getting super high loads! Is there ANYWAY to optimize mySQL so it doesn't run s much load?? Sincerely, Matthew Hale Get paid cash every time you receive email! Sign up FREE at: http://www.MintMail.com/?m=1825549 - 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: invalid DATETIME=UNIX_TIMESTAMP()
Thomas Zehetbauer writes: I mistakenly set the value of a DATETIME column to the value of UNIX_TIMESTAMP(). I know that this is not good practice and I would have even expected it to fail. But what has happened was totally unexpected for me, invalid date values like '2000-10-09 55:17:71' were inserted. As I could not set the column to the same value manually I think this is an error and should be fixed. Regards Tom PS: Absolutely unrelated words needed to circumvent spam filter: database,sql,query,table Press any key to continue or any other key to quit. -- T h o m a s Z e h e t b a u e r ( TZ251 ) PGP encrypted mail preferred - KeyID 96FFCB89 mail [EMAIL PROTECTED] UNIX_TIMESTAMP returns an integer value, so MySQL did it's best to insert an integer value into a string-derived column type. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can a 3Gb index file still run fast?
I like using compound indexes, but they make the database VERY big, and slow to load. The last 2 million entries took over 24 hours to load using mysqlimport, normally a fast program. The data file has swollen from 580M to 2G. The index file from 180M to over 3G. I can't help but think that a 3G index file defeats the purpose of speedy indexing; for one thing, I can't keep it all in memory at once anyway! I need the collective experience brains of the group for this one. My app is a phone book -- I need to search by name, city, province, etc. But there are over 22 million entries. The indexes i'm using look like this: ALTER TABLE newdb.White ADD INDEX phone_no (phone_no); ALTER TABLE newdb.White ADD INDEX lfc (last_name(12),first_name(8),city(12)); ALTER TABLE newdb.White ADD INDEX lcs (last_name(12),city(12),street_short(10)); ALTER TABLE newdb.White ADD INDEX lps (last_name(12),province,street_short(10)); ALTER TABLE newdb.White ADD INDEX loc (city,street_no(10)); ALTER TABLE newdb.White ADD INDEX postal_code (postal_code); Is there some guideline to a trade-off between index selectivity and size here? Should I, for example, just use 3 characters of each field instead of 8 or 12? These index files are just too huge. Hints? Steve -- Steve Rapaport World Citizen - 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: MSVC++ and MYSQL++ query problem
Jeff Costanzo writes: with this code: Query myQuery = pDatabase-query(); myQuery Select * from repdata; myQuery.store(); I get an Debug Assertion Failed in file dbgheap.c line 1017 Expression: _BLOCK_TYPE_IS_VALIDE(pHead-nBlockUse) pDatabase is a pointer to a connection object. I am connected to the database and there is no problem with the query, I have run it on MySQL administrator with out any errors Please help me understand what is causing this error. Thanks Hi! Please first of all check the size of the table. You should use store() only for result sets that can fit into memory. But your problem is quite different. You forgot to use Result class: Result some = myQuery.store(); -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error compiling
Thank you for the fix. We are still using 6.3 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: General database questions
* Emmanuel van der Meulen 1. Assuming the website grows very large with high volumes and a database exceeds disk space, please advise what is the remedy? Add HW or remove data...? Not sure if I understand your question... 2. Seeing as for the said website I use transactions, thus also the innodb options, please advise whether I can place individual databases at different locations. Yes, you can. Note; it seems the filename.sym, does not apply to the innodb files, therefore only the database table definitions are placed in the filename.sym redirecting location. I don't understand this, sorry. 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? ehhh... don't know if I understand this... the data is stored in tables (db teminology) and the tables (thus also the data) are stored in files (os terminology). 4. Please advise, with different databases do they all share one set of innodb files - No, each database is stored in separate file folders. thus if this is the case, how is data for different databases backed up separately? Not a problem. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indexes in temporary tables
I wonder if mysql uses indexes in temporary tables(when making a join on temp tables etc.)? - 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: Indexes in temporary tables
Goran Krajacic writes: I wonder if mysql uses indexes in temporary tables(when making a join on temp tables etc.)? MySQL treats temp tables same as normal ones, except when the thread ends ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: General database questions
Hello Roger, Thank you for your note and replies. Please see my further points inline; On 29 December 2001 16:21, Roger Baklund wrote; * Emmanuel van der Meulen 1. Assuming the website grows very large with high volumes and a database exceeds disk space, please advise what is the remedy? Add HW or remove data...? Not sure if I understand your question... Roger, assuming the database space as allocated is used up and I do not want to remove the data, but I have lots more space to allocate, is there a way to extend allocated space in flight? Or, does MySQL automatically (and inflight) extend beyond allocated space upto as much space which is physically available; I'm referring to the space for the ibdata files. 2. Seeing as for the said website I use transactions, thus also the innodb options, please advise whether I can place individual databases at different locations. Yes, you can. Thank you, please see next point. Note; it seems the filename.sym, does not apply to the innodb files, therefore only the database table definitions are placed in the filename.sym redirecting location. I don't understand this, sorry. Roger, I managed to place different databases each at alltogether different locations using the filename.sym option. However, no matter how much data I loaded, the table sizes stay at 9kb. This lead me to assume that when using the innodb option (for transactions), that the data is loaded in the ibdata files. If this is the case then how do I place the ibdata files (related to the innodb option) at different locations for different databases? 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? ehhh... don't know if I understand this... the data is stored in tables (db teminology) and the tables (thus also the data) are stored in files (os terminology). Roger, it seems you are not familiar with the innodb option when using transactions. Note from the MySQL PDF format manual, P. 58. MySQL supports transactions with the InnoDB and BDB Transactional table handlers. See Chapter 7 [Table types], page 441. Or let me rephrase the question; when using the innodb option, ibdata files get used, and my question is; when using the innodb option is the data stored in the table files in the database folder (which do not seem to increase in size no matter how much data I load), or is the data stored in the ibdata files for which I cannot see a way to declare them individually per database. 4. Please advise, with different databases do they all share one set of innodb files - No, each database is stored in separate file folders. Roger again I'm referring to the ibdata files, and if they are stored in a different location, please advise how their location is declared (say each database on a different HDD)? thus if this is the case, how is data for different databases backed up separately? Not a problem. Please advise how I can declare the ibdata files to be at different locations. Thank you again for your assistance. Kind regards Emmanuel - 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
Adding an incremented id field
I've got a database already populated with data and need to add a sequential numerical id field as a key. (as one would with an auto increment field) Is there a straightforward sql statement that will do this? Gawain - 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
ARGH! Installation Problems
A novice-level question... i've just installed the binary version of mySQL 4.0.1-Max for darwin ... but gives me the following error when i try to run the mysql_install_db script: sorry the host 'myhostname' could not be looked up. .etc. hints? - 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: Adding an incremented id field
: I've got a database already populated with data and need to add a : sequential numerical id field as a key. (as one would with an auto : increment field) : : Is there a straightforward sql statement that will do this? ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Adding an incremented id field
At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote: : I've got a database already populated with data and need to add a : sequential numerical id field as a key. (as one would with an auto : increment field) : : Is there a straightforward sql statement that will do this? ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; Thanks for the reply. What I need is to actually add the numbers though. :-) Gawain - 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: Adding an incremented id field
At 12:04 PM -0600 on 12/29/01, Sherzod Ruzmetov aka sherzodR wrote: : I've got a database already populated with data and need to add a : sequential numerical id field as a key. (as one would with an auto : increment field) : : Is there a straightforward sql statement that will do this? ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY; Doh!! It does add the numbers. Sorry for the silly question and thanks again. Gawain - 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
INSERT OR UPDATE
Hello all, I need to write a query that will insert data into a table if there is no row matching a pre-specified ID, but will update a row if it matches a pre-specified ID. Any pointers would be great. - 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 help to display values but only when NOT NULL.
Hello ! what I want to do is : display all the NOT NULL fields of 1 row, this row being selected with a key [ for example : tabID.login='john' ] . I DO NOT KNOW IN ADVANCE WHICH FIELDS ARE SUPPOSED NOT NULL, since it varies along with the key [ tabID.login='jack' would give other NULL fields ] and when I do : mysql select * from tabID where tabID.login='john' ; I got hundreds of fields in the same row, and many are NULL. So I do not want to display them, but instead I want to display only the NOT NULL. a priori, the MySQL command for what I want should be something like: mysql select [all colums values that are NOT NULL] from tabID where tabID.login; the following is wrong : mysql select * from tabID where tabID.login='john' where tabID.* IS NOT NULL; So, I need to loop on the result, and check each item returned, and if the item is NOT NULL I display it. I do not know how to do that. any hints ? == Gilles MISSONNIER - Projet Terapix phone : [33] 01 44 32 81 36 http://terapix.iap.fr - 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
Vb DbGird Limitation
hi there, I was writing a MS VB 6 code and I have added to the form a DBGIRD component (unbound) to display the data, which was retrieved by an sql statment to the from from a MySQL database into a recordset. But I got an error in the VB mentioned the following: Rowset not Bookmarkable I started to debug the program. Finally I found that was a limitation in the MySQL. Is it true? What is the alternative way to solve this issue? _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: Vb DbGird Limitation
Hi, -Original Message- From: yousif shams [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 29, 2001 7:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Vb DbGird Limitation hi there, I was writing a MS VB 6 code and I have added to the form a DBGIRD component (unbound) to display the data, which was retrieved by an sql statment to the from from a MySQL database into a recordset. But I got an error in the VB mentioned the following: Rowset not Bookmarkable I started to debug the program. Finally I found that was a limitation in the MySQL. Is it true? What is the alternative way to solve this issue? MySQL nor MyODBC doesn't support any bookmark functionality. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: General database questions
* Emmanuel van der Meulen Roger, assuming the database space as allocated is used up and I do not want to remove the data, but I have lots more space to allocate, is there a way to extend allocated space in flight? Or, does MySQL automatically (and inflight) extend beyond allocated space upto as much space which is physically available; I'm referring to the space for the ibdata files. I think you would need to restart the mysqld server daemon, but this is very fast, and can be done with virtually no downtime. (1-2 seconds is my experience, I suppose this depends on a number of factors, so you should test it on your system.) I should also tell you that I have never used the Innodb table handler. I was not aware of the different file organization compared to MyIsam tables, but I think the answer for your questions are here: ULR: http://www.mysql.com/doc/I/n/InnoDB_start.html This is an excerpt of an example my.cnf: [mysqld] # You can write your other MySQL server options here # ... # innodb_data_home_dir = / #Data files must be able to #hold your data and indexes innodb_data_file_path = ibdata/ibdata1:2000M;dr2/ibdata/ibdata2:2000M innodb_data_file_path is used to define database partitions or 'tablespace' and define a size for those partitions. This must be changed when your tables are growing beyond the predefined size, and I suppose a restart is needed, but I don't know for sure. Roger, I managed to place different databases each at alltogether different locations using the filename.sym option. However, no matter how much data I loaded, the table sizes stay at 9kb. I don't understand this... how do you know what the size of the table is? As I said, I have never used Inndb, but the tables are stored within the ibdata files, are they not? So, how do you know how many kb? This lead me to assume that when using the innodb option (for transactions), that the data is loaded in the ibdata files. If Yes, all data, including indexes, are stored in the ibdata files. this is the case then how do I place the ibdata files (related to the innodb option) at different locations for different databases? By setting innodb_data_home_dir to the root path and use a relative path in the innodb_data_file_path parameter, as shown in the example above. This will however not give you different locations for different databases... see below. 3. When using innodb options (for transactions), please advise whether data is stored in the tables or the innodb files? ehhh... don't know if I understand this... the data is stored in tables (db teminology) and the tables (thus also the data) are stored in files (os terminology). Roger, it seems you are not familiar with the innodb option when using transactions. That is correct, I have never used Innodb, and I don't use transactions with mysql. Note from the MySQL PDF format manual, P. 58. MySQL supports transactions with the InnoDB and BDB Transactional table handlers. See Chapter 7 [Table types], page 441. This does not clearify the table/file mixup. A 'table' does not exist in the OS environment, only files, wich of course may contain 'tables' when seen from the db environment... Or let me rephrase the question; when using the innodb option, ibdata files get used, and my question is; when using the innodb option is the data stored in the table files in the database folder (which do not seem to increase in size no matter how much data I load), In that case, I would guess the data is not stored there. :) Maybe you are looking at the .frm files? This is the table definitions only. or is the data stored in the ibdata files for which I cannot see a way to declare them individually per database. ok, I think I understand now... :) Your _database_ is not innodb, your tables are: type=innodb is an option to the CREATE TABLE statement, not the CREATE DATABASE statement. As far as I can tell from the manual, you can not instruct mysql to keep one innodb table in one particular tablespace, in other words: you can _not_ put different databases on different locations, thus my answer to your questions #2 and #4 was wrong. Sorry! (again, I have never used innodb, there may be some way to this that I don't know about.) Roger again I'm referring to the ibdata files, and if they are stored in a different location, please advise how their location is declared (say each database on a different HDD)? I believe you now have the answer for this, except it is not the _database_ you declare a location for when it comes to innodb tables, it's the tablespace. thus if this is the case, how is data for different databases backed up separately? Not a problem. Please advise how I can declare the ibdata files to be at different locations. See innodb_data_file_path in the example above. -- Roger
Binary files..
Hi, Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql tables? If yes, can you point me to any direction? Thank you very much. Gurhan - 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: Binary files..
* Gurhan Ozen Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql tables? If yes, can you point me to any direction? Yes, it is possible, see the url below. In general it is recomended to keep the binary files in the OS file system, and only store the path to the file in the database. URL: http://www.mysql.com/doc/B/L/BLOB.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: INSERT OR UPDATE
* Joel Wickard I need to write a query that will insert data into a table if there is no row matching a pre-specified ID, but will update a row if it matches a pre-specified ID. Any pointers would be great. The REPLACE statement: URL: http://www.mysql.com/doc/R/E/REPLACE.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select statement with decimals as a record...
I have a record that keeps track of averages, now when I say SELECT * FROM tblname ORDERBY 'average' DESC; It returns the one with the largest amount of intergers... I.E. It will say that 52.50 is a larger number than 358, why is that? Is that a table column setting of a datatype? - 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: Select statement with decimals as a record...
Todd, this result is perfectly correct if they are both strings: 52.50 is greater than 358. To make them interpreted as numbers instead, see the manual page: http://www.mysql.com/doc/C/o/Comparison_Operators.html Steve Todd Williamsen wrote: I have a record that keeps track of averages, now when I say SELECT * FROM tblname ORDERBY 'average' DESC; It returns the one with the largest amount of intergers... I.E. It will say that 52.50 is a larger number than 358, why is that? Is that a table column setting of a datatype? - 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 -- Steve Rapaport World Citizen - 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: Select statement with decimals as a record...
I found an easier way... switch the datatype to decimal, WHAMMO!! works beautifully! - Original Message - From: Steve Rapaport [EMAIL PROTECTED] To: Todd Williamsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 7:03 PM Subject: Re: Select statement with decimals as a record... Todd, this result is perfectly correct if they are both strings: 52.50 is greater than 358. To make them interpreted as numbers instead, see the manual page: http://www.mysql.com/doc/C/o/Comparison_Operators.html Steve Todd Williamsen wrote: I have a record that keeps track of averages, now when I say SELECT * FROM tblname ORDERBY 'average' DESC; It returns the one with the largest amount of intergers... I.E. It will say that 52.50 is a larger number than 358, why is that? Is that a table column setting of a datatype? - 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 -- Steve Rapaport World Citizen - 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
newbie starting mysql on slackware freash install
I have searched the net and mysql site and ran accross this list. I'm sure I have a simple problem. BTW, does this list have a searchable archive? I hate to post something which I'm sure is common. Any way, I have a freash install of slackware and I selected the mysql option. If I just type mysql I get Error 2002: Can't connecto to local MySQL server through socket'/var/run/mysql/mysql.sock' (111) I read on the mysql site that this was sopposted to be in /tmp, but when I tried to copy it I get... :cp reading '/var/run/mysql/mysql.sock' : Invalid arguement If I type safe_mysqld I get Starting mysqld daemon with databases from /var/lib/mysql 011229 20:53:01 mysqld ended but I don't have a process running!!! under the directory /var/lib/mysql I have a file slackware.err if I cat it out it says... mysqld started /usr/libexec/mysqld: Table 'mysql.host' doesn't exist mysql ended Ok, if I can't start it how do I create a table? -nathan _ 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
DBD::mysql HElp
Hi, I'm trying to install DBD::MYSQL on Windows 2000 Pro. I've already install DBI Using ppm for ActivePerl I downloaded DBI and extracted it to a folder. Then i ran ppm intall DBI It installed fine. I did the exact same thing for DBD::MYSQL but i get the following error Error: Package 'DBD::mysql' not found. Please 'search' for ot first. Do you know why it is not finding it? Please help! Thank you Clinton - 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
php/mysql download
Does anyone have the location of a php-mysql-4.0.3 version that I could download? Tobe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: php/mysql download
If you're looking for php. suft on over to the PHP homeworld: http://php.net current version is 4.1.1 David Does anyone have the location of a php-mysql-4.0.3 version that I could download? Tobe - 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
unresolved external refernce (mysql_init) - help!!
Hi,
I'm trying to compile and link a small program on Win98 with borland's
free C compiler (version 5.5.1)
Here is the code:
(test.c)
#include winsock.h
#include windows.h
#include mysql.h
#include stdlib.h
#include stdio.h
int main()
{
MYSQL *mysql;
mysql = malloc(sizeof(MYSQL));
mysql_init(mysql);
printf(Initalization Done!!\n);
free(mysql);
return 0;
}
On the dos prompt I type :bcc32 test.c -lm -lmysqlclient -o and I get an
unresolved external reference for the call to
mysql_init during the link phase. The compile is clean.
I've also tried the following comand line input with the same outcome:
bcc32 test.c -o -lm -lmysqlclient
bcc32 test.c -lmysqlclient -o
bcc32 test.c -lm -lmysqlclient -lz -o
bcc32 test.c -lm -L\Borland\bcc55\lib -lmysqlclient -o/* i thought
this would work but it didn't */
The compiler has been set up correctly with bcc32.cfg and ilink.cfg
files. I have also put the -L command in the statement and that didn't
work either as you can see. All directories and settings have been
double and triple checked to be corectly set.
I downloaded mysql version 3.23 for windows about the end of November
2001. I've installed it and have had the server running, viewing
database tables and so on.
So I'm trying to write code to interact with the DB.
What am I doing wrong??
-
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 crashing.
Description: See earlier emails from me. Same problem. How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:[EMAIL PROTECTED] Organization: Auctionwatch.com MySQL support: login Synopsis: Mysql crashing. Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.43 (Official MySQL binary) Environment: System: Linux dbrspare-red.auctionwatch.com 2.4.17-rc2 #1 SMP Thu Dec 20 19:05:16 PST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010703 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Dec 14 11:06 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1155720 Jul 27 13:42 /lib/libc-2.2.3.so -rw-r--r--1 root root 2579358 Jul 25 08:15 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 25 08:15 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Here is the stack dump: 0x807b75f handle_segfault__Fi + 383 0x812bcaa pthread_sighandler + 154 0x815059c chunk_free + 596 0x8152573 free + 155 0x811579c my_no_flags_free + 16 0x80764d5 _._5ilink + 61 0x807b48d end_thread__FP3THDb + 53 0x80809cc handle_one_connection__FPv + 996 - 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: DBD::mysql HElp
Did you do install mysql or install DBD-mysql? Here's what the activestate page has to say: ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing ppm install DBI install DBD-mysql This will fetch the modules via HTTP and install them. If you need to use a WWW proxy server, the environment variable Now if you'll excuse me while i pull up my PHP soapbox. I find PHP a much more direct( and simpler) why to build dynamic web pages (if that's objective is?), and the user community *much* more helpful. http://php.net. As far as the Perl side goes: try the howto at http://perlmongs.org. -- 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
Security hole in mysqlhotcopy?
As far as I can tell, mysqlhotcopy does not provide a way of specifying the password anywhere other than the command line (e.g. it doesn't seem to read .my.cnf). Isn't this a security risk? I noticed that mysqlhotcopy *does* change its ps entry after it starts in order to mask the arguments, but if I'm not mistaken, there's still a brief moment when any normal user on the same system can do ps to capture the password. Also, the password can show up in places like .bash_history. - 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: Security hole in mysqlhotcopy?
You can usually try providing an empty -p parameter and be asked for the password afterwards. Bogdan Philip Mak wrote: As far as I can tell, mysqlhotcopy does not provide a way of specifying the password anywhere other than the command line (e.g. it doesn't seem to read .my.cnf). - 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: Security hole in mysqlhotcopy?
On Sun, 30 Dec 2001, Bogdan Stancescu wrote: You can usually try providing an empty -p parameter and be asked for the password afterwards. Doesn't seem to work: [mysql@lina mysql]$ mysqlhotcopy -u root -p test . DBI-connect(;host=localhost;mysql_read_default_group=mysqlhotcopy) failed: Access denied for user: 'root@localhost' (Using password: NO) at /usr/local/mysql/bin/mysqlhotcopy line 161 [mysql@lina mysql]$ mysqlhotcopy -u root -p test . DBI-connect(;host=localhost;mysql_read_default_group=mysqlhotcopy) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/mysql/bin/mysqlhotcopy line 161 - 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: Security hole in mysqlhotcopy?
mysqlhotcopy -uroot -p test . Philip Mak wrote: On Sun, 30 Dec 2001, Bogdan Stancescu wrote: You can usually try providing an empty -p parameter and be asked for the password afterwards. Doesn't seem to work: [mysql@lina mysql]$ mysqlhotcopy -u root -p test . DBI-connect(;host=localhost;mysql_read_default_group=mysqlhotcopy) failed: Access denied for user: 'root@localhost' (Using password: NO) at /usr/local/mysql/bin/mysqlhotcopy line 161 [mysql@lina mysql]$ mysqlhotcopy -u root -p test . DBI-connect(;host=localhost;mysql_read_default_group=mysqlhotcopy) failed: Access denied for user: 'root@localhost' (Using password: YES) at /usr/local/mysql/bin/mysqlhotcopy line 161 - 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: Security hole in mysqlhotcopy?
Ooops! Sorry, I tested it and it doesn't work! Sorry for misleading you... ;-) Bogdan Bogdan Stancescu wrote: mysqlhotcopy -uroot -p test . Philip Mak wrote: On Sun, 30 Dec 2001, Bogdan Stancescu wrote: You can usually try providing an empty -p parameter and be asked for the password afterwards. Doesn't seem to work: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A password column
Hello, I'm fairly new to MySQL and I was wonder if there was a way to, well let's say encrypt a password in a column? I would like to have a users table in my database and in it I would like to have a password column, but I don't want the password in plain text. Is this possible? Thanks, - Tom Jones [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
Which Database?
I am using a binary installation of MySQL for Linux 7.1...how do I tell what database it is configured to use for the backend? InnoDB or something else? -bryanw .BIZ, .INFO, .CC .COM, .NET, .ORG Pre-register your .NAME address now! http://www.halfpricenames.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: A password column
- Original Message -
From: Philip Mak [EMAIL PROTECTED]
To: Tom Jones [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 29, 2001 11:56 PM
Subject: Re: A password column
On Sat, 29 Dec 2001, Tom Jones wrote:
I'm fairly new to MySQL and I was wonder if there was a way to, well let's
say encrypt a password in a column? I would like to have a users table in my
database and in it I would like to have a password column, but I don't want
the password in plain text. Is this possible?
Use the PASSWORD() function. Example:
INSERT INTO users VALUES ('pmak', PASSWORD('secret'));
This is a one way hash. I think it works the same way on all MySQL
servers (i.e. it's portable).
-
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: A password column
If you are using PHP and do not want to pass clear-text passwords over a network to a
remote MySQL server, you can use the crypto
libs in PHP for one-way hashing too (I use MD5, for example).
- Original Message -
From: Philip Mak [EMAIL PROTECTED]
To: Tom Jones [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, December 29, 2001 11:56 PM
Subject: Re: A password column
On Sat, 29 Dec 2001, Tom Jones wrote:
I'm fairly new to MySQL and I was wonder if there was a way to, well let's
say encrypt a password in a column? I would like to have a users table in my
database and in it I would like to have a password column, but I don't want
the password in plain text. Is this possible?
Use the PASSWORD() function. Example:
INSERT INTO users VALUES ('pmak', PASSWORD('secret'));
This is a one way hash. I think it works the same way on all MySQL
servers (i.e. it's portable).
-
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 database questions
Hello Roger, Thank you for your note and feedback. With your assistance and reading up on InnoDB, I'm getting closer. Further inline; On 29 December 2001 22:21, Roger Baklund wrote; [snip-1] I think you would need to restart the mysqld server daemon, but this is very fast, and can be done with virtually no downtime. (1-2 seconds is my experience, I suppose this depends on a number of factors, so you should test it on your system.) [snip-2] I should also tell you that I have never used the Innodb table handler. [snip-3] innodb_data_file_path is used to define database partitions or 'tablespace' and define a size for those partitions. This must be changed when your tables are growing beyond the predefined size, and I suppose a restart is needed, but I don't know for sure. Roger, I attempted adding additional space with a new file under innodb_data_file_path as follows; Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M Stopped and restarted MySQL, but this did nothing. Could you please point me! Roger, I managed to place different databases each at altogether different locations using the filename.sym option. However, no matter how much data I loaded, the table sizes stay at 9kb. I don't understand this... how do you know what the size of the table is? As I said, I have never used Inndb, but the tables are stored within the ibdata files, are they not? So, how do you know how many kb? Knowing almost nothing about MySQL InnoDB, I looked at the .frm file, thinking they are the data files, and they have a file size of 9kb. This lead me to assume that when using the innodb option (for transactions), that the data is loaded in the ibdata files. If Yes, all data, including indexes, are stored in the ibdata files. Thank you for clarifying. this is the case then how do I place the ibdata files (related to the innodb option) at different locations for different databases? By setting innodb_data_home_dir to the root path and use a relative path in the innodb_data_file_path parameter, as shown in the example above. This will however not give you different locations for different databases... see below. This is also my understanding. It scares me. Thus when using MySQL with InnoDB, all data of all databases on my different website stages, viz., PROD, QA, DEV would share the same InnoDB dataspace for data. Thus PROD data is at risk. And furthermore, data cannot be backed up separately. I feel this is an oversight of MySQL InnoDB. And let me add further, my concern is that when I eventually go live, with a HSP, that my data would thus be shared further with other websites hosted on the same server. Surely I'm overlooking something. Could this please be logged as a major issue? [snip] That is correct, I have never used Innodb, and I don't use transactions with mysql. This being the case, a further thank you for assisting. [snip] In that case, I would guess the data is not stored there. :) Maybe you are looking at the .frm files? This is the table definitions only. Yes I was. Thank you for clarifying. [snip] ok, I think I understand now... :) Your _database_ is not innodb, your tables are: type=innodb is an option to the CREATE TABLE statement, not the CREATE DATABASE statement. As far as I can tell from the manual, you can not instruct mysql to keep one innodb table in one particular tablespace, in other words: you can _not_ put different databases on different locations, thus my answer to your questions #2 and #4 was wrong. Sorry! (again, I have never used innodb, there may be some way to this that I don't know about.) Again thank you for confirming and clarifying. Roger, thank you for all your assistance so far. I'm clearer on several things. Could you possibly assist me in taking the issue further; that with InnoDB sharing the same dataspace, and therefore different unrelated databases's data being at risk. Kind regards - 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
