HELP: mysql stoped sudenly , Database page corruption on disk or a failed
Dear Friends: since 2 weeks ago the mysql is stoping sudenly, and into the error log is as lines below, Database page corruption on disk or a failed , file read of page 34, how I can know what table is in page 34 ? I've used mysqlcheck, without any result, all is OK for it, mysql 4.01 is running on windows 2003 and the ibdata1of innodb is 20 GB Thanks in advance Jaime 070228 17:44:04 InnoDB: Page checksum 75769562, prior-to-4.0.14-form checksum 3189442283 InnoDB: stored checksum 4088203197, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 36808, low 4 bytes of lsn at page end 0 InnoDB: Page number (if stored to page already) 34, InnoDB: space id (if created with = MySQL-4.1.1 and stored already) 0 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 34. InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting InnoDB: the corrupt table. You can use CHECK InnoDB: TABLE to scan your table for corruption. InnoDB: See also http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. InnoDB: Ending processing because of a corrupt database page. 070228 17:45:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 070228 17:45:07 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 29 4030208738. InnoDB: Doing recovery: scanned up to log sequence number 29 4030343563 070228 17:45:07 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 070228 17:45:09 InnoDB: Flushing modified pages from the buffer pool... 070228 17:45:09 InnoDB: Started; log sequence number 29 4030343563
Re: Windows Compiled Help MySQL Reference Manual -- Error
On 6/13/06, Jake Peavy [EMAIL PROTECTED] wrote: On 6/7/06, Jake Peavy [EMAIL PROTECTED] wrote: On 6/7/06, Paul DuBois [EMAIL PROTECTED] wrote: At 17:30 -0600 6/7/06, Jake Peavy wrote: Hey yall, I'm unable to open the .chm I just downloaded for 5.1. I get the following error: Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My Documents\refman-5.1-en.chm. Any ideas? It does seem to be corrupt. We'll take a look into it. Thanks. Great. Can you respond to this when you have an updated file up? How's this coming along? Still corrupt I see. Seems like it ought to be a pretty quick fix. wtf? _still_ corrupted? -- -jp We all know the magic word is please. As in the sentence, Please don't kill me. Too bad Chuck Norris doesn't believe in magic.
Re: Windows Compiled Help MySQL Reference Manual -- Error
On 6/7/06, Jake Peavy [EMAIL PROTECTED] wrote: On 6/7/06, Paul DuBois [EMAIL PROTECTED] wrote: At 17:30 -0600 6/7/06, Jake Peavy wrote: Hey yall, I'm unable to open the .chm I just downloaded for 5.1. I get the following error: Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My Documents\refman-5.1-en.chm. Any ideas? It does seem to be corrupt. We'll take a look into it. Thanks. Great. Can you respond to this when you have an updated file up? How's this coming along? Still corrupt I see. Seems like it ought to be a pretty quick fix. -- -jp Chuck Norris once ate three 72 oz. steaks in one hour. He spent the first 45 minutes having sex with his waitress.
Windows Compiled Help MySQL Reference Manual -- Error
Hey yall, I'm unable to open the .chm I just downloaded for 5.1. I get the following error: Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My Documents\refman-5.1-en.chm. Any ideas? TIA -- -jp One time in an airport a guy accidently called Chuck Norris Chick Norris. He explained it was an honest mistake and apologized profusely. Chuck accepted his apology and politely signed an autograph. Nine months later, the guy's wife gave birth to a bearded baby. The guy knew exactly what had happened, and blames nobody but himself.
Re: Windows Compiled Help MySQL Reference Manual -- Error
At 17:30 -0600 6/7/06, Jake Peavy wrote: Hey yall, I'm unable to open the .chm I just downloaded for 5.1. I get the following error: Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My Documents\refman-5.1-en.chm. Any ideas? It does seem to be corrupt. We'll take a look into it. Thanks. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows Compiled Help MySQL Reference Manual -- Error
On 6/7/06, Paul DuBois [EMAIL PROTECTED] wrote: At 17:30 -0600 6/7/06, Jake Peavy wrote: Hey yall, I'm unable to open the .chm I just downloaded for 5.1. I get the following error: Cannot open the file: mk:@MSITStore:C:\Documents and Settings\jpeavy1\My Documents\refman-5.1-en.chm. Any ideas? It does seem to be corrupt. We'll take a look into it. Thanks. Great. Can you respond to this when you have an updated file up? -- -jp Chuck Norris sold his soul to the devil for his rugged good looks and unparalleled martial arts ability. Shortly after the transaction was finalized, Chuck roundhouse kicked the devil in the face and took his soul back. The devil, who appreciates irony, couldn't stay mad and admitted he should have seen it coming. They now play poker every second Wednesday of the month.
Help. MySQL doesn't respond anymore. After I re-installed Cygwin
Hello All, Thank you for reading this email. I am trying to figure this problem out, but I need some help. I am working on a Windows 2000 Server. I have used MySQL for the past 2 years on this system. I recently installed the DEFAULT version of CYGWIN on my machine. Everyone was wonderful and I was able to connect to mysql from the bash shell by typing mysql. No problems at All. I wanted to install ALL the packages available for CYGWIN so that I can start to learn the environment and tools. After I installed all the packages under CYGWIN, I noticed that I am no longer able to type mysql at the bash prompt and get access to mysql. I changed directory into the mysql/bin directory and typed mysql and nothing happened. I no longer can access mysql from the BASH prompt by typing mysql. The funny thing is... If I type a select statement with the -e flag at the bash prompt, MySQL responds with rows. So I know MySQL works and is there, but I can't connect interactively. Could someone please help me with this. Does anyone know how I can troubleshoot either MySQL or Cygwin to see what the problem is... Thanks In Advance. William Martell Dallas Texas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help. MySQL Error.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I am currently getting the following error on one of the mysql servers im looking after and wonder if anybody knows what specifically it relates to. Error in accept: Too many open files Im currently running MySQL version '4.0.14' under FreeBSD 5.1 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/tNDpzSfrYDJMXmERAvKBAKC6vY0PnowjAaI8sRIIu+Mumeum8gCfVWAH hRU4PeRdpbIGgWPI9/xWVJY= =wHd+ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Please help. MySQL Error.
do a show status like 'open_files' and a show variables like 'open_files_limit' -Original Message- From: William Bailey [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 6:56 AM To: [EMAIL PROTECTED] Subject: Please help. MySQL Error. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I am currently getting the following error on one of the mysql servers im looking after and wonder if anybody knows what specifically it relates to. Error in accept: Too many open files Im currently running MySQL version '4.0.14' under FreeBSD 5.1 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/tNDpzSfrYDJMXmERAvKBAKC6vY0PnowjAaI8sRIIu+Mumeum8gCfVWAH hRU4PeRdpbIGgWPI9/xWVJY= =wHd+ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: * HELP * MySQL Connection Issue - Access Denied!!
Jason - I just tried: GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'X' on the server machine in a mysql console and I got the following: ERROR 1045: Access denied for user: '@localhost' using password: NO ...in addition to my questions below, why doesn't that work! Ahhh! -Original Message- From: Ryan Schefke [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:05 AM To: 'Jason k Larson' Subject: RE: * HELP * MySQL Connection Issue - Access Denied!! Hey Jason - Thanks a ton for your help! You're a lifesaver! When I use 'localhost' for the below line: C:\mysql\bin\mysqladmin -u root -h localhost password It seems to work??? because the next line goes back to c:\mysql\bin ...was the password for root successfully changed then? on the next line, I type c:\mysql\bin\mysqladmin -u root -h samserver password ...and oddly enough I get the following: mysqladmin: connect to server at 'samserver' failed error: 'Access denied for user: '[EMAIL PROTECTED]' using password: NO' Why doesn't it work when I use 'samserver' instead of 'localhost' In the winmysqladmin 1.4 tool under the environment tab it says my local host name is 'samserver'...what I named my computer? -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:19 PM To: Ryan Schefke Subject: Re: * HELP * MySQL Connection Issue - Access Denied!! You probably should either a) not use SAMSERVER or b) not specify the host or c) use localhost instead of SAMSERVER. the mysql prompt means you have successfully connected to the database server, which is a very good thing. As for the errors you probably need to create the ryanschefke user. Or just use root (not recommended). once you are at the mysql console try typing the following SQL statement. GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'your-password-here'; then do: FLUSH PRIVILEGES; you should be able to proceed with mySQLAdmin at that point. -- Jason k Larson Ryan Schefke wrote: Hi Jason, When I type: c:\mysql\bin\mysqladmin -u root -h localhost (I use 'samserver' for localhost...I hope that's right???) I get a whole list of things...version, options, variable, commands... When I type: c:\mysql\bin\mysqlc -u root I get welcome to the MySQL Monitor...then 'mysql' shows up. ...still getting errors though as mentioned below. -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 6:08 PM To: Ryan Schefke Subject: Re: * HELP * MySQL Connection Issue - Access Denied!! How about: c:\mysql\bin\mysqladmin -u root -h localhost or just: c:\mysql\bin\mysqlc -u root ?? -- Jason k Larson Ryan Schefke wrote: .I just sent this out to the win32 distribution list but no one has replied.can someone on this list please help? The issue should be trivial for experienced MySQL users, I'm just a novice, thanks! Anyone - I've been racking my brain for the majority of the day and scouring through the MySQL manual trying to figure out what is wrong.can anyone please help? Here's my issue: - Extracted files to C:\MySQL - Ran setup.exe (everything went fine, using MySQL Admin 1.4 I can see 'mysql' and 'test' dbs installed) - MySQL is running as a service and MySQL Admin 1.4 shows a green light From the box that is running MySQL I try to set the root password in DOS two ways and when I mention the host (believe it's 'SAMSERVER' according to MySQL Admin tool) it gives me an error. O c:\mysql\bin\mysqladmin -u root password X.. Works fine and the next line goes back to my root directory of c:\mysql\bin O c:\mysql\bin\mysqladmin -u root -h SAMSERVER password X.. Gives me the below error! Mysqladmin: connect to server at 'samserver' failed Error: 'Access denied for user: '[EMAIL PROTECTED]' using password: NO' Also, when I try to connect to the database from another computer via the web using http://samserver.sytes.net:8080/mysqltest.php I get the following error (I've attached my mysqltest.php file too): 'Warning: mysql_connect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in C:\Apache\Apache2\html\mysqltest.php on line 20 Could not connect' *** Note, I had to change my router settings to forward port 8080 to my web server ip since my ISP blocks port 80. Also, I've successfully installed phpMyAdmin 2.5.2-rc2. When I run 'http://samsever.sytes.net:8080/phpadmin/index.php' I get the following message: Welcome to phpMyAdmin 2.5.2-rc2 phpMyAdmin tried
* HELP * MySQL Connection Issue - Access Denied!!
.I just sent this out to the win32 distribution list but no one has replied.can someone on this list please help? The issue should be trivial for experienced MySQL users, I'm just a novice, thanks! Anyone - I've been racking my brain for the majority of the day and scouring through the MySQL manual trying to figure out what is wrong.can anyone please help? Here's my issue: - Extracted files to C:\MySQL - Ran setup.exe (everything went fine, using MySQL Admin 1.4 I can see 'mysql' and 'test' dbs installed) - MySQL is running as a service and MySQL Admin 1.4 shows a green light From the box that is running MySQL I try to set the root password in DOS two ways and when I mention the host (believe it's 'SAMSERVER' according to MySQL Admin tool) it gives me an error. O c:\mysql\bin\mysqladmin -u root password X.. Works fine and the next line goes back to my root directory of c:\mysql\bin O c:\mysql\bin\mysqladmin -u root -h SAMSERVER password X.. Gives me the below error! Mysqladmin: connect to server at 'samserver' failed Error: 'Access denied for user: '[EMAIL PROTECTED]' using password: NO' Also, when I try to connect to the database from another computer via the web using http://samserver.sytes.net:8080/mysqltest.php I get the following error (I've attached my mysqltest.php file too): 'Warning: mysql_connect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in C:\Apache\Apache2\html\mysqltest.php on line 20 Could not connect' *** Note, I had to change my router settings to forward port 8080 to my web server ip since my ISP blocks port 80. Also, I've successfully installed phpMyAdmin 2.5.2-rc2. When I run 'http://samsever.sytes.net:8080/phpadmin/index.php' I get the following message: Welcome to phpMyAdmin 2.5.2-rc2 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Server Settings: - Under MySQL Admin 1.4 on the Environment tab I see the following settings: o Local Host Name: 'SAMSERVER' o Local User Name: ' Administrator' o OS Platform: 'Whistler' o Local IP Address: '192.168.1.102 o ..also, in MyODBC window it finds driver 3.51 and API level 2 and SQL level 1 - Chose 'username' and 'password' for MySQLAdmin.exe application - MyODBC 3.51.06 installed - MySQL Connector/ODBC Running These Software Versions: - Windows XP with service pack 1 - MySQL 4.0.13 for windows - Apache 2.0.47 - PHP 4.3.2 Any help is MUCH appreciated!
Help MySQL Beginner please.
Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help MySQL Beginner please.
PHP? www.php.net (click links-tutorials) PHP/perl/MySQL? www.devshed.com Others will add quite a few too. devshed.com is pretty good. B. At 10:10 02-04-2003 -0500, [EMAIL PROTECTED] wrote: Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help MySQL Beginner please.
http://www.mysql.com There's a great manual that got me started. I'd also look on WebMonkey for some basic tutorials. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:10 AM To: [EMAIL PROTECTED] Subject: Help MySQL Beginner please. Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help MySQL Beginner please.
I suggest using the tutorials on the www.mysql.com website. That's how I learned the basics. Craig Pyter, CCNA CCDA MCSE mc.net 720 Industrial Drive, Suite 121 Cary IL 60013 847.594.5111 ext.5733 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 9:10 AM To: [EMAIL PROTECTED] Subject: Help MySQL Beginner please. Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help MySQL Beginner please.
[EMAIL PROTECTED] wrote on 02.04.2003 17:10 Hi all, Hello Jef, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef well, depends on how much in a hurry you are, learning with the links mentioned before will be fine (will be unavoidable sooner or later) BUT if you want to get started fast you could maybe think about something like installing 'phpmyadmin' (http://phpmyadmin.sourceforge.net/) which allows you to concentrate on developing your webapp instead of creating SQL statements to set up your DB the whole day long. Assuming you can execute php files, you just have to download and change one file/entry (~ absolute_uri) and phpmyadmin will run and let you set up your DB. Then goto devshed and see some tutorials on selecting, updating and inserting data with php and you are almost trough the heaviest part. Good luck! Henning -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: Help MySQL Beginner please.
On Wednesday 02 April 2003 18:10, Webmanhouse at aol dot com wrote: The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. You can find some info in the manual. How to create table: http://www.mysql.com/doc/en/CREATE_TABLE.html Some examples of queries: http://www.mysql.com/doc/en/Database_use.html http://www.mysql.com/doc/en/Examples.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Help MySQL-3.23.54a crash on AIX 5.1 when connect through TCP/IP]
Description: I installed MySQL-3.23.54a from source on AIX 5.1. It works fine when I connect the server through unix socket as localhost. But whenever I tried to connect the server though TCP/IP port, the server shutdown. How-To-Repeat: I tried : ./bin/mysql -u root -p it will work. ./bin/myql -u root -h myhost -p it crashed and restarted.. (safe_mysqld) System gives error: safe_mysqld[242]: 40666 Segmentation fault(coredump) Even when I tried to telnet: telnet myhost 3306 it gives the same error and the server shutdown and restarted. I checked the myhost.err file, there is no specific error message except, mysqls restarted. I also tried to install the binary version of MySQL3.23.54a, it has the same problem. I haven't been able to compile MySQL 4.0.9gamma, it configured with no complain but give erros like function confilcts when I tried to make. Fix: Submitter-Id: submitter ID Originator:DBA User Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.54 (Source distribution) Server: ../client/mysqladmin Ver 8.23 Distrib 3.23.54, for ibm-aix5.1.0.0 on powerpc 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.54-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 20 min 37 sec Threads: 1 Questions: 3 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002 Environment: System: AIX boveri 1 5 000B078F4C00 Some paths: /usr/bin/perl /usr/linux/bin//make /usr/opt/freeware/bin/gmake /usr/bin/gcc GCC: Reading specs from /usr/bin/../lib/gcc-lib/powerpc-ibm-aix5.1.0.0/2.9-aix51-020209/specs gcc version 2.9-aix51-020209 Compilation info: CC='/usr/local/bin/gcc -pipe -Wa,-many' CFLAGS='' CXX='/usr/local/bin/g++ -pipe -Wa,-many' CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 bin bin19 Jan 6 15:04 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx1 bin bin19 Jan 6 15:04 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure '--enable-static' '--disable-shared' '--prefix=/usr/local/mysql' '--localstatedir=/shark1/mysql/data' '--sbindir=/usr/local/sbin' '--libexecdir=/usr/local/sbin' '--enable-thread-safe-client' '--enable-large-files' '--with-mysqld-user=dba' '--with-innodb' 'CC=/usr/local/bin/gcc -pipe -Wa,-many' 'CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti' 'CXX=/usr/local/bin/g++ -pipe -Wa,-many' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 !! -- mySQL on TCP/IP on Mac OS X
Read up on the GRANT command in MySQL. This sets up the security level for the tables, hosts and even columns. MySQL defaults to only allowing the localhost to connect ot the database, which is fine if you are running the webserver and something like PHP on that computer. Once you separate them, you need to GRANT the other machine access to MySQL. For example: GRANT ALL ON db_name.* TO @192.168.1.% Will grant all privileges on database db_name to every user on the 192.168.1 network. You wouldn't want to actually grant that much access (i.e. dropping tables) to all users, but it's an example. This is a very important part of MySQL database security that you should become familiar with. This has nothing to do with what platform you are running MySQL on (I'm on a Mac too). There are a number of good books that cover this well. I use MySQL by Paul DuBois (who you see on this list occasionally). On Monday, January 20, 2003, at 02:26 AM, Ram Kumar wrote: greetings nug how can we access mySQL installation (from entropy.ch, Marc Liyanage) through TCP/IP on a network we are able to access mySQL on localhost, but tcp fails regards, ram -- +--+ Mac Solutions http://www.macsolutionsindia.com +91 98102 70848 ram @ macsolutionsindia.com MSN: [EMAIL PROTECTED] support @ macsolutionsindia.com +--+ Simplifying solutions for you... Macintosh, Windows, Client/Server, Web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP !! -- mySQL on TCP/IP on Mac OS X
greetings nug how can we access mySQL installation (from entropy.ch, Marc Liyanage) through TCP/IP on a network we are able to access mySQL on localhost, but tcp fails regards, ram -- +--+ Mac Solutions http://www.macsolutionsindia.com +91 98102 70848 ram @ macsolutionsindia.com MSN: [EMAIL PROTECTED] support @ macsolutionsindia.com +--+ Simplifying solutions for you... Macintosh, Windows, Client/Server, Web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: newbie really need help mysql binary installation problem
David, Monday, November 18, 2002, 2:53:33 AM, you wrote: DW I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel DW 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess DW in the documentation in the mysql.com web site. DW I am using bash shell, here is the list of commands i went through: DW shell groupadd mysql DW shell useradd -g mysql mysql DW shell cd /usr/local DW shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - DW shell ln -s full-path-to-mysql-VERSION-OS mysql DW shell cd mysql DW shell scripts/mysql_install_db DW shell chown -R root . DW shell chown -R mysql data DW shell chgrp -R mysql . DW shell bin/safe_mysqld --user=mysql DW after the last command, I am in /usr/local/mysql directory, I got the following:shell Starting mysqld daemon with database from DW /usr/local/mysql-3.23.53a-pc-linux-gnu-i686/data DW 021117 17:43:49 mysqld ended DW [1] + Done bin/safe_mysqld --user=mysql Check error log file, that is located in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie really need help mysql binary installation problem
Hi guys, I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess in the documentation in the mysql.com web site. I am using bash shell, here is the list of commands i went through: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql after the last command, I am in /usr/local/mysql directory, I got the following:shell Starting mysqld daemon with database from /usr/local/mysql-3.23.53a-pc-linux-gnu-i686/data 021117 17:43:49 mysqld ended [1] + Done bin/safe_mysqld --user=mysql shell so apparently i am not running mysql since i dont get mysql prompt whats the problem?.. I had tried many resources! Thanks for any input on this, guys! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Offer to Help MySQL Win32 Port -- Passing Command Parameters
OK OK! You've proved me wrong IN THIS PARTICULAR EXAMPLE. The fact remains that plenty other examples exist where MySQL could benefit from the .NET Framework. WILL MYSQL BE USING THE MICROSOFT .NET FRAMEWORK IN FUTURE DEVELOPMENT OF THE WIN32 PORT? Joseph Wagner -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Friday, November 15, 2002 12:56 PM To: Joseph D. Wagner; 'MySQL'; [EMAIL PROTECTED] Subject: Re: Offer to Help MySQL Win32 Port -- Passing Command Parameters Hi, Apropos by VB or VB.NET If you use WIN32 API(RegOpenKey,RegCreateKey,RegDeleteKey...etc) functions you can read and write in the registry wherever you wish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Joseph D. Wagner [EMAIL PROTECTED] To: 'MySQL' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, November 15, 2002 8:29 PM Subject: RE: Offer to Help MySQL Win32 Port -- Passing Command Parameters TECHNICAL EXPLAINATION: Because prior to .NET, no method existed for accessing the registry from a non-interactive process. In other words, you had to be logged in, an even then you could only access certain portions of the Registry. I disagree. Non-interactive Services can access the HKLM sections of the registry. I have even used VB6 programs as services and they are able to read and write to the registry. From : http://msdn.microsoft.com/library/en-us/dv_vstechart/html/vbtchAccessing RegistryWithVisualBasicNET.asp * BEGIN QUOTE * There is a limitation to using the built-in registry access functions: You can access only the registry keys under HKEY_CURRENT_USER\Software\VB and VBA Program Settings. To do so, you must be logged onto the system because the HKEY_CURRENT_USER registry key is not active until you log on to the system. Registry settings that are to be accessed from a noninteractive process (such as mtx.exe) should be stored under either the HKEY_LOCAL_MACHINE\Software\ or the HKEY_USER\DEFAULT\Software registry keys. Because you can use the GetSetting and SaveSetting functions to access keys only under HKEY_CURRENT_USER\Software\VB and VBA Program Settings, you may find them limiting. When that happens, you can use the Registry and RegistryKey classes in the Microsoft.Win32 namespace of the .NET Framework. * BEGIN QUOTE * You can't blame me if the documentation is wrong. Other aspects of the Win32 port could still benefit from the Microsoft .NET Framework, and since all future development using Visual Studio .NET 2002 must occur along these lines, I home the MySQL development team decides to take my help. I still haven't received a proverbial green light from any leader. Will the MySQL team use the Microsoft .NET Framework in the Win32 port for future development? I don't want to throw hours of work into something if my work is going to be turned down due to prejudice against .NET. Joseph Wagner - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Offer to Help MySQL Win32 Port -- Passing Command Parameters
On Fri, 15 Nov 2002, Joseph D. Wagner wrote: OK OK! You've proved me wrong IN THIS PARTICULAR EXAMPLE. The fact remains that plenty other examples exist where MySQL could benefit from the .NET Framework. WILL MYSQL BE USING THE MICROSOFT .NET FRAMEWORK IN FUTURE DEVELOPMENT OF THE WIN32 PORT? I think that anyone developing portable software should stay as far away from Microsoft-specific tools as possible. I see no reason to further cloud a difficulty area by popping in the latest MS fad, which, no doubt, in four to five years, will be replaced by some other marketing-driven fad. In other words, the rule of thumb should be Keep it simple, stupid. -- Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please help: MySQL automatic reconnect
Hi, I have read the MySQL manual that the automatic reconnect is implemented since version 3.21.18. Also according to the C API manual, the mysql_real_connect will set the automatic reconnect flag in MYSQL structure. However, I cannot find any instruction to switch off this automatic reconnect feature. The reason for doing this is because I am using the mysql_real_connect with an IP address that is established over a PPP link. Once if the connection over the phone line is broken, there is no way to reconnect it. My application hangs when I try to unconnect the PPP link. It seems that the MYSQL connection using blocking I/O. Is that correct? Can I use mysql_connect instead to avoid automatic reconnect? Thanks Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: need help mysql-server lost the tcp/ip-connection
Hello jantos, Tuesday, October 15, 2002, 2:03:50 PM, you wrote: jamdd when I'm connecting to mysql-server via tcp/ip then the mysql-server jamdd cuts the connection and it restarts the mysql-server. jamdd when I don't make connections from other hosts than it's running well jamdd until i make connections via tcp/ip from other hosts. jamdd on the client site: jamdd mysql -h Mymysql-server jamdd and I allways get: jamdd ERROR 2013: Lost connection to MySQL server during query jamdd on the server-host I get the message: jamdd bin/safe_mysqld: line 273: 11987 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION jamdd --pid-file=$pid_file --skip-locking $err_log 21 jamdd Number of processes running now: 1 jamdd mysqld process hanging, pid 11990 - killed jamdd 021015 12:37:53 mysqld restarted Release: mysql-3.23.53-max (Official MySQL-max binary) As this is the official MySQL binary statically linked, I would first try to upgrade the kernel, but just to be sure that the kernel is not the source of a problem. Then I'd go with the hardware as often such things happens because of broken memory, kernel panics and such. Try to see what dmesg outputs - maybe there are a clue on hardware failures?.. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help mysql-server lost the tcp/ip-connection
Description: when I'm connecting to mysql-server via tcp/ip then the mysql-server cuts the connection and it restarts the mysql-server. when I don't make connections from other hosts than it's running well until i make connections via tcp/ip from other hosts. How-To-Repeat: on the client site: mysql -h Mymysql-server and I allways get: ERROR 2013: Lost connection to MySQL server during query on the server-host I get the message: bin/safe_mysqld: line 273: 11987 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 11990 - killed 021015 12:37:53 mysqld restarted Fix: Submitter-Id: jantos Originator:[EMAIL PROTECTED] Organization: jantos MySQL support: none Synopsis: Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.53-max (Official MySQL-max binary) Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.53-max Protocol version10 Connection Localhost via UNIX socket UNIX socket /usr/data/databases/mysql/data/mysql.sock Uptime: 2 min 37 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.006 Environment: System: Linux RedHat 7.2 on kernel 2.4.9-34smp #1 SMP Sat Jun 1 06:15:25 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-108.7.2) Compilation info: CC='gcc' CFLAGS='-O2 -mpentium' CXX='gcc' CXXFLAGS='-O2 -mpentium -felide-constructors' LDFLAGS='-L/usr/local/mysql-glibc-2.2.5' LIBC: lrwxrwxrwx1 root root 13 Oct 4 10:16 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Sep 9 18:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 17:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 17:48 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Jul 9 07:57 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static 'CFLAGS=-O2 -mpentium' 'CXXFLAGS=-O2 -mpentium -felide-constructors' CXX=gcc LDFLAGS=-L/usr/local/mysql-glibc-2.2.5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - MYSQL databases disappearing!
Is your win2k server networked? does it have multiple users? I would first check the various profiles to ensure it was not moved to a different profile. Next I would ask did the administrator install the server? if another username installed the server even with admin rights that server is now officially part and parcel of that user only. Next I would investigate where the server was installed. There are a number of directories that are auto deleted every time you reboot. Look for unusually large ~.tmp files. Like ~exp0023.tmp or perhaps File00452.tmp. If the server crashes and a program is up in memory windows has a nasty habit of spitting the file in memory immediately to the disk without giving you more than a small hint what the original name was. My suspicion is you won't find any of these. Here's a typical scenario... The server is set-up with a cleaning scheduler. Every night at midnight the system runs a virus check, a scandisk and a defrag then empties the temp files and reboots. The Mysql program is running at the same time. Mysql is using a section of memory that is also used by defrag. Microsoft sometimes lets programs share memory space but some programs (virus checkers and excel are the worst) fail to give the memory back. A good midnight query is run. It crashes. The program is dropped into the Temp bin as ~ql883.tmp the server runs the cleanup process and finds a huge tmp file it cannot put in the trash bin because of it's size (mysql server + query + tables trashbin size) therefore for your convenience Microsoft auto deletes the file. Then reboots. You might get a warning that the server cannot be found but that would be it. -Original Message- From: Mike Taffi [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 1:21 PM To: [EMAIL PROTECTED] Subject: HELP - MYSQL databases disappearing! Importance: High Does anyone know why a MYSQL database would just disappear and how I might prevent it from happening in the future? I run it on win2k advanced server. Much obliged, Mike Taffi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Help! MySQL overloading my system
Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: cut last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 28687 mysql 63 0 40604K 5940K RUN0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! MySQL overloading my system
Hi, As a first step I would find out what mysql is doing, Use either 'show processlist' or using mysqladmin 'mysqladmin proc'. Or even better install mytop (cd /usr/ports/databases/mytop; make install; ). This program sorts the output for you. There does seem to be a sometimes bug with mysql that 'may' be related to the thread cache. If you have increased the thread cahce (which is mostly not needed) Try reducing the thread cache to 2, but make sure that it is not just a slow query causing the problem. Hope this helps, Ken - Original Message - From: Odhiambo Washington [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Cc: FBSD-Q [EMAIL PROTECTED] Sent: Monday, July 01, 2002 1:17 PM Subject: Help! MySQL overloading my system Alors! I run MySQL-3.23.41 on FreeBSD-4.5-STABLE but everytime I get my system slowing down and on checking with `top` I see MySQL as the culprit: cut last pid: 29586; load averages: 1.41, 1.45, 1.48 up 28+10:55:17 20:10:59 90 processes: 3 running, 83 sleeping, 1 stopped, 3 zombie CPU states: 16.7% user, 0.0% nice, 51.4% system, 0.4% interrupt, 31.5% idle Mem: 249M Active, 36M Inact, 71M Wired, 16M Cache, 48M Buf, 1960K Free Swap: 1374M Total, 58M Used, 1316M Free, 4% Inuse PID USERNAME PRI NICE SIZERES STATE C TIME WCPU CPU COMMAND 28687 mysql 63 0 40604K 5940K RUN0 27.8H 88.23% 88.23% mysqld 29489 wash 10 0 12944K 12420K nanslp 0 0:04 23.89% 11.43% perl 29424 wash 10 0 12904K 12376K nanslp 1 0:04 10.06% 6.54% perl 29382 root 30 0 2072K 1200K CPU0 0 0:02 3.50% 2.83% top 29511 exim2 0 3692K 2240K select 1 0:01 3.84% 1.51% exim 29576 exim2 0 3700K 2240K select 0 0:00 9.74% 0.93% exim 41215 www18 0 41056K 24592K lockf 1 0:40 0.29% 0.29% httpd 41216 www18 0 39980K 24316K lockf 1 0:23 0.15% 0.15% httpd 684 root2 0 1492K 840K select 1 110:49 0.10% 0.10% tpop3d Could someone more knowledgeable point me in the right direction towards isolating what could be causing this load. I have several databases on this box, TWO of which are very busy as the SMTP/POP3 daemons both interact with it as this is the main server. Thanking you in advance. -Wash -- Odhiambo Washington [EMAIL PROTECTED]The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: 254 2 313985-9 Fax: 254 2 313922 so I installed FreeBSD. GSM: 254 72 743 223 GSM: 254 733 744 121 This sig is McQ! :-) Westheimer's Discovery: A couple of months in the laboratory can frequently save a couple of hours in the library. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
HELP: MySQL Dynamic Structure
Hello all... please read I've struggled with this for YEARS - THE PROBLEM: - MySQL alone cannot represent a complex data-structure. Re-modeling of MySQL data is required in Perl, PHP, Java, etc. * MySQL needs to have the ability to add properties to columns and tables. - Explanation: - I have numerous MySQL front-end and back-end clients written in Perl, PHP, and Java. In each language - I have had to re-model the entire MySQL data stucture in that programming language. A PAIN IN THE BUTT. If I change one column, add one field, play with one table... I have to go into all of that code in all of those languages and mess with either how the front-ends and/or how the back-ends are interpreting the data-schema. - OBJECTIVE - To get MySQL to be the one, central data-source for nearly everything used in your applications and data-interfaces. Not just data... -Dynamic data. No more manual SQL statements in your applications. -Dynamic SQL. - PICTURE THIS - bear with me... - EXAMPLE # 1 - Removing a single column from one of your MySQL reports would be as simple as doing this: * mysql UPDATE myTable.myColumn SET isVisible=FALSE; It doesn't matter what programming language the report is programmed in - that column would no longer show up in the report. - EXAMPLE # 2 - Or change what name is displayed for your column name in all your MySQL reports? * mysql UPDATE myTable.myColumn SET Alias='My Display Name'; That's right! Your column display names can have spaces! Programming your column names by hand is now optional. You can add and customize any column or table to have any property you wish. - OK, BUT WHY ? - You could do the same by just editing the SQL statements of your Perl, PHP, Java, etc. application, easy... RIGHT? * WRONG. * 1.) You've got to go into (for example) your Perl scripts and change the name of the fields that are being shown there, the SQL statement itself, and the variables in Perl that the SQL statement is returning. 2.) Then go into your Visual Basic application (you know, the one that all your accounting people use) and edit that code and SQL. Then you have to re-deploy the Visual Basic application on all those desktops. 3.) Or how about that PHP script that the sales people on-the-road use - it has the same SQL report! Gotta change that, too. 4.) What about that other Java program? 5.) the C++ one? - YOUR POINT ? - * -- MySQL needs to have the ability to add properties to columns and tables. The more flexible MySQL becomes, the more flexible your applications become... and the easier they are to develop and use. Instead of SQL code in your applications, automatically generated SQL. Instead of editing programming language code... a simple SQL statement from the MySQL shell could do a lot of what's needed to alter how your applications interpret the data schema. One SQL statement... one minute of time. - POSSIBLE SOLUTION #1 - -- Add properties/attributes to MySQL columns tables For columns... Currently we have: + | Field | Type | Null | Key | Default | Extra + Are these properties flexible enough? I do not believe so. With the new file formats in MySQL 4.x and more complex data tables such as InnoDB, is it possible to ADD
Re: HELP: MySQL Dynamic Structure
On Fri, May 31, 2002 at 10:01:34AM -0500, Ryan Hatch wrote: - THE PROBLEM: - MySQL alone cannot represent a complex data-structure. Re-modeling of MySQL data is required in Perl, PHP, Java, etc. One wonders why each of these applications has such intimate knowledge of your table schemes, or mysql, or even SQL in general. If your environment warrants it (and I'd say four different platforms is good enough) you might do good to hide the database behind an abstraction layer. This being the only layer that talks to mysql for the purpose of providing primitives that the rest of your business logic (all of the perl, java, php, vb scripts) depend on. When you update table structure, you simply need to change the abstraction layer instead of all of your scripts. If you want to pitch it to management, just say XMLRPC! until their ears bleed. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP: MySQL Dynamic Structure (long)
[snip a lot...] MySQL alone cannot represent a complex data-structure. [/snip] Incorrect, and if it IS the case (from your POV) then no RDBMS can represent a complex data structure. [snip] Re-modeling of MySQL data is required in Perl, PHP, Java, etc. In each language - I have had to re-model the entire MySQL data stucture in that programming language. [/snip] Define re-modeling, succinctly. [snip] MySQL needs to have the ability to add properties to columns and tables. [/snip] No other RDBMS have this, do they? [snip] If I change one column, add one field, play with one table... I have to go into all of that code in all of those languages and mess with either how the front-ends and/or how the back-ends are interpreting the data-schema. [/snip] No you don't have to. The application will continue to work normally unless you do something funny to the database structure itself. To consider the additional data you have to make changes. Frequent changes of the underlying data model means that it is not designed for the purpose properly from the beginning due to a lack of proper analysis. [snip] - OBJECTIVE - To get MySQL to be the one, central data-source for nearly everything used in your applications and data-interfaces. Not just data...-Dynamic data. No more manual SQL statements in your applications.-Dynamic SQL. Removing a single column from one of your MySQL reports would be as simple as doing this: * mysql UPDATE myTable.myColumn SET isVisible=FALSE; It doesn't matter what programming language the report is programmed in - that column would no longer show up in the report. [/snip] I can programmatically make the report aware of column existence now, using other standard mechanisms that have been used for years. [snip] Or change what name is displayed for your column name in all your MySQL reports? * mysql UPDATE myTable.myColumn SET Alias='My Display Name'; [/snip] mysql SELECT myTable.myColumn AS My Display Name [snip] You could do the same by just editing the SQL statements of your Perl, PHP, Java, etc. application, easy... RIGHT? [/snip] You're right! [snip] - YOUR POINT ? - [/snip] [snip] Instead of SQL code in your applications, automatically generated SQL. [/snip] A mind-reading application? Automatically generated how? [snip] Instead of editing programming language code... a simple SQL statement from the MySQL shell [/snip] Do you mean a non-automatically generated SQL statement from the MySQL shell. [snip] Forcing for the existance of every database to contain two tables named TABLES and COLUMNS ? This solution is already being used by some. [/snip] And anyone with reasonable knowledge of a programming language can do this too. But I think it misses the point. Are you proposing something beyond Cobb's rules for RDBMS? If so it does not specifically affect MySQL, but you want it to because it is the database you use, right? [snip] The only possible downfall to this approach is that for any properties we wish to assign to a column - we must add to all columns. So, even though a property may only apply to a couple columns in a particular table, it would be a property for every column in every table, although it might not need to actually be defined (could be left NULL). [/snip] I love conundrums, don't you? [snip] * There needs to be a standard. I'm talking about every interface ever devised for MySQL, not just HTML formatting. After all, it's all about interfaces, is it not? MySQL holds the data - but the data means nothing unless it can be viewed, added, and edited -- hence an interface. [/snip] Given the depth and breadth of the proposed ideas I will have to say, as said before, that you are talking about RDBMS in general. Applying such a set of standards to one product is not a standard at all...just a manufacturer's feature set. [snip] * If we can make MySQL more flexible - we can make our data interfaces more flexible. [/snip] So the interfaces I design are not as flexible as I have thought? PHPMYADMIN is not flexible? Your interfaces aren't flexible? [snip] Am I missing something here that all other programmers are using? Am I embarassing myself as some intermediate programmer? Perhaps... but in my humble opinion and in light of what I've been exposed to, I feel there is a significant need for dynamic schema properties or something very similar. [/snip] Ryan, it is nice to see such youthful exhuberance! But I would like to know what your experience is with designing interfaces, what your seperate experience is using databases (design, extraction, etc.). While you have some nice points most (if not all) have been achieved at
Re: HELP: MySQL Dynamic Structure
Most of what you desire has already been done in products called FileMaker (Apple Computer) and Access (Microsoft). It's been a while since I used Access, but FileMaker will automatically change all references to a field/column if you change the field name. It will warn you of broken references if you try to remove a field/column. I could probably be considered an expert in FileMaker, but I truly find it a frustrating experience to develop in it. I constantly run into limitations and have to create workarounds. Mainly because of the dynamic interface that does so much for you, but also hides so much from you. Once MySQL gets stored procedures, you will be able to do a lot of what you are wishing for. You don't want to have your database schema exposed to client machines. Ideally, you would pass parameters to a stored procedure that would then execute the action, whether it be a query, insert, delete or whatever. Then everything is centralized. I for one would like to be able to choose my front end. PHP will probably soon have something similar to PERL DBI, which will help a lot for portability. While your suggestions and ideas would be a nice option, I wouldn't want to see the MySQL developers dedicating their resources to a front end. Just my 2 cents worth. Am I missing something here that all other programmers are using? Am I embarassing myself as some intermediate programmer? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL Dynamic Structure
MySQL alone cannot represent a complex data-structure. not true at all, it's just not object oriented but don't you know that there is still no good (consistent and complete) theoretical model for OO-DBMS. Relational Model _has_ good underlying theory and I think this is the main reason of worlwide success of RDBMS. Re-modeling of MySQL data is required in Perl, PHP, Java, etc. This is called semantical impedance and best minds of mankind found no solution yet. * MySQL needs to have the ability to add properties to columns and tables. If I change one column, add one field, play with one table... I have to go into all of that code in all of those languages and mess with either how the front-ends and/or how the back-ends are interpreting the data-schema. 1.When you change semantics of one part of a system you have to reflect it in all other parts of the system. I'm afraid there could be no automation for most general kind of semantical modifications. 2.The more flexibility and dynamic behaviour (of the system) you want the more overhead you'll get (in general). -- Best regards, Yegor __ Yegor Bryukhov, PhD student at GC CUNY office: 4330 office phone: +1(212)817-8653 home phone: +1(718)842-4250 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?
hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to bdb-3.x.x support. also, i've read that a patched bdb is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (fwd)
hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to bdb-3.x.x support. also, i've read that a patched bdb is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?
hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the --with-berkeley-db options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 aclocal.m4) seems to limit to bdb-3.x.x support. also, i've read that a patched bdb is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard -- R Blake [EMAIL PROTECTED] http://homepage.mac.com/blakers -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
John Dean [EMAIL PROTECTED] writes: Hi All you need to do is include a symlink on libmysqlclient.so.11 to point to libmysqlclient.so.10 e.g ln libmysqlclient.so.11 libmysqlclient.so.10 Not a good suggestion for libraries in general. If a library so name has changed, it means it not compatible. Install the older library in addition -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
Hi All you need to do is include a symlink on libmysqlclient.so.11 to point to libmysqlclient.so.10 e.g ln libmysqlclient.so.11 libmysqlclient.so.10 At 15:18 01/03/2002 -0500, Ronald Arenas wrote: I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.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: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
At 13:26 01/03/2002 -0700, Van wrote: Ronald Arenas wrote: I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Ron: You should be aware that V4.0.x is as stable as V3.23.x. With the exception of the new features V4.0.x is V3.23.x Might make sense to stick with a stable MySQL 3.23.xx db for now. Unless, of course, you need the enhanced features in 4.xx. Also (OT), I'd recommend getting the most current version of PHP 4.x due to the recent CERT announcement on the file upload flaw. PHP can be found at php.net. Regards, Van -- = Linux rocks!!! http://www.dedserius.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 Regards John, Former MySQL Developer - [EMAIL PROTECTED] http://www.rygannon.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
Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
Ronald Arenas wrote: I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Ron: Might make sense to stick with a stable MySQL 3.23.xx db for now. Unless, of course, you need the enhanced features in 4.xx. Also (OT), I'd recommend getting the most current version of PHP 4.x due to the recent CERT announcement on the file upload flaw. PHP can be found at php.net. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
Hi, Try to upgrade PHP to the latest version (4.1.2) , it should run fine. Regards, Jocelyn Fournier - Original Message - From: Ronald Arenas [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Friday, March 01, 2002 9:18 PM Subject: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10? I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10?
PHP is looking for the client library that gets installed with MySQL 3.23.4+. Now, you can try a QUICK fix that might not work, but it's worth a shot. Go to the directory that has the libmysqlclient.so.11 file and type the following: ln -s libmysqlclient.so.11 libmysqlclient.so.10 That should create the file libmysqlclient.so.10 that links to ...so.11. If the client library is vastly different, though, it might not work. If it doesn't work, you should go uninstall PHP, go to the directory where everything was being compiled, edit the necessary files to have PHP use libmysqlclient.so.11 instead (this might be in the Makefile - but be sure you run a make clean first), and recompile. I don't know how different the PHP RPM will be, but there should be a place where you can change the reference to libmysqlclient. I use FreeBSD's ports system and it has a special configure script that creates a little addon to the Makefile that specifies the library version numbers like 10 or 11, and you can change that file before compiling. - Jonathan -Original Message- From: Ronald Arenas [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 12:19 PM To: Mysql Subject: Please Help! MySql 4.01/PhP 4.06 looking for Libmysqlclient.so.10? I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql 3.23.49) I get a Php-mysql.4.xx requires libmysqlclient.so.10. My attempt to install MySql 4.01 ends there. I did some reading and found that libmysqlclient.so.10 comes with MySql 3.23.xx. I surfed my directories to find that MySql 4.01 installs libmysqlclient.so.11 I installed theses packages using the RH RPM Manager. Am I missing something? Ron Arenas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
HELP: MySQL
Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java programs from Linux machines that has postgreSQL and now switched to Unix that has only MySQL (don't ask me why not get postgreSQL installed). Please copy to my email address. Thanks a lot. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! MySQL service will not startUp
Robbie, Monday, February 18, 2002, 4:34:34 AM, you wrote: RN I have been working all night on something then Outlook Express crashed my RN machine and now after restarting, MySQL service will not start. I am running RN it on Win2K Pro and have had no probs until just now. I right click on it RN and choose WinNT::Start the service. The dialog comes up asking if I want to RN start the service yes, no , cancel and when I click yes the dialog disapears RN but the service does not start. RN Just noticed in the Err File: RN MySql: Table 'mysql.host' doesn't exist RN Is that it? If so, how can I fix it? Start MySQL server with --skip-grant-tables and create table 'mysql.host' by yourself: CREATE TABLE `host` ( `Host` char(60) binary NOT NULL default '', `Db` char(64) binary NOT NULL default '', `Select_priv` enum('N','Y') NOT NULL default 'N', `Insert_priv` enum('N','Y') NOT NULL default 'N', `Update_priv` enum('N','Y') NOT NULL default 'N', `Delete_priv` enum('N','Y') NOT NULL default 'N', `Create_priv` enum('N','Y') NOT NULL default 'N', `Drop_priv` enum('N','Y') NOT NULL default 'N', `Grant_priv` enum('N','Y') NOT NULL default 'N', `References_priv` enum('N','Y') NOT NULL default 'N', `Index_priv` enum('N','Y') NOT NULL default 'N', `Alter_priv` enum('N','Y') NOT NULL default 'N', PRIMARY KEY (`Host`,`Db`) ) TYPE=MyISAM COMMENT='Host privileges; Merged with database privileges' -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! MySQL service will not startUp
I have been working all night on something then Outlook Express crashed my machine and now after restarting, MySQL service will not start. I am running it on Win2K Pro and have had no probs until just now. I right click on it and choose WinNT::Start the service. The dialog comes up asking if I want to start the service yes, no , cancel and when I click yes the dialog disapears but the service does not start. Just noticed in the Err File: MySql: Table 'mysql.host' doesn't exist Is that it? If so, how can I fix it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help mysql file size
Hello Every one , i am mirroring ensembl website so i need to have tables more than 4GB. i had suse 6.4 linux 2.2 so i upgraded to suse(recent)linux 7.3 kernel 2.4.10 i586 mysql version is 11.15 Distribution is 3.23.41,for suselinux-i686 i still get error 27 from table handler of mysqlimport which is file toolarge. is this the problem with my kernel do i need to configure kernel to allow more than 4 GB . or is it in i586 i686 that bothers this file size limit . my file system is /dev/hda1 on /type reiserfs (rw) proc on /proc type proc (rw) devpts on /dev/pts type devpts (rw,mode=0620,gid=5) Thanks for any help in advance , Srikanth Srikanth Reddy Modugu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help: mysql database query
Hi, Can someone please tell me how this query can be better?? I need the clubrecords from atlethics database for onderdeel,categorie,inoutdoor. select onderdeel,categorie,MIN(prestatie) as prestatie,inoutdoor,naam,datum,wedstrijd,plaats FROM runtijden GROUP BY onderdeel,categorie,inoutdoor having count(*)=1 order by 1 In the onderdeel field there are some that has need a MAX prestatie . So i want some onderdeel with a MIN(prestatie) and some with a MAX(prestatie). And the srcipt has now some presatie that are random.. Please help. TIA, Ed. __ Scanned and protected by Inflex http://pldaniels.com/inflex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help MySQL
Hello there! I've site with 1000 hits per day. Scripts are written in Perl and use MySQL database. MySQL server works good, but sometimes suddenly crashes. Error log says: Number of processes running now: 0 020113 02:50:41 mysqld restarted 020113 2:50:42 Can't start server: Bind on TCP/IP port: Address already in 020113 2:50:42 Do you already have another mysqld server running on port: 020113 2:50:42 Aborting 020113 02:50:42 mysqld ended\n My OS is Linux RedHat 6.2 RAM 128MB CPU Celeron 500Mhz Please help! Thank you in advance. Kosyo __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP!! MySQL clinet libraries for codewarrior
Hello I'm currently developing a plugin interface for a development tool (www.runrev.com) which allows access to various databases including mysql on Mac, Win, Unix. However there seems to be no Codewarrior compatible client libraries for OSX..and the release data is a few days away can anybody help? Tuviah [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: *** HELP *** mySQL connectivity problems
Venu (and others who may have suggestions) No: the server is up and running. Plus, I don't think I was clear enough on the kind of errors I get. Let me try another way... When I try to get a connection to a local, non-running, mySQL server, I get a java.net.ConnectException. That I understand: it corresponds to the case your mentionning in your response. But here is the problem. When trying to get a connection to a remote, up and running, mySQL server, I get a java.security.AccessControlException. Obviously, this is not the same error as above. My problem is that: the address is OK, the port is OK, the name of the database is OK, the userID is OK, the password is OK, etc - and when I try to access to the database using MySQL binaries, it all work OK. The odd thing is that I got exactly the same message, even when I don't provide a userID or a password. I'm still confused... and waiting for additional suggestions. Alexandre -Original Message- From: Venu A [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 7:22 PM To: SIMONIN Alexandre Subject: RE: *** HELP *** mySQL connectivity problems As a small trial, is the server up and running at the time of connection ? Becuase you get this error only when the server is not running in the specified system with the specified port. Just try to connect to the server using other MySQL binaries and check whether the server is runinng. Coming to the error msg even after granting, yes as the application is not finding the server at all, it issues the same error at the time of connection itself. Thank you venu -Original Message- From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:06 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: *** HELP *** mySQL connectivity problems Thanks, But it doesn't help me finding out what the problem is (have a look at the code below: it basically does the same as your example). Let me just clarify: the application works all OK when mySQL runs on WinNT and when I access to my files locally. The problem comes up when porting my application to a Linux-based web server. The odd thing is that every parameters seems to be OK (hostname, port, userID, password, etc.). Another odd thing too is that I get a different exception (i.e.: java.net.ConnectException) when trying to access the server as if it were running on the same station as my java servlet (which is not the case): see item 8/ below. I think I understand the exception I get in the case describded in item 8/. I also understand why I get a different exception when contacting the proper server on the proper port (java.security.AccessControlException): so it seems that the code is going a little further. But it also seems that it is a mySQL server error. What I don't understand is why I get my connection refused when every parameters are OK (and actually: I get the very same error when trying to access a table wich doesn't exist, or a table which exists but for which I don't have the proper rights, or the table to which I want to have access to (which exists) but without providing the user or password). I'm still looking for ideas... -Original Message- From: Venu A [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 6:46 PM To: SIMONIN Alexandre; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Mysql. Com Java@Lists. Subject: RE: *** HELP *** mySQL connectivity problems Check the following link, which has the simple MyJDBC sample to connect to MySQL server and to do some basic operations. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popcioh jmlbbolpak ege If you need any further assistance, please let us know. Thanks in advance venu -Original Message- From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 9:33 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: FW: *** HELP *** mySQL connectivity problems -Original Message- From: SIMONIN Alexandre Sent: Monday, July 30, 2001 2:41 PM To: '[EMAIL PROTECTED]' Subject: *** HELP *** mySQL connectivity problems Hi, I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4 When trying to get a connection to the database, I got the following error (the code is provided below - exact id and password replaced for confidentiality). Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK Step 2 : getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase? user=myIDpassword=myPwd); *** FAILURE *** SQLException: Cannot connect to MySQL server on sherweb7.sherweb.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0 Few comments
FW: *** HELP *** mySQL connectivity problems
-Original Message- From: SIMONIN Alexandre Sent: Monday, July 30, 2001 2:41 PM To: '[EMAIL PROTECTED]' Subject: *** HELP *** mySQL connectivity problems Hi, I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4 When trying to get a connection to the database, I got the following error (the code is provided below - exact id and password replaced for confidentiality). Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK Step 2 : getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase? user=myIDpassword=myPwd); *** FAILURE *** SQLException: Cannot connect to MySQL server on sherweb7.sherweb.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0 Few comments: 1/ the mySQL server's site address is OK (not the localhost) 2/ the mySQL server's port is OK 3/ the table name is OK 4/ the userID is OK 5/ the password is OK 6/ the connection looks fine through phpMyAdmin 7/ I get the same java.security.AccessControlException when doing the same request without the userID and password 8/ I got a java.net.ConnectException (which seems normal to me) when trying to call the server as if it was local to my machine, i.e.: jdbc:mysql:///myDatabase?user=myIDpassword=myPwd 9/ granting my id with all the privileges in mySQL doesn't do any good: I can view all the tables through phpMyAdmin, but still cannot get a connection. Any suggestion? The code: try { Class.forName(org.gjt.mm.mysql.Driver); // this or the same.newInstance() does the same System.out.println(Step1: Class.forName(\org.gjt.mm.mysql.Driver\): OK); } catch (Exception e) { System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): *** FAILURE ***); } Connection myConn = null; try { myConn = DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData base?user=myIDpassword=myPwd); System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): OK); } catch (SQLException e) { System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): *** FAILURE ***); System.out.println( SQLException: +e.getMessage()); System.out.println( SQLState: +e.getSQLState()); System.out.println( VendorError: +e.getErrorCode()); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 *** mySQL connectivity problems
Check the following link, which has the simple MyJDBC sample to connect to MySQL server and to do some basic operations. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak ege If you need any further assistance, please let us know. Thanks in advance venu -Original Message- From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 9:33 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: FW: *** HELP *** mySQL connectivity problems -Original Message- From: SIMONIN Alexandre Sent: Monday, July 30, 2001 2:41 PM To: '[EMAIL PROTECTED]' Subject:*** HELP *** mySQL connectivity problems Hi, I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4 When trying to get a connection to the database, I got the following error (the code is provided below - exact id and password replaced for confidentiality). Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK Step 2 : getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase? user=myIDpassword=myPwd); *** FAILURE *** SQLException: Cannot connect to MySQL server on sherweb7.sherweb.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0 Few comments: 1/ the mySQL server's site address is OK (not the localhost) 2/ the mySQL server's port is OK 3/ the table name is OK 4/ the userID is OK 5/ the password is OK 6/ the connection looks fine through phpMyAdmin 7/ I get the same java.security.AccessControlException when doing the same request without the userID and password 8/ I got a java.net.ConnectException (which seems normal to me) when trying to call the server as if it was local to my machine, i.e.: jdbc:mysql:///myDatabase?user=myIDpassword=myPwd 9/ granting my id with all the privileges in mySQL doesn't do any good: I can view all the tables through phpMyAdmin, but still cannot get a connection. Any suggestion? The code: try { Class.forName(org.gjt.mm.mysql.Driver); // this or the same.newInstance() does the same System.out.println(Step1: Class.forName(\org.gjt.mm.mysql.Driver\): OK); } catch (Exception e) { System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): *** FAILURE ***); } Connection myConn = null; try { myConn = DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData base?user=myIDpassword=myPwd); System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): OK); } catch (SQLException e) { System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): *** FAILURE ***); System.out.println( SQLException: +e.getMessage()); System.out.println( SQLState: +e.getSQLState()); System.out.println( VendorError: +e.getErrorCode()); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: *** HELP *** mySQL connectivity problems
Thanks, But it doesn't help me finding out what the problem is (have a look at the code below: it basically does the same as your example). Let me just clarify: the application works all OK when mySQL runs on WinNT and when I access to my files locally. The problem comes up when porting my application to a Linux-based web server. The odd thing is that every parameters seems to be OK (hostname, port, userID, password, etc.). Another odd thing too is that I get a different exception (i.e.: java.net.ConnectException) when trying to access the server as if it were running on the same station as my java servlet (which is not the case): see item 8/ below. I think I understand the exception I get in the case describded in item 8/. I also understand why I get a different exception when contacting the proper server on the proper port (java.security.AccessControlException): so it seems that the code is going a little further. But it also seems that it is a mySQL server error. What I don't understand is why I get my connection refused when every parameters are OK (and actually: I get the very same error when trying to access a table wich doesn't exist, or a table which exists but for which I don't have the proper rights, or the table to which I want to have access to (which exists) but without providing the user or password). I'm still looking for ideas... -Original Message- From: Venu A [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 6:46 PM To: SIMONIN Alexandre; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Mysql. Com Java@Lists. Subject: RE: *** HELP *** mySQL connectivity problems Check the following link, which has the simple MyJDBC sample to connect to MySQL server and to do some basic operations. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak ege If you need any further assistance, please let us know. Thanks in advance venu -Original Message- From: SIMONIN Alexandre [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 9:33 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: FW: *** HELP *** mySQL connectivity problems -Original Message- From: SIMONIN Alexandre Sent: Monday, July 30, 2001 2:41 PM To: '[EMAIL PROTECTED]' Subject:*** HELP *** mySQL connectivity problems Hi, I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. I'm using mm 2.0.4 When trying to get a connection to the database, I got the following error (the code is provided below - exact id and password replaced for confidentiality). Step 1 : Class.forName(org.gjt.mm.mysql.Driver); OK Step 2 : getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase? user=myIDpassword=myPwd); *** FAILURE *** SQLException: Cannot connect to MySQL server on sherweb7.sherweb.com:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) SQLState: 08S01 VendorError: 0 Few comments: 1/ the mySQL server's site address is OK (not the localhost) 2/ the mySQL server's port is OK 3/ the table name is OK 4/ the userID is OK 5/ the password is OK 6/ the connection looks fine through phpMyAdmin 7/ I get the same java.security.AccessControlException when doing the same request without the userID and password 8/ I got a java.net.ConnectException (which seems normal to me) when trying to call the server as if it was local to my machine, i.e.: jdbc:mysql:///myDatabase?user=myIDpassword=myPwd 9/ granting my id with all the privileges in mySQL doesn't do any good: I can view all the tables through phpMyAdmin, but still cannot get a connection. Any suggestion? The code: try { Class.forName(org.gjt.mm.mysql.Driver); // this or the same.newInstance() does the same System.out.println(Step1: Class.forName(\org.gjt.mm.mysql.Driver\): OK); } catch (Exception e) { System.out.println(Class.forName(\org.gjt.mm.mysql.Driver\): *** FAILURE ***); } Connection myConn = null; try { myConn = DriverManager.getConnection(jdbc:mysql://sherweb7.sherweb.com:3306/myData base?user=myIDpassword=myPwd); System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): OK); } catch (SQLException e) { System.out.println(Step 2: getConnection(\jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myI Dpassword=myPwd\): *** FAILURE ***); System.out.println( SQLException: +e.getMessage()); System.out.println( SQLState: +e.getSQLState()); System.out.println( VendorError: +e.getErrorCode()); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
help: MySql keeps crashing
Need a little assistance. I've looked through the current MySql manual, but I can't find any information concerning my questions. My MySql server keeps crashing, or that's what my host server tells me. He claims that my scripts are crashing MySql. However, when I look at the MySql error log, I see messages like this: mysqld started on Fri Jun 8 07:36:34 PDT 2001 /usr/sbin/mysqld: ready for connections 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Fri Jun 8 14:39:45 PDT 2001 My questions are thus: If the server crashes, would it write a normal shutdown message, or is that message indicative of someone/something sending MySql a shutdown signal? Am I even looking in the correct log...should I be looking in the update log, or somewhere else? Here is some other information that may affect your answer: MySql Server version 3.22.21 Running on Cobalt RaQ with the following OS info: Linux 2.0.34 #1 mips glibc-2.0.7-10 Any help you could offer would be greatly appreciated! Chuck [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help! MySQL variables laugh at me
if faq had a sequenced primary key you could do the following select a.sezione, IF(a.sezione = b.sezione, no,yes) as hasChanged from faq as a, faq as b where faq.id = faq.id -1 -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:02 AM To: [EMAIL PROTECTED] Subject: Help! MySQL variables laugh at me I've been frying my brain over this problem for the past 24 hours and I'll be very grateful for any hints. I'm trying to recognize when the value for a field is changing value from one record to the next. For an example, look at this: mysql select sezione from faq limit 20; +---+ | sezione | +---+ | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Macintosh | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | +---+ 20 rows in set (0.01 sec) As you see, the field's value is almost always Internet, but it becomes Macintosh in the middle. I'd like to recognize this change (and, later, act on it). I thought I had found the solution by employing a bit of variable magic. And it seemed to work just fine: mysql select sezione, IF(@a=sezione, no, yes) as hasChanged, (@a:=sezione) as newValueForMemory from faq limit 20; +---++---+ | sezione | hasChanged | newValueForMemory | +---++---+ | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Macintosh | yes| Macintosh | | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | +---++---+ 20 rows in set (0.01 sec) I keep a copy of the previous value in a variable, then check that variable against the current value for the field. All is well. BUT, as soon as I tackle my real problem (on a nasty database, complex queries, and the real problem, all hell breaks loose: mysql select ordine, IF(@oldOrdine=ordine, no, yes) as hasChanged, (@oldOrdine:=ordine) as newValueForMemory from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +++---+ | ordine | hasChanged | newValueForMemory | +++---+ | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | no | 3 | +++---+ 13 rows in set (0.10 sec) WHY OH WHY is MySQL behaving like this? I tried a bunch on variations (using two variables, applying a function on the field and ever weirder ones), to no avail. It gets even more unpredictable, as if the variables refused to be set and reset. mysql select @a, ordine, @b:=ordine, @b, IF (@a=@b, 'Very Thin', 'Thin') as divider, @a:=@b from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +--+++--+---++ | @a | ordine | @b:=ordine | @b | divider | @a:=@b | +--+++--+---++ | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1
Help! MySQL variables laugh at me
I've been frying my brain over this problem for the past 24 hours and I'll be very grateful for any hints. I'm trying to recognize when the value for a field is changing value from one record to the next. For an example, look at this: mysql select sezione from faq limit 20; +---+ | sezione | +---+ | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Macintosh | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | +---+ 20 rows in set (0.01 sec) As you see, the field's value is almost always Internet, but it becomes Macintosh in the middle. I'd like to recognize this change (and, later, act on it). I thought I had found the solution by employing a bit of variable magic. And it seemed to work just fine: mysql select sezione, IF(@a=sezione, no, yes) as hasChanged, (@a:=sezione) as newValueForMemory from faq limit 20; +---++---+ | sezione | hasChanged | newValueForMemory | +---++---+ | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Macintosh | yes| Macintosh | | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | +---++---+ 20 rows in set (0.01 sec) I keep a copy of the previous value in a variable, then check that variable against the current value for the field. All is well. BUT, as soon as I tackle my real problem (on a nasty database, complex queries, and the real problem, all hell breaks loose: mysql select ordine, IF(@oldOrdine=ordine, no, yes) as hasChanged, (@oldOrdine:=ordine) as newValueForMemory from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +++---+ | ordine | hasChanged | newValueForMemory | +++---+ | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | no | 3 | +++---+ 13 rows in set (0.10 sec) WHY OH WHY is MySQL behaving like this? I tried a bunch on variations (using two variables, applying a function on the field and ever weirder ones), to no avail. It gets even more unpredictable, as if the variables refused to be set and reset. mysql select @a, ordine, @b:=ordine, @b, IF (@a=@b, 'Very Thin', 'Thin') as divider, @a:=@b from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +--+++--+---++ | @a | ordine | @b:=ordine | @b | divider | @a:=@b | +--+++--+---++ | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very Thin | 1 | | 1| 3 | 3 |1 | Very
Re: Help! MySQL variables laugh at me
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? - Original Message - From: Luca Accomazzi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 04, 2001 17:02 Subject: Help! MySQL variables laugh at me I've been frying my brain over this problem for the past 24 hours and I'll be very grateful for any hints. I'm trying to recognize when the value for a field is changing value from one record to the next. For an example, look at this: mysql select sezione from faq limit 20; +---+ | sezione | +---+ | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Macintosh | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | | Internet | +---+ 20 rows in set (0.01 sec) As you see, the field's value is almost always Internet, but it becomes Macintosh in the middle. I'd like to recognize this change (and, later, act on it). I thought I had found the solution by employing a bit of variable magic. And it seemed to work just fine: mysql select sezione, IF(@a=sezione, no, yes) as hasChanged, (@a:=sezione) as newValueForMemory from faq limit 20; +---++---+ | sezione | hasChanged | newValueForMemory | +---++---+ | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Macintosh | yes| Macintosh | | Internet | yes| Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | | Internet | no | Internet | +---++---+ 20 rows in set (0.01 sec) I keep a copy of the previous value in a variable, then check that variable against the current value for the field. All is well. BUT, as soon as I tackle my real problem (on a nasty database, complex queries, and the real problem, all hell breaks loose: mysql select ordine, IF(@oldOrdine=ordine, no, yes) as hasChanged, (@oldOrdine:=ordine) as newValueForMemory from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +++---+ | ordine | hasChanged | newValueForMemory | +++---+ | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | yes| 1 | | 1 | no | 1 | | 1 | no | 1 | | 1 | no | 1 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | yes| 3 | | 3 | no | 3 | | 3 | no | 3 | +++---+ 13 rows in set (0.10 sec) WHY OH WHY is MySQL behaving like this? I tried a bunch on variations (using two variables, applying a function on the field and ever weirder ones), to no avail. It gets even more unpredictable, as if the variables refused to be set and reset. mysql select @a, ordine, @b:=ordine, @b, IF (@a=@b, 'Very Thin', 'Thin') as divider, @a:=@b from aghi1, Not_needle_aux where (GENMATERIA = 'MONOSOF' OR GENMATERIA = 'DERMALON*') and (Needle1='pre-cut' or Needle1='stdlth' or Needle1='reel') and Needle1=Needle_code order by ordine, SIZEMR, LENGTHMETR; +--+++--+---++ | @a | ordine | @b:=ordine | @b | divider | @a:=@b | +--+++--+---++ | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very Thin | 1 | | 1| 1 | 1 |1 | Very
FW: Help! MySQL variables laugh at me
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? I don't understand perfectly your question. Do you mean how do I keep records in order or how do I keep track of the previous record's field value in the SELECTing query? how do I keep records in order In the simple example, I don't. I don't care what order the records come out, it's just an example database. :-) In the complex (real-life) example there is an ORDER BY clause. how do I keep track of the previous record's field value when SELECTing I use a variable called @oldOrdine. The last thing I do in the SELECT is stuffing in there the value of the record for the current field. Then, on the subsequent record iteration, I compare its current value with the then-current field value. L.A. -- End of Forwarded Message - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! MySQL variables laugh at me
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? Wait wait wait! I see what you mean. What I'm seeing as a loop (rows upon rows of data from the database) is a single query to MySQL. So it's fist selecting, then calculating my variable, then sorting. And in sorting, I see wrong values for my is different from the previous pseudo field. Glact. Is there anything I can do to get the functionality I'm after in any other way? I seem to remember there's a having clause which gets computed in the end? L.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! MySQL variables laugh at me
Ok. This is what I think you are wanting. Have a datetime field or even a datestamp. Before you insert, do a select to find the value of the most recent row that was added then you can calculate what you should insert from there. BTW you should include history incase some else has ideas. - Original Message - From: Luca Accomazzi [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 04, 2001 20:47 Subject: Re: Help! MySQL variables laugh at me I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am I missing something? Wait wait wait! I see what you mean. What I'm seeing as a loop (rows upon rows of data from the database) is a single query to MySQL. So it's fist selecting, then calculating my variable, then sorting. And in sorting, I see wrong values for my is different from the previous pseudo field. Glact. Is there anything I can do to get the functionality I'm after in any other way? I seem to remember there's a having clause which gets computed in the end? L.A. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(URGENT) Help mysql+redhat automatically reboot.
Hi all, My RedHat 6.1 + MySQL server box has some rare thing happens today. This box is sitting on the 192.168 network. It allows a cgi program to select and update its records. The cgi program was triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redhat) reboot itself (I did not send any halt command to it). After it restarted mysqld was not start as usual (runlevel 3, mysqld startup by default). I have to manually start mysqld by typing in ./S99mysql start. After that, everything works like normal. I have checked the server box and its log. It does not look like it was hacked. I checked the power supply and everything work fine, the UPS is protecting this server and also we have no black out here. I have spent the whole afternoon to read the server logs and hope to fine something. However, all the logs show just like a normal reboot at that time. Do you have the same experience before? If yes, please share your experience with me. Thank you. Kind Regards, Fear - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help MySQL on website...
Hi can anyone, please help me!!! I need to put a MySQL database onto my website??? What do I have to do to make this work??? Is it just 1 file that I have to upload, or do I have to do something more? My web-service-provider, have enabled my website, so that it can run a MySQL database??? Please Help! Cheers, Mads PS: the server administrator told me thta they installed a mysql-adon or something???
Re: Help MySQL on website...
Well, if you have to ask, then you are not ready. You need to discuss this with your ISP. Thay may have an implementation doc that shows you what you need to do. In the mean time, get a box, Linux, MySQL, Apache, and PHP. Read the manuals on all these, and pay special attention to the apache installation instructions. You may want to buy one of the Web-in-a-box packages that walk you through it. At any rate you have some reading to do. Mads Andersen wrote: Hi can anyone, please help me!!! I need to put a MySQL database onto my website??? What do I have to do to make this work??? Is it just 1 file that I have to upload, or do I have to do something more? My web-service-provider, have enabled my website, so that it can run a MySQL database??? Please Help! Cheers, Mads PS: the server administrator told me thta they installed a mysql-adon or something??? -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help MySQL
Hi, I have my data in MySQL DB on a Linux machine. And I want to load same data on a Windows 2000 server. On Linux I can easily do it using mysqldump and mysqlimport commands but on widows I am unable to load data (which I dumped from Linux in a .txt file) I tried LOAD DATA and mysqlimport commands for the same. But no success. Please help as its a bit urgent. Thanks, Anvita. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help MySQL
pl reply at [EMAIL PROTECTED] Hi, I have my data in MySQL DB on a Linux machine. And I want to load same data on a Windows 2000 server. On Linux I can easily do it using mysqldump and mysqlimport commands but on widows I am unable to load data (which I dumped from Linux in a .txt file) I tried LOAD DATA and mysqlimport commands for the same. But no success. Please help as its a bit urgent. Thanks, Anvita. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please help. MySQL show WARNING.
Hello. I have installed from ports on FreeBSD 4.2 mysql323-server It's working, but when I make mysql_query from php-file: $sql="INSERT INTO guest (name,city,mail,text) VALUES (\"$name\",\"$city\",\"$mail\",\"$text\")"; mysql_query($sql); In brother window I have Warning from MySQL: Warning: MySQL: Unable to save result set in /www/data/ukrsport/for/setup.php on line 141 In line 141 I have "mysql_query($sql);" But all information saved, and then I can use this information correctly. In short: information is saved correctly, but MySQL shows WARNING? Thank for answer. maxx mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please help. MySQL show WARNING.
Suggestion only: Try printing $sql on your web page and copy it to mysql prompt and see what error you get, if any. BTW: If you use single quotes, you don't need backslashes but personal choice I suppose. - Original Message - From: "maxx" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 20:06 Subject: Please help. MySQL show WARNING. Hello. I have installed from ports on FreeBSD 4.2 mysql323-server It's working, but when I make mysql_query from php-file: $sql="INSERT INTO guest (name,city,mail,text) VALUES (\"$name\",\"$city\",\"$mail\",\"$text\")"; mysql_query($sql); In brother window I have Warning from MySQL: Warning: MySQL: Unable to save result set in /www/data/ukrsport/for/setup.php on line 141 In line 141 I have "mysql_query($sql);" But all information saved, and then I can use this information correctly. In short: information is saved correctly, but MySQL shows WARNING? Thank for answer. maxx mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help mysql on solaris
hi,all when i compile mysql on Solaris 2.6 , i just run : ./configure it allways said : checking return type of sprintf... configure: error: can not run test program wh ile cross compiling anybody help me ? thanks thanks thanks wallace