RE: printing reports
About Access I can only say that it's very useful tool for a lot of people and there is a lot of places where it makes perfect sense to use Access. I don't claim it's a perfect reporting tool for all kind of reports, but depending on the requirements it may be the right tool for a specific problem/user combination. (I will not go into details as this is not important for this discussion; I am sure anyone with a little goodwill can come up with a scenario where Access would be a reasonable solution). I certainly can. We have a client who is using Access as a report writer/generator for a back-end SQL Server database, whom we are trying to convince to move to MySQL on the back-end. One of the advantages to using Access on the front end is that there's little work that needs to be done to move their reports and data from SQL Server to MySQL (just regenerate the ODBC links from SQL Server to MySQL and you're pretty much done), and the end-users all love Access for its ease in producing reports. Anything else more powerful would be unusable - when I say end user, that's exactly what I mean - very non-technical. Access is a very good tool to give them, because they can produce ad-hoc reports to their heart's content without having to ask the IT staff for assistance. -- Ed Carp, [EMAIL PROTECTED] (850) 291-1563 Director, Software Development Escapade Server-Side Scripting Engine Development Team Squished Mosquito, Inc. Pensacola, FL http://www.squishedmosquito.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: test, please ignore
On Thu, 16 Jan 2003 [EMAIL PROTECTED] wrote: sql,query,queries,smallint -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team http://www.squishedmosquito.com Microsoft Front Page - the official HTML editor of Al Qaeda Microsoft Hotmail - the official email of Al Qaeda - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: getting name of columns
How can i extract names of columns from table? I am doing select * from table, then i want to get name of columnsis it possible? show columns from XXX where XXX is the name of the table. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: database corrupted after power switched off
is it a normal behaviour that a sql databases gets corrupted if the power of the whole system will be switched off while an application is writing to the database ? Yes. what can i do that this problem does no more appear ? Buy a UPS or shutdown the system normally. NEVER just turn off power to a computer. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: plz help...tables getting corrupted...
corrupted. The most common error messages which I encountered are : Can't open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table handler. I rectified it by shutting down the MySQL Server and using myisamchk with the options -r and sometimes -o. 145 = Table was marked as crashed and should be repaired Is there anything I can do to avoid such errors to occur in future ? Yes. Stop your machine from crashing :) Don't these errors make MySQL unreliable ? Not at all, considering the nature of the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: phpmyadmin
If one cannot avoid using PHP how can I secure it? I will initially have it on the same server as IIS. There is a wrapper program that temporarily elevates PHP's permissions, so that the PHP scripts don't have to be world-readable. Can't remember what it is, offhand, though. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpmyadmin
A quick question: Is phpmyadmin secure? Anyone have an negative experiences having it installed on their server? PHP itself is not secure unless special steps are taken to secure it, and even then it's no guarantee. There have been several exploits published against PHP, and a few of them have been root exploits. I avoid PHP when I can, especially on shared servers. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Question about AUTO_INCREMENT
From http://www.mysql.com/doc/en/Miscellaneous_functions.html: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. See section 8.4.3.126 mysql_insert_id(). mysql SELECT LAST_INSERT_ID(); - 195 The last ID that was generated is maintained in the server on a per-connection basis. It will not be changed by another client. It will not even be changed if you update another AUTO_INCREMENT column with a non-magic value (that is, a value that is not NULL and not 0). If you insert many rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row. The reason for this is to make it possible to easily reproduce the same INSERT statement against some other server. If expr is given as an argument to LAST_INSERT_ID(), then the value of the argument is returned by the function, and is set as the next value to be returned by LAST_INSERT_ID(). This can be used to simulate sequences: First create the table: mysql CREATE TABLE sequence (id INT NOT NULL); mysql INSERT INTO sequence VALUES (0); Then the table can be used to generate sequence numbers like this: mysql UPDATE sequence SET id=LAST_INSERT_ID(id+1); You can generate sequences without calling LAST_INSERT_ID(), but the utility of using the function this way is that the ID value is maintained in the server as the last automatically generated value (multi-user safe). You can retrieve the new ID as you would read any normal AUTO_INCREMENT value in MySQL. For example, LAST_INSERT_ID() (without an argument) will return the new ID. The C API function mysql_insert_id() can also be used to get the value. Note that as mysql_insert_id() is only updated after INSERT and UPDATE statements, so you can't use the C API function to retrieve the value for LAST_INSERT_ID(expr) after executing other SQL statements like SELECT or SET. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.com The whole aim of practical politics is to keep the populace alarmed-- and thus clamorous to be led to safety-- by menacing it with an endless series of hobgoblins, all of them imaginary. -- H. L. Mencken -Original Message- From: Romans Stepanovs [mailto:roman16;btv.lv] Sent: Wednesday, October 23, 2002 6:47 PM To: [EMAIL PROTECTED] Subject: Question about AUTO_INCREMENT Hello, I'm a newbie in MySQL and also in this mailing list. I've a problem and I hope some gurus can help me. So the question is: How to obtain an index of the row which is inserted ? for example : INSERT INTO some_tbl (ID,field1) VALUES ('','blahblahblah'); I need 'ID' to use as reference value in different rows in another table. Is it possible to get 'ID' in the same query or I need to do something else? Thanks, Roman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 execute sql commands from a file?
is there a way to execute sql commands from a file? What would be the syntax to do it? I was trying mysql @theFile, but it doesn't work. mysql thefile - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: connecting to remote server
If I type the following at the command prompt, in this example I'm using username for the user name, and 66.66.66.66 for the IP address (although I use real values) mysql -h 66.66.66.66 -u username -p it asks for my password then goes off and thinks for a while before coming back with: ERROR 2003 - can't connect to MySQL server on 'ip address' (port) 1. Try to telnet to port 3306 on the server. Do you get any response at all? If it doesn't connect, either MySQL isn't running or it's not enabled remote connections. If it connects but just sits there and doesn't give you back a few bytes of junk, you have a different problem ;) 2. If you can connect and get garbage, you'll have to get on the server itself (or gain access to the server as a privileged user) to do anything further. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't Restart Server
021022 17:54:13 mysqld started 021022 17:54:13 bdb: PANIC: No such file or directory 021022 17:54:13 Can't init databases 021022 17:54:13 mysqld ended Have you tried all the obvious things before you posted? [mysqld] datadir=/var/lib/mysql Is this directory exist - if so, what's in it? If there are databases there, have you run the repair utility? sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't Restart Server
At 18:26 -0500 10/22/02, Ed Carp wrote: 021022 17:54:13 mysqld started 021022 17:54:13 bdb: PANIC: No such file or directory 021022 17:54:13 Can't init databases 021022 17:54:13 mysqld ended Have you tried all the obvious things before you posted? All the obvious things being what? The ones I list below? [mysqld] datadir=/var/lib/mysql Is this directory exist - if so, what's in it? If there are databases there, have you run the repair utility? sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Which port?
does the mySQL always use the same port and which port would it be? Is it configured in a file? Port 3306. I believe it can be changed via my.cnf and on the command line. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: why so late with Mac OS X versions?
Marc Liyanage has been doing MacOS X binaries in Switzerland. When I lived there, they took month-long vacations, two-hour lunches, and frowned on weekend work. Maybe he has a life outside of MySQL? :-) How do I get a job in Switzerland? ;) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Slow opening a recordset
Does anybody know how I can solve this problem? How can I improve the opening performance? Does MySQL cache something for each records? It's not a MySQL problem, but a problem how you're opening the recordset. In VB, you would set the DBSQLPassThru flag - I don't know what the equivalent is in Windows C. The problem is that the client is downloading the entire record set and oding the select on the PC when you do the open - that's why it takes longer the bigger your table is. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: about use Dev-cpp and C++
what's nested SQL? can you tell me more about it? Nested SQL allows you to do all kinds of interesting things in MySQL that you can't do now - sub-selects, for example; or if you're a lazy programmer (like me!) you want to do grouping and sorting in ways that would be difficult (and complicated) with an ordinary SQL query. For example, suppose you had two tables - a users table and a messages table. You suspect that you've got orphaned records in the messages table, but you're not sure. You also want to do other stuff to each message as you go through it. So, you decide that you want to iterate through each record in the users table, setting a flag in the messages table for each message that isn't orphaned: char cmd[256]; /* you could also do an ExecuteSQL() here, too */ OpenRecordset(update messages set OK='N'); CloseRecordset(); /* or ExecuteSQL (update messages set OK='N'); */ OpenRecordset(select * from users); while(RecordsetEOF() != EOF) { /* ID in the users table has a one-to-many relationship to usersID in the messages table */ sprintf(cmd, update messages set OK='Y' where usersID=%s, GetField(ID)); OpenRecordset(cmd); CloseRecordset(); /* could also do a ExecuteSQL(cmd); */ MoveNext(); } CloseRecordset(); /* now, we want to see which records are orphaned */ OpenRecordset(select * from messages where OK='Y'); while(RecordsetEOF() != EOF) { /* do whatever here */ MoveNext(); } CloseRecordset(); Of course, this is a simple example. PLEASE DON'T POST QUERIES SHOWING HOW THIS COULD BE DONE EASIER OR FASTER OR WHATEVER IN SQL! I'm sure you can think of a lot of other examples where doing a sub-select would be very cool, but MySQL doesn't support it. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: password
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Is there an way to get out of my way? Uninstalling mysql-server and installing again didn't do the trick Look in the manual FIRST before porting, please - this is a very common problem and one that's covered in the manual. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: /tmp/mysql.sock
I copied my.cnf to /etc and /var/db/mysql and made a file mysql.sock in tmp (/tmp/mysql.sock) What do I put in mysql.sock? Nothing. The server creates it when it starts up. Read the docs. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Urgent Help needed
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Nope, you read it wrong, both of you. MySQL is printing out YOUR IP address, not the address of the server. It's complaining that you don't have permission to access the data you want. sql, query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Connecting to MySQL on Linux from a Windows machine.
Thank you, but at this point I am pretty sure that my problem is not a matter of entries in the user table. When I attempt to telnet into port 3306 the connection is immediately dropped. I don't really know if any connection is actually established at all, it may be established and immediately dropped on simply refused from the start. There does not appear to be any exchange of user names or passwords. I have several variations of my username and host name in the user table. I believe that one of them should have worked if that was the problem. If you try and telnet to port 3306 on the machine that MySQL is running on, you will see the connection being established, then you'll see garbage, as MySQL is designed to talk to clients on that port, not humans ;) If you are seeing the connection being established, then *immediately* dropped, not refused, then the problem may be in MySQL. If the connection is refused, this is a different issue. Depending on what version of MySQL and Linux/whatever you're running, I believe there's a verified problem with MySQL and RedHat Linux - mismatch of glibc version, I think. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: about use Dev-cpp and C++
sql, query But it would be so nice to write: MySQLConn DB = new MySQLConn ('host', 'port'); DB.Login('user', 'pass'); MySQLTransaction X = new MySQLQuery(DB); // STL-derived slist: MySQLResults Results = X.Query(...); // STL map: map Row; while (Results.NextRow(Row)) { cout ID: Row[ID] , Value: Row[Value] endl; } ... PS, anyone seen such an API? :) How about: OpenDatabase(host, database, user, pass); OpenRecordset(select * from blah); while(RecordsetEOF() != EOF) { printf(ID: %d Value: %s\n, GetField(ID), GetField(Value)); MoveNext(); } CloseRecordset(); } Look for MyC on mysql.com - if you can't find it, email me directly. The most recent version supports nested SQL, too. The Escapade server-side programming language is built on top of MyC. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.com The whole aim of practical politics is to keep the populace alarmed-- and thus clamorous to be led to safety-- by menacing it with an endless series of hobgoblins, all of them imaginary. -- H. L. Mencken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQl db as filesystem.
-Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 5:53 AM To: Ed Carp Cc: [EMAIL PROTECTED] Subject: RE: MySQl db as filesystem. On Fri, 2002-10-11 at 10:06, Ed Carp wrote: At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? What does that mean? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query Should'nt be too hard to do thanks to PODFUK® AKA uservfs: Just goes to show you that Linux is so flexible, any hare-brained idea can be implemented in software sigh. But you didn't answer my question - why would you want to do such a thing? How could it possibly be useful? Adding yet another layer of complexity to ext2fs (or ext3fs, which makes even less sense) is insane, unless you're doing it just to say you can (same goes for the idiotic idea of building an interface into MySQL to produce XML output), or for a *very* specialized application. But, as Jeff Goldblum said in the movie Independence Day, (paraphrase) Just because you can doesn't mean you should. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQl db as filesystem.
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:57 PM To: Alex Polite; [EMAIL PROTECTED] Subject: Re: MySQl db as filesystem. At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? What does that mean? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: copy one database to another
I dont think that there is any SQL statement to do that. No, just use mysqldump to do it. sql, query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)
On Monday 07 October 2002 12:04, Edwin Raj wrote: When I type mysql in the command prompt it is giving the error ERROR 2002: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111) There is no file mysql.sock at that location??? Exactly. What is the problem amd what should I do to make it run? I didn't install MySql on my own and it was a default built on the OS installation. I don't know your installation in details, but I assume it is probably configured for TCP/IP connections only, so you would need the -h option. Unfortunately, all of your advice is probably not germane to the problem. Does the file /tmp/mysql.sock exist? If so, the easiest thing to do is to ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RES: Performance Question.
Don't forget that MySQL is the fastest thing on the planet for your (and mine) kind of simple query and insert/updates. We measured 12 times faster performance in MySQL than Oracle in one part of our application, and I strongly believe that in the MySQL case the Java program overhead became significant, but that was never measured. Actually, the fastest is probably a binary search against a file of sorted, fixed-length records, but that's a subject for another post ;) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re: Server comparison running Mysql
-Original Message- From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 06, 2002 9:04 AM To: James Riordon; [EMAIL PROTECTED] Subject: RES: Re: Server comparison running Mysql Another thing... I noticed once when I moved a website from one server to another, that when exporting/importing the MySQL databases, there was a few errors which theoretically shouldnt have been possible to get. Illegal/duplicate indexes etc. I had to override and supress error messages to actually be allowed to import the database at all. (Even if the original database worked - appearantly - perfect on the original webserver) How did you move the tables over? I've never had a problem moving databases between machines when I use mysqldump like mysqldump -C --add-drop-table blah --databases DB1 DB2 DB3|rsh newhost mysql. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Performance Question.
I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run queries on datasets of 220,000 SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time than I can count (0.1 sec at a guess) The insert/update bit is the bit which will dictate the speed - how many records need updating? Don't forget the considerable overhead of PHP itself. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Performance Question.
I am hesitant to dig into C++ just to solve this problem, so I am as far as possible trying to solve the performance issues within Java and MySQL. I will probably rewrite the code countless of times just to see if I can do it, and last resort would be C++. Why dig into C++? MySQL has a perfectly good C API, and if you use MyC, it makes it even faster and simpler to write MySQL applications in C. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Performance Question.
Thats a pretty nifty speed. PHP have a considerable overhead compared to new versions of Java. (I use both languages... I prefer PHP for webpage generation, but Java for serverside applications) And both have a significantly larger overhead than C. Have you tried Escapade? It's a simple, fast scripting language without the bloat of PHP, and it's considerably simpler. We use it for all of our web sites we do for clients. It's free, by the way. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: client library no longer LGPL licensing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The change is made to avoid lots of discussions about when the GPL is effective. Basically we follow the same rules as we always have about when we want people to pay us for a commercial license but now we have a better legal ground to base it on. I hope it will save us (especially me since I have become the MySQL licensing guru :-) lots of discussion about who has to pay and who can use the GPL version. And of course this is totally in the line with what the Free Software Foundation and RMS wants since it spreads free software. We can still make exceptions and allow free use if there is a good reason for it (But not for I like to make money without freeing my code or paying you like reasons). So the goal is to get money out of the people who distribute non OpenSource application using MySQL. We need the income for the much larger development team we now have. And the cost of running a real company instead of the administrative mess that Monty and I had earlier (And that mess was very very bad for my ease of mind). Does this also apply to non-open-source but free applications? For example, we give away Escapade for free - always have, always will, at least for the minimal version of the product. If we develop a non-free version of Escapade that uses mysqlclient, what happens then? We also distribute statically-linked and dynamically-linked versions of the product, and I would be interested in knowing MySQL's position on this issue in regards to licensing. - -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.com The whole aim of practical politics is to keep the populace alarmed-- and thus clamorous to be let to safety-- by menacing it with an endless series of hobgoblins, all of them imaginary. - -- H. L. Mencken -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBPZI6FkbhwAGg7YRjEQI/6gCfcnE/vxjAdVXrUs3LTuNUafxRb9sAn3kT A86wjGjw2TYgqhPfPi9V6bna =P6pl -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way?
I want to have manual startup/shutdown but still am not sure of the appropriate way to do this. Change the startup type from Automatic to Manual. The Computer Management utility allows me to stop the service and/or change the service startup type to manual or disabled. Is disabled the same as removing the service? No. Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is appropriate for standalone? Read Paul's previous post. Like Paul said: Alternatively, if the service is registered, you can change it to be a manual service rather than an automatic service. Then you use the Services Manager to start it up as a service, but you have to do so yourself. It won't start whenever Windows starts. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default Win install -- mySQL autostarts when booting?
Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. WinXP Home is MUCH more stable than ME ever dreamed of being. And yes, you can run services under XP Home. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
Might want to look at writing either a shell script or doing it in C, if it has to be non-interactive. Escapade can also do thos sort of thing interactively, and it's as simple as 4 lines of code. - Original Message - From: Keith Burke [Experience IT] [EMAIL PROTECTED] To: 'Michael T. Babcock' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 06, 2002 10:00 AM Subject: RE: [MySQL] HELP: Can MySQL run external programs... Sendmail for example Michael T. Babcock wrote: May I rephrase your comment? I need to send E-mails to people from MySQL data. I recommend just doing a SELECT on the data in question and generating the E-mails from PERL or PHP or whatever other language you are using. No you may not ;-) *joke* It needs to be run automatically without user intervention [cronjob] so the PERL [not an option as I've never used it] or PHP would have to be of the CGI variety [if that's what you call the standalone version, not the API for the web server]. But it is an option and I'll consider. I'll probably try the suggestion by Ralf Narozny first. It seems to be exactly what I want, plus... It's relatively simple :-) I'll also have to read up on those UDF's. Sounds interesting. Cheers everyone. Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 xxx * * Unit G6 * GSM : +353 86 xxx * * Riverview Business Park * Email : [EMAIL PROTECTED] * * New Nangor Road * WWW : http://www.experience.ie * * Dublin 12 * * * Ireland * * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: storing dabase on linux ramdisk
If you want it to be as fast as possible, you might want to consider doing the following: 1. Arrange your data so that the records are fixed length. 2. If possible, switch to something other than a relational database. A binary search on fixed-length, sorted records is probably going to be your fastest option. It's also got MUCH less overhead in regards to meta-data. This works great for read-only data. 3. Don't use PHP, ASP, Perl, Escapade, or any other interpreted language - write your code in C, it will be MUCH faster than any sort of interpreted language. Even with Escapade, which is far faster than any of the other three, is put to shame by compiled C. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Joseph Monti [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 10:41 PM Subject: Re: storing dabase on linux ramdisk I don't know anyone who's done it but I can think of no reason why it wouldn't be possible. Now whether it is a good idea is another idea entirely. Without a live backup server (slave) running off hard disk and a very powerful battery backup system, you're just begging to lose all your data. No matter how much you think that your data isn't important, you find out how much it is necessary right after you lose it. Another issue: data growth. You would think that it wouldn't need over 1GB of space, but it isn't uncommon for databases to grow well beyond their initial concepts... just like John Roach's statement about 640k... nobody will ever need more than that, right? Now we're running over 5,000 times that in systems and starting to need more for some tasks. While you probably won't need it today, having a system that will support addressing 4GB of RAM is not necessarily a bad idea in a situation like what you're talking about. Either way, you should get a HUGE performance increase from switching to running off RAMdisk. Is it practical? It can be... but only if you've got a slave system with the data running off a nice, fast RAID 5 array with a big, fat read cache. Are there situations that I can think of where I would want to do it? Sure, but they all involve massive conversational AI systems. Matt - Original Message - From: Joseph Monti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 11:21 PM Subject: storing dabase on linux ramdisk I've got a question about MySQL that I've been wondering but havn't been able to try. Would there be a noticable performance gain if I were to put my tables on a Linux ramdisk (disregarding any size constraints)? Would it be feasible? and under what conditions would there be a difference? I've got a database on a site I recently started (http://joe.42llamas.com, a database of guitar tablature) and would like it to be as fast as possible. Any input on this would be great. Thanks! - Joe Monti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: users and db visibility
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 04, 2002 3:17 AM To: Hussein Morsy; MySQL List Subject: Re: users and db visibility on 8/4/02 3:13 AM, Hussein Morsy, typed: how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' mysqld --safe-show-database or in my.cnf: safe-show-database With this option, the SHOW DATABASES command returns only those databases for which the user has some kind of privilege. In 4.0.2 this option is default enabled. thanks. i just searched: http://www.mysql.com/doc/en/index.html for my.cnf and got no returns. i searched my system for it and couldn't find it. can you tell me something about it, like maybe where it could be? Yes, well, a quick 30 seconds worth of work: (1) go to mysql.com (2) click on Search (3) Type in --safe-show-database in the box (4) click on Search1 Volia! For the truly lazy, here's a link to get you started: http://www.mysql.com/doc/en/Command-line_options.html -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Querying for XML content in the database ?
MySQL really wasn't designed for this sort of useage. Your selects are going to be brute force searches on unidexed data, which is exactly why they are so slow... I would advise you to look into using an XML or XML Enabled RDBMS. There are a lot of possible considerations here as to what you might want. I would advise you to consider abandoning storing XML in a database entirely, as it completely breaks the idea of database design - namely, don't store duplicate data. You would probably be much better served by writing code to wrap the actual data in the database with XML - it's quite easy, and a lot less hassle than trying to store XML. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Backup automation..
-Original Message- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:38 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Backup automation.. On windows you could simply copy the entire data directory with a Scheduled job. Copying the files should be all you need to do for windows. For a cleaner, and what most people would say is a better way you could schedule a batch file to run mysqldump that would dump the data and structure to a file. mysqldump info can be found at: http://www.mysql.com/doc/m/y/mysqldump.html I hope you're shutting down MySQL before you do this. If yuo're not, your backups are probably worthless. sql, query -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Backup automation..
On windows you could simply copy the entire data directory with a Scheduled job. Copying the files should be all you need to do for windows. For a cleaner, and what most people would say is a better way you could schedule a batch file to run mysqldump that would dump the data and structure to a file. mysqldump info can be found at: http://www.mysql.com/doc/m/y/mysqldump.html I hope you're shutting down MySQL before you do this. If yuo're not, your backups are probably worthless. sql, query Shouldn't it be enough to lock the tables and FLUSH before doing the copy? I want to keep read access while doing the backup, and let writes queue (i.e. writers will find the database a bit soggy during backups, but read work OK and INSERT DELAYED will just be delayed - I hope. If you can guarantee that writes will not be propagated to the disk, you may be all right. You might want to test to make sure you can ready your backups, though - just in case. We use mysqldump here for backups - it's fast, gives us ASCII SQL files to look at if something happens, and compresses well. I'd highly recommend using it as opposed to copying the actual disk files around. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Cut Copy Paste
You can also use Microsoft Query or Microsoft Access to construct queries if you're running Windows. -Original Message- From: Dan Vande More [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:35 AM To: Mark Herzog; [EMAIL PROTECTED] Subject: RE: Cut Copy Paste Mysqlfront works well, though I don't believe you can cut. -Original Message- From: Mark Herzog [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: Cut Copy Paste Cut, Copy, and Paste functions are not available in the SQL Query tool in my MySQLManager tool. Any ideas? Thanks. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to get timestamp of inserted record
suppose I have added one field time_stamp of type timestamp in any existing table. it will show the current timestamp of all records. If i update any record after sometime It will also update the timestamp of updated record with current timestamp. but for insertion of any record...what i have to do...i have to mention the current timestamp value with values of all fields of a record or is there any way to insert new record so that it will automatically take current timestamp for that record. Plz specify the sql query also, if u know right now. insert into whatever_table (time_stamp) values (NOW()); update whatever_table set time_stamp=NOW(); -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Now it's available MYSQL API for VBA
Over 45 MYSQL API (base) functions are now available for using in Microsoft VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how you must use this API functions and how you can use multiple connection/query. Memory consumption is 2 kb.Performance guarantied (1700 fetch_row/sec.)... And how does this differ from using the standard VB/VBA functions to manipulate MySQL databases? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speed issue
So it may seem that on your machine, with both MySQL and Access loaded together Access runs ever so much faster. However, you are comparing single use Access to single use MySQL. (also, once mysql starts caching things, it gets faster. The more you use it, the faster it runs!) Also, once you get MySQL into it's native environment (server class machine or at least one where nothing else is going on) it will run like a screaming banshee. I'll second that ;) We use MySQL extensively here, and we also use Access for the small stuff. Occasionally we will build an Access database, then link tables to MySQL via the MyODBC driver, then do database stuff as usual with VB6. Same with proof-of-concept or demo stuff that we want to upscale quickly. By the way, if you're going to use VB, I'd strongly suggest setting the dbSQLPassThru option on your queries and such, it will speed things up tremendously. If you don't, VB will bring down the entire table or tables to your desktop, then work on the data locally, a HUGE waste of time and bandwidth. You also don't have to use ADO if you don't want to - I use DAO and with passthru turned on, it works just fine ;) -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden - Paris http://www.squishedmosquito.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: XML
I am looking at a project using XML to import and export data into MySql directly or using php. The datasets are quite large (40-50 million records) XML is a metadata technology - you wrap data in XML. You don't use XML to import or export data. You don't store XML in a database, you store data. When you fetch the data from the database, you wrap it in XML and send it on its way. Does that make it simpler? sql,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML
On the other hand, proclaimed native XML databases (eg, Software AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the database...no need to wrap and unwrap the metadata, document/data structure from the data. Isn't that more than a bit stupid? Databases are for storing data, not metadata. Ask Monty why he doesn't store data natively as XML. Short answer: it's stupid, unless all you ever want to see from your database is XML-wrapped data and never want to see it any other way. The whole world isn't XML, nor should it be. 40+ years of working with data tells us that you ALWAYS want to store data in its simplest form. sql,db,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML
Not sure there is much more metadata in an XML database than in a data database. In a standard database, the data and metadata are stored separately, not so with XML. When the next new latest and greatest thing comes along, you'll have to strip all that metadata out of your data. It also makes for bigger databases, and a lot more wasted space, like comparing normalized and unnormailzed tables. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MD5
-Original Message- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 4:30 PM To: Kiss Dániel; [EMAIL PROTECTED] Subject: Re: MD5 If you are running Linix, at the prompt type: md5sum filename I'm sure you can get md5sum for other Unices as well. It's either md5 or md5sum on most UNIX-like operating systems. I don't think the MySQL MD5 function is designed for large amounts of data. Escapade provides it's own MD5 function because of this, I'm not sure about PHP. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Using web forms and webpages to access/view mysql data
-Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 7:10 PM To: Emma Grant; [EMAIL PROTECTED] Subject: Re: Using web forms and webpages to access/view mysql data It really depends on the language you wish to use ... could be Perl, ASP, PHP, etc. Don't forget Roxen and Escapade, both of which are significantly easier to learn and use than PHP, ASP, or Perl. For example, Escapade lets you run a query like SQL select * from table rather than having to laboriously set up the connection like you have to do with other server-side scripting languages. And while Escapade is a commercial product, Escapade is freeware, as opposed to ASP which is not. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: API++ Question
Thanks, it's exactly what I'm looking for, suppose I've a lot of work, becouse (for any interested) it's anexcellent option instead ADO and MyODB but . the only matter it's a big time to establish a connection, after that, everything is right. Somebody know's other option ? sql,db Why not use MyODBC? you don't *have* to use ADO, you can use DAO, which is simpler. -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.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: Help with hanging MySQL server
Ed Carp ([EMAIL PROTECTED]) writes: Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the box, mysql will start, but connections to the database just hang. mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when we do a telnet localhost 3306, it connects, but we don't get the characteristic 3.23.36garbage string that we would normally see. Any hints? An update: I upgraded to RedHat Linux 7.2 (the server was running 6.2), only to find the system unusable - common programs would core dump, leading me to believe the shared libraries had gotten trashed. So, I pulled a 20GB drive off the shelf, formatted it, loaded RedHat 7.2 on it, restored the databases, and everything works fine. I still don't know what the problem was. I hope it doesn't come back :( -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc I tell you, freedom and human rights in America are doomed. The U.S. government will lead the American people in and the West in general into an unbearable hell and a choking life. --Osama bin Laden Look around - he's right... :( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Clients Hang
I have not completely figured out what the problem is and I never got a response from any one else on the list. I can tell you it looks like a mutex problem between two threads. We have followed it down into pthreads where it seems to be stuck. The external symptom we see is that the MySQL server does not open any of the databases. The really bad news is that it is not a MySQL problem so reinstalling MySQL does nothing to fix it. The worse news is that the MySQL server does not give you a clue what the problem is. We had a Linux guru look at the version of mysql on this system that we compiled with debug. I got information about the debugging session third hand and really don't have any details other than the problem appeared to be in pthreads. I am not so sure pthreads is at fault other than a dead-lock condition exists and it is not detecting it and blowing one of the stuck processes away. What version of Linux are you running? After a lot of reearch and gdb'ing, I found a bug report in bugzilla on redhat.com that seems to illustrate the bug that we're having: http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=13785 In short, it seems it's a contention problem in pthread_lock. the fix is to upgrade to libc 2.1.92 (or better). RedHat 6.2 is running libpthreads 0.8, and I think this problem is fixed in 0.9. Unfortuantely, 0.9 needs libc 2.2, so you're probably better off upgrading to RedHat 7.2. I know, this bug report applies to SMP kernels, but ieven if you're not running an SMP kernel, it's probably a good idea to upgrade anyway. Why it started suddenly and won't go away, I have no idea. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re[2]: Help with hanging MySQL server
Yes, take the right-compiled MySQL binary distribution from http://www.mysql.com. EC I rebuild MySQL 3.23.36 with debug on, then ran mysqld --debug. Here's the output of the trace, if it will help. Looks EC like MySQL gets to the listen(), but hangs up in threads before it does an accept(): Thank you for your confidence. We do not provide MySQL consulting or support in private mailings. Please put your requests and state your problems in public MySQL list [EMAIL PROTECTED] We will answer then. I did - I had copied you privately because you had addressed the issue originally. The message you received was also copied to the list, but I haven't seen any response. Bill MacAllister also has the exact same problem, and has about reached the point where he's going to reinstall Linux in an attempt to resolve the issue. At this point, I'm going to drop a few debug statements in mysqld.cc to see if I can pin down the exact place where mysqld goes out to lunch, and I'll keep you and the list posted. If it appears that it's hanging in the thread libraries, I will reinstall the thread libraries. If that doesn't resolve the issue, I'm going to be forced to reinstall the OS. It seems that MySQL --debug mode should provide a little more information, but I suppose that's wishful thinking :) It's a very irritating problem, because we've got all our corporate database stuff on MySQL on this particular server... sigh -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/341-4420 Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden - Paris http://www.squishedmosquito.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: Help with hanging MySQL server
Egor Egorov ([EMAIL PROTECTED]) writes: Ed, Monday, January 28, 2002, 11:26:44 PM, you wrote: EC Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on EC a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the EC box, mysql will start, but connections to the database just hang. EC mysqldmin, etc. all hang also. /tmp/mysqld.sock is being created, but when EC we do a telnet localhost 3306, it connects, but we don't get the EC characteristic 3.23.36garbage string that we would normally see. Any EC hints? Yes, take the right-compiled MySQL binary distribution from http://www.mysql.com. I rebuild MySQL 3.23.36 with debug on, then ran mysqld --debug. Here's the output of the trace, if it will help. Looks like MySQL gets to the listen(), but hangs up in threads before it does an accept(): T@1024 : init_signals T@1026 : signal_hand T@1026 : | init_thr_alarm T@1026 : | | init_queue T@1026 : | | | my_malloc T@1026 : | | | | my: Size: 488 MyFlags: 16 T@1026 : | | | | exit: ptr: 820b070 T@1026 : | | | my_malloc T@1026 : | | init_queue T@1026 : | init_thr_alarm T@1026 : | my_create T@1026 : | | my: Name: '/usr/local/var/adsl-61-76-31.pid' CreateFlags: 436 AccessFl ags: 1 MyFlags: 16 T@1026 : | my_create T@1026 : | my_malloc T@1026 : | | my: Size: 33 MyFlags: 16 T@1026 : | | exit: ptr: 820b260 T@1026 : | my_malloc T@1026 : | exit: fd: 8 T@1026 : | my_write T@1026 : | | my: Fd: 8 Buffer: bf7ffcf0 Count: 5 MyFlags: 16 T@1026 : | my_write T@1026 : | my_close T@1026 : | | my: fd: 8 MyFlags: 0 T@1026 : | | my_free T@1026 : | | | my: ptr: 820b260 T@1026 : | | my_free T@1026 : | my_close -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Clients Hang
What seems to be happening is that the open of the db hangs. So, when you attempt to connect with a client, mysql tries to look at the grant tables and hangs waiting for access. This is just a guess though. When you connect with a client, mysql_real_connect opens a socket to the server, does the handshaking, then authenticates and passes the query info. When I connect, I don't get anything, and gdb says the client is hung in one of the net_read routines, which makes sense - the client is waiting for something from the server. Is this a MySQL issue or not? I'm not sure - I just downloaded MySQL-3.23.47-1.i386.rpm and installed it (this is supposedly the static version of the server, no?) and it gave me exactly the same result, which if it was a Linux issue, it shouldn't react the same, since it was linked statically, so I'm leaning towards it being a MySQL issue of MySQL not handling an error condition properly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock ???
Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html You can also look at Carsten's *excellent* FAQ - specifically, http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_1_0 -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiling C APIs
Douglas Blood ([EMAIL PROTECTED]) writes: When I try to compile the default MyC API that is on the Contributed API page I get the following error: I believe that the error has to do with the way database.h includes mysql.h and that it cant call the methods that are in it. /cygdrive/d/DOCUME~1/ADMINI~1/LOCALS~1/Temp/cc5hhVhM.o(.text+0x8e):sampl e1.c: undefined reference to `mysql_connect' /cygdrive/d/DOCUME~1/ADMINI~1/LOCALS~1/Temp/cc5hhVhM.o(.text+0xa7):sampl e1.c: undefined reference to `mysql_error' It's probably because you're not using -lmysqlclient. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem compiling MySQL-4.0.0-alpha with charset german1
Stephan Skusa ([EMAIL PROTECTED]) writes: ./conf_to_src .. german1 \ ./ctype_extra_sources.c make[2]: *** [ctype_extra_sources.c] Error 132 make[2]: Leaving directory `/usr/src/mysql-4.0.0-alpha/libmysql' I'm running RedHat 6.2 and I'm seeing the same error with latin1. It seems that some versions of gcc/egcs are generating incorrect instructions with optimization turned on - when I turned off optimization, everything worked fine. Alternately, you can try the compile flags listed for your platform in the INSTALL-SOURCES document in the source distro. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.0 core dumps on build]
Description: ./configure;make produces core dump when conf_to_src runs. How-To-Repeat: make distclean;./configure;make Fix: Unknown. Submitter-Id: submitter ID Originator:Ed Carp Organization: Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London MySQL support: [none | licence | email support | extended email support ] Synopsis: MySQL 4.0.0 core dumps on build Severity: Priority: Category: mysql Class: Release: mysql-4.0.0 alpha Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.40 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 7 hours 27 min 25 sec Threads: 1 Questions: 97143 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 12 Queries per second avg: 3.619 Environment: System: Linux adsl-208-191-206-105.dsl.rcsntx.swbell.net 2.2.17-14 #1 Mon Feb 5 17:53:36 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 4 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Apr 9 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[MySQL 4.0 compile fails on Linux]
Description: make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ - DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql \ -DHAVE_CONFIG_H -I../innobase/include -I./ ../include -I./../regex-I. -I../include -I. -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c sql_lex.c c sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once sql_lex.cc:85: for each function it appears in.) sql_lex.cc:85: confused by earlier errors, bailing out make[3]: *** [sql_lex.o] Error 1 How-To-Repeat: make Fix: Unknown Submitter-Id: [EMAIL PROTECTED] Originator:Ed Carp Organization: Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London MySQL support: [none] Synopsis: MySQL 4.0 compile fails on Linux Severity: Priority: Category: mysql Class: Release: mysql-4.0.0 alpha Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.40 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 hours 18 min 5 sec Threads: 2 Questions: 106568 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 12 Queries per second avg: 3.566 Environment: System: Linux adsl-208-191-206-105.dsl.rcsntx.swbell.net 2.2.17-14 #1 Mon Feb 5 17:53:36 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 4 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Apr 9 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL 4.0.0 core dumps on build]
Stupid damned frigging spam filters... database, sql Forwarded Message: Ed Carp ([EMAIL PROTECTED]) writes: Ed Carp ([EMAIL PROTECTED]) writes: Description: ./configure;make produces core dump when conf_to_src runs. How-To-Repeat: make distclean;./configure;make Fix: Unknown. Editing the respective Makefile(s) and removing the first occurrance of -O3, removing conf_to_src.o, then re-running make seems to have worked, it let me get further in the build process... -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: About MYSQL APIs
Sinisa Milivojevic ([EMAIL PROTECTED]) writes: If you wish to make your application transparent, you should use ODBC. ODBC, or MyODBC? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Make new tables on top of old ones
Deryck Henson ([EMAIL PROTECTED]) writes: I need to make about 15 tables that use the same template as the first one. Please help. gripe Please post more information. Platform, software, etc. This is like saying, I want to get from point A to point B. Please help. /gripe OK, I've got that out of my system. Now, if you're on a UNIX/Linux/*BSD box, you can do: # assume name1...nameN is the names of your clone tables # assume origtable is the name of your original table # from the shell prompt: $ for i in name1 name2 name3 name4 ... name15 do mysqldump -d databasename origtable|sed -e s/CREATE TABLE origtable/CREATE TABLE $i/g|mysql databasename done Tada! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sysdate() query and note to Mysql admin
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: now,what statement do I use to put the sysdate into the column today? this is NOT working insert into datee values(select DAYOFMONTH(sysdate())); Of course not. insert into datee values (Now()) will, though. Just feed it to mysql ... ;) Here's the JavaScript euqivalent, if that helps: function GetTheDate() { now = new Date; ty = now.getYear(); if(ty 1900) { ty = ty + 1900; } mo = now.getMonth(); mo = mo + 1; return(ty+'-'+ShowZeroFilled(mo)+'-'+ShowZeroFilled(now.getD ate())+' '+ShowZeroFilled(now.getHours())+':'+ShowZeroFilled(now.getMinutes())); } -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Fulltextsearch
Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the State of Texas online. My query time went down from 120 seconds to less than a second. So, yes, it's really worth it. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
- it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. Stored procedures aren't nonsense, but using or re-implementing a particular vendor's implementation is. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. These are all great reasons to implement stored procedures, not Oracle PL/SQL. I think I'm missing your point here... -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Fulltextsearch
Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? I've had no problems, but I also haven't seen any documentation on limitations. The FULLTEXT page is at http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something I've missed... -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development, Database/SQL Research Directorate Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Cal Evans ([EMAIL PROTECTED]) writes: Stick with the ANSI standard. (ANSI99?) Do not try to implement either PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any other procedural or OO language in stored procedures. Speaking form experience, all this does is blur the lines of that the database should do and what the middle tier should do. BRAVO! At last, the voice of common sense is heard :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: In the table Properties... What is Row_Format???
Pablo Fraga ([EMAIL PROTECTED]) writes: What´s the diference between The row storage format (Fixed, Dynamic, or Compressed) . RTFM! http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/D/y/Dynamic_format.html -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Let's approach stored procedures
Since the current version of MySQL is open source you could write stored procedures in the same language used in (until recently) DB2, i.e., C. I Why reinvent the wheel? MySQL already has user-defined function capability in C. Related question, what language or psuedo language would be used to code them. SQL, obviously. Anything else would be insane. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FW: mysql db replication security across the internet
Duc Chau ([EMAIL PROTECTED]) writes: Can anyone tell me or point me to documentation on how to securely do database replication over the internet? I need to replicate to machines in datacenters in diffrent states. How feasible is this? Has anyone done it? What are the security concerns with doing this via the net? Thanks Not a problem. Use secure shell's port forwarding feature (look in the VPN HOWTO at http://www.linuxdoc.org/HOWTO/VPN-HOWTO.html for more info). -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'tmp/mysql.sock' (2) error
BW (ST) ([EMAIL PROTECTED]) writes: I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. No, Bob, that would be an incorrect guess. ;) 1. Is MySQL actually running? 2. If so, where is it putting mysql.sock? 3. If it's in /var/lib/mysql/mysql.sock, the quick fix is to do ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock. 4. Where is my.cnf located - you didn't say. 5. What application are you trying to run that gives the error - again, you didn't say. I'm sorry I can't help you without you providing more specific information about your problem. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ANN: EMS MySQL Manager
Igor Brynskich ([EMAIL PROTECTED]) writes: First, thanks to everyone who interested in our product -- EMS MySQL Manager -- and answered to our previous announce! This message intended for shed light on some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Complete price list you can find at http://www.mysqlmanager.com/purchase.phtml Q. Why should I pay $95 for your product when I can download and use PHPMyAdmin (or any number of other products) for free? Q. Why should I pay a lot of attention to a company who spams a technical list in order to sell product under the guise of answering questions? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ANN: EMS MySQL Manager
Does your message mean we'll see no more Escapade announcements on this list? That would be unfortunate, but by the same token, should the EMS client become available in a Linux version, an announcement on this list might be of interest to several of the readers. No, simply because we don't sell Escapade - it's a freebie. You can go out and download it right now, in fact - no credit card needed, etc. Free download, free upgrades, free help. The engine is not where we make any money at all. Just because it's not OpenSource doesn't mean it's for sale. It's not a teaser product that you have to buy something else to make it work, it's not crippleware, it's not even expireware anymore. Free, free, FREE. Call me altruistic - maybe it's just my way of saying thank you to all the folks out there (including you, Paul) that have done so much to make MySQL the great, free database that it is. When we first started working on the engine, I jumped up and down to make it free and keep it free, and that's the way it will stay. It was a useful tool for me, and it's turned out to be a useful tool for a lot of other people, too. On the other hand, I didn't see any free downloads for the EMS product. It seems like it's completely for profit, and I resent the list used for trying to sell software. We even have a free version of a script that does what PHPMyAdmin does - completely written in Escapade. It's *one* Escapade script, not a bunch of PHP scripts and shell scripts like PHPMyAdmin is. It works, it does everything I do in my day-to-day MySQL maintenance, and you know what, Paul? It's also free. The only reason we haven't put out an announcement is because we're busy putting the graphics together so it looks nice :) I have no problem people posting announcements of free stuff to the list. But I draw the line at stuff that people want me to pay money for - I get enough of that in email. But that's just my opinion - others no doubt have different opinions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQLGUI
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. Isn't there an ldconfig or similar for Solaris? You'd need to configure /etc/ld.so (or whatever the equivalent is on Solaris), then run ldconfig to tell the run-time library loaded where to look for the required libraries. Try man ldconfig. Good luck! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'tmp/mysql.sock' (2) error
create a .my.cnf in the home directory of the user that will be running the clients, and enter a [client] paragraph that defines the socket. A better solution would be to do it in /etc/my.cnf, so that it will be system-wide for the database. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Programs linked static give error when run: /tmp/mysql.sock missing
Here is what we have found while working on the 0.2.1 version of Escapade: Because Escapade is not open source, and is in the following sense similar to prepackaged Perl and PHP systems, Escapade is distributed as a static binary (because of library incompatibility issues among various Linux systems) on Linux which was linked with the current MySQL client library *at compile time*. This produces a rather interesting scenario when run on a system which specifies different compile-time options than as distributed. The problem arises when MySQL is configured and built with mysql.sock configured to be in a non-standard place (we usually find it in /var/lib/mysql/mysql.sock) on another machine, and the Escapade binary is run. The DBOPEN statement will fail with the complaint that /tmp/mysql.sock doesn't exist. Checking /tmp verified that, indeed, there is no mysql.sock file in that directory. What's going on? It turns out that, because MySQL needs to know where to put mysql.sock at runtime, and because all the MySQL client programs need to know where this is when they run, too, the socket file value as configured at compile time is compiled into the runtime client library. When mysql_connect() or mysql_real_connect() is called, it knows where to go to connect to mysql.sock, because it was specified at compile time. So what? Since the runtime library knows where mysql.sock is, all the client programs should run just fine, right? Well, sure - if your client isn't linked statically! If it is, whatever value that was compiled into the runtime library will be linked into the static binary - which may be wrong on the target system where the static binary is installed. The problem can be solved and therefore becomes a non-issue when /etc/my.cnf (or ~/my.cnf, etc.) exists and contains the socket file specification, because adding a call to mysql_options() will pick up the information in my.cnf. The only problem with this is that /etc/my.cnf isn't mandatory, nor is it apparently installed when MySQL itself is installed. If /etc/my.cnf (or path variations) don't exist, there is no way for the static client to figure out where the socket file is, and therefore the mysql_connect or mysql_real_connect call fails, while a dynamically linked program will succeed. The obvious solution is to force, in the client library, for my.cnf to exist, correctly configured, in a published place. Any other ideas on how to solve this problem? I've already mentioned why relinking as a dynamic binary isn't feasible. Thanks in advance :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML Support
Gary Huntress ([EMAIL PROTECTED]) writes: In the past few days 3 different people have asked me about xml support in mysql. I was unsure what to tell them actually, beyond saying you can easily export recordsets to xml documents.Obviously you can store entire XML documents in a TEXT field, but I'm not sure thats really the functionality that they want. I don't understand this. Do they want to wrap their data in XML to produce output? That's relatively trivial and shouldn't be done in the server, but any MySQL-aware language (PHP, Perl, Escapade, etc.) would be able to produce XML output easily from data. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: instalation Problem
muttaqin ([EMAIL PROTECTED]) writes: Description: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Fix: how to correct or work around the problem, if known (multiple lines) ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock is the easy fix :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Programs linked static give error when run: /tmp/mysql.sock missing
Ed Carp ([EMAIL PROTECTED]) writes: The obvious solution is to force, in the client library, for my.cnf to exist, correctly configured, in a published place. Any other ideas on how to solve this problem? I've already mentioned why relinking as a dynamic binary isn't feasible. This won't fix existing systems and installations, obviously. Our workaround is to hard code places to look for mysql.sock: char *where_socket[] = { /tmp/mysql.sock, /var/lib/mysql/mysql.sock, /usr/local/lib/mysql/mysql.sock, NULL }; [...] mysql_init (mysql); mysql_options (mysql, MYSQL_READ_DEFAULT_GROUP, mysqld); if (!mysql_real_connect (mysql, host, name, pass, db, 0, NULL, 0)) { ptr = where_socket; while (*ptr != (char *) NULL) { if (mysql_real_connect (mysql, host, name, pass, db, 0, *ptr, 0)) break; if (mysql_errno (mysql) != CR_CONNECTION_ERROR) printf (!-- ERROR %d connecting to database: %s --\n, mysql_errno (mysql), mysql_error (mysql)); ptr++; } if (*ptr == (char *) NULL) { fprintf (stderr, ERROR %d connecting to database: %s\n, mysql_errno (mysql), mysql_error (mysql)); return (EOF); } } This is a hack because there are only so many places to look for mysql.sock and one can't hard-code them all, so this is only a short-term solution, and certainly one I wouldn't want to release in the engine! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
jason bailey ([EMAIL PROTECTED]) writes: I'm consistently getting the error (2002) : Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (111) You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. 1. Can i found out if the server is or is not running -which command and what am I looking for? mysqladmin status 2. Can I stop the mysql server mysqladmin shutdown 3. Can I start it? safe_mysqld Where is mysql.sock? In /tmp? If so: ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Crypto
Matthew S. Hamrick ([EMAIL PROTECTED]) writes: Interfacing MySQL with standard crypto libraries: BSAFE, BDANGEROUS, CRYPTIX, CRYPTLIB, CRYPTO++, or even PAM? Why? What's the purpose? Export laws being what they are, it's probably not a good idea, anyway... Using any crypto library or hardware to encrypt data in a database. All of this stuff is easy. I've done a fair amount of compression/encryption of databased data, but it's almost too trivial and straightforward to pass along. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Mysql socket thing using Redhat 7.1
Jason Bailey ([EMAIL PROTECTED]) writes: You mean /var/lib/mysql/mysql.sock? Details are IMPORANT. Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted that deleting it and then running mysql_install_db or possible safe_mysqld recreated. Well, it wasn't a pun :) Details are critically important, especially when you work with complex systems like these. I was commenting on the lack of detail in your post - you ran something and something happened, but you weren't quite sure what. It's much more difficult when people have to guess what you did. I'm not trying to flame you at all - but you will probably be able to get a lot more, and a lot higher quality, help if you can supply as much detail as possible. I've deleted it and running something above has brought it back again!- this is good I think Bad idea. Slightly sarcastic- sorry No, this really *is* a bad idea! The mysql.sock file is created by the server - if you delete it, you will not be able to connect locally. ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock Should get you going. This, in my ignorance, looks like a soft link to the mysql.sock in the /var/lib/mysql/mysql.sock location. The file(?) does exist and I'm not sure why a softlink will help unless it's something to do with permissions. If the server is creating mysql.sock in /var/lib/mysql and something else is looking for it in /tmp, this is the easiest way to get it to work, besides checking to make sure that the permissions are such that anyone who needs to can read and write to mysql.sock. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 get
Terje Kristensen ([EMAIL PROTECTED]) writes: In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2 you get a listing like this. +++ | f1 | f1 | +++ | 1 | 1 | | 1 | 2 | | 1 | 3 | +++ When using the DBI function fetchrow_hashref() you get only one value since the key is not unique. Is there a way to get MySQL to return with the syntax TABLENAME.FIELDNAME, and not just FIELDNAME ? I know that you can use aliases to get a similar effect but it's a hassle to write sql's like this : SELECT table1.f1 as 'table1.f1',table2.f1 as 'table2.f1' FROM table1,table2 Nope, you do it like select table.f1 as t1f1,table2.f1 as t2f1 from table1,table2 I tried to get it to return with tablename.fieldname, but I couldn't - I can't understand why you would want to, anyway. As I recall, it also breaks the SQL-92 standard. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a file wav ito a table
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes: I have to insert a file wav into a blob field of a table. Is that possible?And how can I do it? Bad, bad, BAD IDEA! Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
George Pitcher ([EMAIL PROTECTED]) writes: Similar for me. Except that I can do all the usual SQL stuff as root but if I try and access via PHP I get the '/tmp/mysql.sock' missing message. Is a complete re-install of MySQL the only solution or is there something else that can be done to solve this problem, which, from scanning archives, is not an uncommon one. When charley enters mysql, Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2) message appears. Of course root can connect to mysql server with above command. That is there was no problem. Does /tmp/mysql.sock really exist? If not, the simplest solution is to ln -s /var/lib/mysql/mysql.sock /tmp or wherever mysql.sock is living. You can find this out by doing a mysqladmin variables|grep socket. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hot Backups
Matthew Walker ([EMAIL PROTECTED]) writes: What's the best way of doing a hot backup on a database? Our server is set up in such a way that it's not a simple matter to shut down apache/mysql and do the backup then. So, is it safe to just copy the mysql directories, or is there some recommended procedure for this? RTFM, RTFM, RTFM! That being said, most everyone I know uses mysqldump for hot backups. Now, STOP what you're doing and go bookmark http://www.bitbybit.dk/mysqlfaq/faq.html, if you have time to do nothing else - this is Carsten Pederson's *excellent* MySQL FAQ. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index Create Speed
Mark kirkwood ([EMAIL PROTECTED]) writes: CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ; Whichunfortunatly takes about 20m ( which I think is a bit slow ) Have you tried building the table structure with the index already in place, then importing the data? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump issues
daniel james ([EMAIL PROTECTED]) writes: I need to generate a tab-delimited text dump of table data ONLY and have it output to a text file. I don't want any table info, delimiters, etc. I need this to copy/paste into a excel spreadsheet. What's the syntax? I'm stuck here: % mysqldump dbname tablename ??? Easier: echo select * into outfile 'tablename.tsv' from tablename|mysql dbname -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Question: deleting previous duplicate entries
Tom Churm ([EMAIL PROTECTED]) writes: hi, i've got a table collecting info from html forms. problem is, certain wiseguys always make multiple entries. could someone clue me in to how i can select the Last entry where there is a duplicate for the User (type text, these are email addresses), and automatically delete any previous entries? i'm using a column 'id' int auto_increment as my index: the last entry from a User will automatically have a higher id #. Try looking at the excellent MySQL FAQ! Here's a link that may help: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0 :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Db maintenance
April Sims ([EMAIL PROTECTED]) writes: Is there anything I need to be doing maintenance wise on a mysql database? I have inherited one that was installed as follows As far as database stuff that we do, we basically installed the server, set up databases and tables, and use them. Indices have been created on many of the tables to speed up access times. It is being replicated to another server continuously. In particular mysqldump, mysqladmin, optimize, mysqlcheck, etc. We don't do anything here. Every now and then the server gets rebooted for one reason or another (every 45-60 days), and either isamchk -r -e -s -o -f or myisamchk -r gets run, followed by optimize table commands on some of the most updated tables. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use of the MySQL logo - licensing agreement
I've been looking at upgrading the logo on several of my personal web sites to the new, cooler logo, so I popped over to http://www.mysql.com/downloads/logos.html, which led me to http://www.mysql.com/company/trademark.html and the shock of my life: [...] Generally, no person or entity may use any MySQL AB Mark without the prior, express written permission of MySQL AB. [...] As a general rule, no person or entity may use (or authorize the use of) any of the MySQL AB Marks in any manner other than as expressly authorized by MySQL AB in a written agreement. [...] When using a MySQL AB logo, you must never modify the design, add or delete any words, or change any colors or proportions. Only the logo art provided by MySQL AB may be used. You may, however, adjust the typesize of the trademark notice symbol. [...] If you are a user of the MySQL database server, (whether under the GPL licence or a MySQL commercial licence) and have not modified the source code for the application or use in question, you may request permission to display the Powered by MySQL logo, as shown in the MySQL AB Mark Table in Section 4(A), in the user interface (including your website) of the application that runs on the MySQL server. To request permission, simply send an email to [EMAIL PROTECTED] in which you identify your name (and company name, if applicable) and the application, and you agree to adhere strictly to this Trademark Policy. - What is this? Have the folks at MySQL gone out of their minds? Have they abdicated the management of the company to lawyers? I found the previous policy regarding the use of buttons, logos, etc., to be very liberal, and beneficial to both the MySQL folks and to site developers - it gave developers an opportunity to advertise a little for a great database and to show a cool-looking logo on their site at the same time and it gave MySQL a bit of free advertising. I find this existing policy as written to be restrictive in the extreme - I can't show our pride at having developed several significant products that rely on the MySQL database engine without someone's specific *written* permission? I can't diddle with the logo, like so many other people have done with the old logo to make it cooler and stand out more? That's pretty nuts, if you ask me... I read this new logo policy as a slap in the face to all the developers and admins who have worked hard at spreading the MySQL religion to the far corners of the web, at showing our pride at having a database engine that one could install almost anywhere, that supported SQL, that flat-out *screamed* performance-wise, and that was supported by a team of very cool folks at MySQL. It reads as a knee-jerk reaction to the MySQL/NuSphere brouhaha - one bad experience has screwed it up for the rest of us? Tell me it ain't so, folks...tell me the greatest database on the face of the planet hasn't sold out to the bean counters and lawsuit-filers...please! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Use of the MySQL logo - licensing agreement
This is just a WAG ... but do you suppose this is a result of the flap with NuSphere? I agree - but man, have they ever screwed it up for the rest of us! For this great database engine to be led around by the nose by lawyers is sad. I mean, I understand protecting the corporate jewels, but jeez... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Use of the MySQL logo - licensing agreement
My point, and I believe Ed's point, is that I'm not clear on use of the MySQL logo in my software, printed material, etc. What concerns me is that the new logo licensing stuff is so restrictive, *anyone* who even displays the logo on a web site (powered by MySQL) has to get WRITTEN PERMISSION to do so from MySQL AB. I'm uncomfortable with that, particularly since it's free advertising for MySQL, and the way I look at it, anyone who displays the logo on their web site (except for blatantly trying to rip off MySQL in some way) is doing MySQL a favor, and it seems particularly ungrateful to the developer community to force them to jump through all kinds of hoops to do MySQL a favor. Does that make any sense? I'm not trying to slam MySQL, I'm just concerned about displaying the logo on a web site that says powered by MySQL or modifying the logo like folks used to do to produce all kinds of cool enhancements to the name MySQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Use of the MySQL logo - licensing agreement
B. van Ouwerkerk ([EMAIL PROTECTED]) writes: Now.. what would you prefer.. many forks all using the same logo or that they require you to ask for their permission. Actually, I'd prefer a bunch of derivitive logos, like before, so I could choose the best-looking database logo based on my web site look-and-feel :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Is your web site data driven? Are you swamped with work managing, updating, and deploying that data on to your web site? You need Escapade! Check us out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Server overload problems
Catalin Tenita ([EMAIL PROTECTED]) writes: Hi people, Can you tell me how to monitor the server load and the mysql processes for a a normal user on a shared Linux sistem. For monitoring the machine itself, I usually use top. For monitoring the database, I like mysqladmin processlist and mysqladmin status. YMMV :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Lost Root password
temi odurinde ([EMAIL PROTECTED]) writes: Dear List, I have lost the root password to my MySQL installation. What is the quickest way to remedy this situation, uninstall and reinstall MySQL or what???. My installation runs on a RaQ4 server. The quickest way is to RTFM :) The searchable manual is online at http://www.mysql.com/doc/ - it took me all of 30 seconds to return the following URL (although I ought to know this one by heart!): Hot to Reset a Forgotten Password - http://www.mysql.com/doc/R/e/Resetting_permissions.html OBList: database,sql,query,table -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 exact match queries?
How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select ... LIKE! But when I do: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID; MySQL returns every row with either growth OR hormone in it, which isn't what I wanted. Is there a way to only return the rows where the exact phrase growth hormone is present? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FULLTEXT exact match queries?
On Aug 28, Ed Carp wrote: How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select ... LIKE! But when I do: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID; MySQL returns every row with either growth OR hormone in it, which isn't what I wanted. Is there a way to only return the rows where the exact phrase growth hormone is present? Try select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; It works - thanks! Hmmm...why didn't I think of that? ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: FULLTEXT exact match queries?
Alok K. Dhir ([EMAIL PROTECTED]) writes: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; This defeats the purpose of the fulltext index, don't you think? Not really - since the WHERE clause is executed left to right, the LIKE clause is run against the output of the MATCH clause, a much smaller subset. I tried it - on a 250MB database containing almost 1.7 million records, the query time went from 100+ seconds to just under 1 second - a significant increase in speed! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Is your web site data driven? Are you swamped with work managing, updating, and deploying that data on to your web site? You need Escapade! Check us out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php