Re: intersting bug with full text match against
Remember that (as of stable 4.0) this is a command line option (not mentioned in the docs). safe_mysqld -O ft_min_word_len=2 You then have to rebuild the indexes REPAIR TABLE tbl_name QUICK; --Joe On Thursday, May 29, 2003, at 08:47 PM, Daniel Rossi wrote: It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has length 2. If you want to search both exact matches use + operator in BOOLEAN MODE or phrase search: http://www.mysql.com/doc/en/Fulltext_Search.html ok well i'm soughting that out but how about the default boolean value ? ft_boolean_default='AND' if i set it to this , how can i explicitly go from AND to OR ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Stump - [EMAIL PROTECTED] http://www.jerum.com Software never has bugs. It just develops random features. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: table copy
REPAIR TABLE tbl_name QUICK; You could try that or check out myismchk (sp?) --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Cassily, Ryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 7:56 AM To: MySQL (E-mail) Subject: table copy I made the mistake of copying the MYI, MYD, and frm files of a table while the mysql server was running. Unfortunately the table is now reporting the following error: ./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in file: 'Table.frm' What is the easiest way to recover the table? Thanks. -- 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: Help MySQL Beginner please.
http://www.mysql.com There's a great manual that got me started. I'd also look on WebMonkey for some basic tutorials. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:10 AM To: [EMAIL PROTECTED] Subject: Help MySQL Beginner please. Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- 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: Connect via Internet
Just a simple point on security. The current stable versions of 3.23.x don't encrypt passwords or data. Thus you would be logging in unencrypted and sending all data unencrypted. If this is just a dev box and you don't care about the data then it probably isn't a big deal. If it's a production box you'd be nuts to put it on the internet. Versions 4.x and above support SSL. You'd have to check the mysql site for the specifics. Even with SSL support I'd be wary of putting a db server on the internet. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Jon Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 11:12 AM To: MySQL List Subject: re:Connect via Internet Okay, got the system up and running locally. The programmer wants to be able to access the MySQL server via the internet. We have MySQL installed on a Linux server, this sits behind a firewall with port 3306 opened. The programmer has phpMyAdmin installed on his laptop (Widows XP Pro). We keep getting a 'cannot connect to server on 'domain'' error. Also I want to have a logfile setup to log this type of problem. I see nothing in the /var/log/messages or /var/log/mysql.log. In /etc/my.cnf I have the following: [mysqld] datadir =3D /var/lib/mysql socket =3D /var/lib/mysql/mysql.sock [mysql.server] user =3D mysql basedir =3D /var/lib [safe_mysqld] err-log =3D /var/log/mysqld.log log =3D /var/log/mysqlquery.log pid-file =3D /var/run/mysqld/mysqld.pid Will changing the line that contains the myql.sock to tcp help? Any suggestions? Thanks -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FreeBSD + MySQL bottleneck
This may help - I just got this from a friend. http://jeremy.zawodny.com/blog/archives/000203.html --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Matthias Trevarthan [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 7:16 AM To: [EMAIL PROTECTED] Subject: FreeBSD + MySQL bottleneck Howdy list, I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE. We recently had a BBS get hammered by a lot of concentrated traffic. I currently run a 'mysql-optimize.sh' script from cron on Wednesday and Sunday that executes: ${bindir}/myisamchk -i -r --check --sort-index --analyze ${datadir}/*/*.MYI ${bindir}/isamchk -i -r --analyze --sort-index ${datadir}/*/*.ISM This works great to keep my databases lean and mean for normal server load and traffic, but this last hit was just too much. The server was bottlenecked somewhere. Problem was, I couldn't figure out where! I'm running SCSI 160 disks in a Raid config, with a dual 1GHZ PIII and 1G of SDRAM. I'd think that setup would be able to handle some pretty killer loads... Anyway, I ran 'top', and MySQL was turning about 97% processor utilitzation on one processor. It said I still had 128M of free ram left (and my MySQL tables are all under 10M). And I was only using 3% swap, which is normal because I run phpa_accelerator. Also, 'mysql show status;' showed that I only had about 25 threads open at a time. And it also said I had 82 tables open. My T1s were NOT maxed out. They weren't even half full, and besides: I accessed the BBS from our 100Mb switch, and it was still dog slow (20-30 seconds for a page load), which means it was purely a bottleneck in my machine. So, my questions are these: --- Can any experienced MySQL-FreeBSD admins out there give me some pointers for identifying bottlenecks? Specifically, I don't know how to determine if my disks were being maxed out. Could someone give me some pointers? And also, from 'show status', is the number of 'threads' directly related to the specific number of MySQL socket connections? (I have MySQL setup to allow up to 200 and I wasn't even getting over 30 from 'netstat | grep -i mysql') Any help would be appreciated! Thanks! Matthias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: redirect mysql output to file
In *NIX you could do this: $ echo sql commands here | mysql -uroot -ppassword -hhost database /path/to/file For extra scripting fun you could backup tables using this: for i in `echo show databases | /usr/local/mysql/bin/mysql -uroot | grep -v Database` do mysqldump -uroot $i /path/to/backups/$i.sql echo $i done --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Mike Doanh Tran [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: redirect mysql output to file Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table test_table.file without doing a MYSQLDUMP. thanks, MT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: # of Business Days?
I'm not sure of an exact query, but if you can get the total number of days you can mathmatically get the biz days with the following math (in psuedo code): $days = total_days_between_a_and_b; $weeks = ($days / 7); $weekend_days = $weeks * 2; $business_days = ($days - $weekend_days); Hope this helps. There may be more elegant ways of getting such a value. This doesn't take into account day A being wednesday. You might be able to do a SELECT COUNT(*) on evaluating your date to it's Day value in ('Mon','Tue','Wed','Thu','Fri') Check the date commands. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Lucas Cowgar [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:59 AM To: MySQL Mailing List Subject: # of Business Days? Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. TIA! Lucas Cowgar Information Technologies Department Eldorado Services Group Inc. http://www.eldoserv.com [EMAIL PROTECTED] (330) 861-3009 All your base are belong to us - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ?
I would assume the Win version comes with mysqldump - just mysqldump -uuser -ppassword -hhost database. You *might* be able to copy the data directory (someone else should chime in on this). --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Theisen, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 9:59 AM 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: How to write delete query??
What you have there is a subselect, which are not supported in mysql 3.2x, but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my word for it and check the docs first. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 6:35 AM To: [EMAIL PROTECTED] Subject: How to write delete query?? SQL SQL hi all, i have a query that works just fine on Dbase, but just crashes on mysql. How can i write it in one statement for it to work both on Dbase and mysql? the query: - delete from table1 where table1.field1 in (select distinct field2 from table2). Thanx _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB / MyISAM
-- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:29 AM To: Joe Stump Subject: Re: InnoDB / MyISAM Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've been looking into switching to InnoDB. I have a few questions though. 1.) Can I do joins between InnoDB / MyISAM tables? 2.) Do FK restraints work if the FK referenced is in a MyISAM table? I'm trying to get the best of both worlds. I'd have a data table with FULLTEXT and then have join tables, etc. InnoDB so I can have transactions and FK restraints. I've looked through the archives and couldn't find any answers to these questions. BTW, I'm using 4.0-gamma right now. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0 + PHP 4
Anyone out there have anything to share as to using PHP4+MySQL4. I've been hearing good things on the MySQL list about v4.0 and I'm thinking of upgrading, since I run a rather small server. Thanks! --Joe ps. PHP list responders please respond directly. I'm not currently subscribed. -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl DBI $sth-fetchrow_hashref() persistence?
I'm not sure how Perl works on variable assignment. If $sth is passing a reference to $record finish() may kill the variable $record holds a reference to during garbage collection. If it *assigns* the row to $record (meaning $record holds a copy of the record data and not a reference to where the data is actually stored) then you should be able to use it all you want. Maybe one of the many perl monks will know more. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 6:22 AM To: [EMAIL PROTECTED] Subject: Perl DBI $sth-fetchrow_hashref() persistence? Hi, if I call: my $record = $sth-fetchrow_hashref(); then: $sth-finish(); How valid is it for me to keep referring to my $record hash pointer? Thanks, Jeff Snoxell Aetherweb Ltd http://www.aetherweb.co.uk [SPAM FILTER FODDER: MySQL, QUERY] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: subselect workaround help?
I think the problem is in your table structure. If you did this: Students: - Name - StudentID Classes: - ClassID - Name StudentsClasses: - StudentID (PK) - ClassID (PK) (You make them a combined key by doing PRIMARY KEY (StudentID,ClassID) in your table def.) When you add a student to a class you add them to StudentClasses table. In your previous layout (which was not normalized completely) you are repeating Name/StudentID each time a student is put into a class (redundant data is a no-no). Now to get all classes you just: SELECT C.* FROM Classes AS C, StudentsClasses AS R WHERE R.StudentID='364326' AND R.ClassID=C.ClassID --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Lefevre, Steven [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 8:22 AM To: [EMAIL PROTECTED] Subject: subselect workaround help? Hey folks- 'nother question. I'm not an SQL expert, and I think I need a subselect, which means I need a workaround on MySQL 3.23 or whatever version it is. Here's the tables I have, with the relevant columns: Students - Name - StudentID (PK) - ClassID Classes - ClassID (PK) - Name Each Student belongs to one class. So, I have the StudentID. I want to get the Classes.Name... Final result should look like Student | Class -- Steve Lefevre | Math101 Stacy Adams | Intro to SQL Something like SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.StudentID = . $ID . AND Classes.Name IN ( SELECT Classes.Name FROM Classes WHERE ClassID = Students.ClassID ) I know that probably won't work as a subselect query, but that's my starting point. Any help? Thanks! Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: column name
Check out the alter table syntax ... something to note you can't just change the name - you have to retype the whole column signature: ALTER TABLE [table] CHANGE [old column name] [new column name] [old column definition]; ie. ALTER TABLE users CHANGE st state char(2) NOT NULL DEFAULT 'MI'; --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 8:30 AM To: [EMAIL PROTECTED] Subject: column name Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this one: how do I change a column name? Gian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Using PHP to do a MySql Dump
You could do an SELECT * INTO OUTFILE (the documentation is on mysql's website). --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Using PHP to do a MySql Dump Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
Without trying to sound like a troll or a rant I'd like to chime in on the side of Jeremy. I've worked with MySQL on sites that serve up over a million hits a day. We hit the 2gb file limit in Linux (NOT a MySQL problem) and moved to Solaris without incident. A friend of mine had over a billion rows in a few of this tables (statistical data mostly). As Jeremy points out all DB's have their problems, shortcomings, etc. If you have specific complaints fill out a feature request, if you've got problems fill out a bug report, but don't knock MySQL as not-worthy-of-enterprise-status because it doesn't *work* like Oracle, etc. Overall, in my many experiences, it is more than sufficient for web apps. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:09 AM To: Michael She Cc: Qunfeng Dong; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Can MySQL handle 120 million records? On Wed, Dec 18, 2002 at 02:37:07AM -0500, Michael She wrote: I agree. MySQL is a great database, but I wouldn't call it enterprise grade. Since you haven't told us what enterprise grade means to you, that doesn't tell us much. What is it lacking to become enterprise grade in your mind? Considering that the database is used to store billing information... one has to be weary about losing all the records due to a bug or deficiency in MySQL. That's true of any database server, right? It's not really a MySQL-specific complaint. I was searching through some of the MySQL help documentation, and there have been more than a few examples in the comments where people have lost data due to wacky functions on databases greater than a couple of GBs... Imagine what you'd read it Oracle was open enough to allow comments in their on-line docs. Seriously. I've heard pretty nasty stories about Oracle, Microsoft SQL Server, and so on. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 3 days, processed 136,618,914 queries (457/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can MySQL handle 120 million records?
1. MySQL hasn't been proven yet in the corporate environment Is Yahoo! proven enough? Seriously, how many large corporations have to use a DB in order for it to be proven? Is Access proven because every company on the planet uses it at some level? 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. Like previous posters have pointed out. If given the same freedom within Oracle's online documentation you'd have to believe there would be horror stories outlining loss of data. The main questions you have to ask yourself are as follows: - What type of application am I programming? - What type of features do I need in my DB? - How much data am I storing? - What type of data am I storing? - How much traffic will this database see? - How much money can I spend? If you're storing massive amounts of video and sound within the actual DB then maybe Oracle is the choice for you. If you need seemless integration with VB then MS SQL might be the best candidate. If all you need is data and speed then any DB on the planet would work (if your traffic was low enough XML in flat files would work). We aren't saying MySQL is the best DB for every task, but what we are saying is MySQL is proven to be more than adequate for all sorts of tasks - it just depends on which task you need your DB to perform very well in. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net 1. MySQL hasn't been proven yet in the corporate environment 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. -- 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
RE: Sorting Results
ORDER BY field ASC|DESC --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql query, to sort the query results in alphabetical order, IE... going from A... to ..Z. This would be like titles of mailing lists. TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 MSN: [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: Newbie- Help with query
You need to do a join ... SELECT T.* FROM transport AS T, acl AS A WHERE T.id=A.id AND A.adminId='1' --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark Sent: Wednesday, December 11, 2002 10:26 AM To: [EMAIL PROTECTED] Subject: Newbie- Help with query Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from the transport table where the transport id = a query agains the acl table (select transportId from acl where adminId='1'). When I try this I get a sql error, what do I need to do differently? Thanks in advance, Max mysql describe transport; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| smallint(5) unsigned | | PRI | NULL| auto_increment | | domain| char(50) | | UNI | || | transport | char(50) | | | || +---+--+--+-+-++ 3 rows in set (0.01 sec) mysql describe acl; +-+--+--+-+-+--- -+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+--- -+ | id | smallint(5) unsigned | | PRI | NULL| auto_increment | | adminId | smallint(5) unsigned | | | 0 | | | transportId | smallint(5) unsigned | | | 0 | | | securityId | smallint(5) unsigned | | | 0 | | +-+--+--+-+-+--- -+ 4 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Want to create mySQL user through phpMyAdmin
Did you reload the privileges? --Joe On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote: I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program ? $conn = @mysql_connect (localhost:/usr/home/nets/mysql/mysql-demo.sock, manisha, pass); echo(before conn a); if ($conn){ mysql_select_db (demo); echo(conn got it); } ? but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: backing up mySQL database ?
I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 10:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
problems querying the list
For some reason I can't send messages to the mysql list - any ideas why? I don't even get a bounce message! --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NFS Problem
I have mysql installed and working on Solaris 9 using the binaries from the mysql site. I have an NFS server running under Debian GNU/Linux 3.0. I am able to mount NFS mounts on the Solaris box from the Linux box without any problems. I'm able to read/write without incident. Now here comes the problems. I mount my NFS mount as MySQL's data dir (in this case it's /usr/local/mysql/var), which works fine. I then am able to start the MySQL server, but when I try to connect the connection just hangs. The same goes for PHP pages attempted to connect to the DB server. Then I run the DB files locally it works just fine. Any ideas what is causing this? --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql test
This is a test to the sql list. I sent a message concerning MySQL+NFS problems and it didn't go through. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, how to get total rows matched when using LIMIT 0, 10?
The mysql_num_rows() function returns the number of rows returned in your record set, which when limited is 10 (not 100). Thus you will have to do another query. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: SED [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 4:54 PM Subject: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10? I'm trying to get the total matched rows when I'm using LIMIT 0, 10, but I only get the number 10, when the total should be around 100. So, can I get total matched rows without doing a separate query using count()? Here is an example of my current query: $result = mysql_query(SELECT * FROM products WHERE price'10' ORDER BY price LIMIT 0, 10); $num_rows = mysql_num_rows($result); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hello?
I didn't get a confirmation mail or anything so here goes ... I'm trying to compile a simple C program to access a db and dump out the info (for testing purposes). Here is what I get when I try to compile it: ebulon:/var/www/www.miester.org/cgi-bin# gcc -g -o miesterc miesterc.c -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib -lmysqlclient -lsocket -lnsl /usr/bin/ld: cannot find -lsocket collect2: ld returned 1 exit status I have installed the deb package socket ... not sure what I need to do from here (I'm somewhat new to C as well ...) Thanks for any help and please cc me since I'm not sure if I'm on the list yet. Thanks! --Joe Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU/Linux --Joe Stump - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 upgrade MySQL without breaking PHP/Apache?
You should be able to change your mysql.sock in your my.cnf or php.ini file and it will work. I'm thinking that it's a sock error you are getting. --Joe On Mon, Jun 11, 2001 at 09:43:56PM -0500, Whit Blauvelt wrote: Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then Apache/PHP cannot connect to the database (using the mysql routines internal to PHP), so I'm left having to --force --nodeps a downgrade to keep the system up. Now, PHP can be compiled to use the current MySQL libraries, but the last time I had to do that (with an install of MySQL 3.23.37 from binary tar to a Debian box) a needed MySQL library or two wasn't on the system, and to get it I had to compile MySQL from the source tar. Okay: 1. Is there a way to just get PHP/Apache to talk to the current MySQL without recompiling to reference the current MySQL libraries? 2. Does the development rpm actually contain what I'll need to point to if I _do_ have to recompile everything? 3. Considering that PHP/Apache is one of the most common MySQL front ends, why isn't this set of problems prominently dealt with in the documentation, if not avoided through clever programming and/or making sure the PHP team has early access to any interface changes coming along? Whit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU/Linux --Joe Stump - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php