Re: Please, need help urgently
Hi, It would be time consuming to understand why the server crashed and then repair the server, as u say it is a mission crtical one , the quickest way to get it up and running would be to back up the database (copy the ur database directory completely under the data directory) reinstall MySQL cleanly and get the DB back in action again.Also make sure u've got a 'release' build of MySQL, I got the following info from a site hope that helps.. Signal 11 Description : Signal 11, or officially know as segmentation fault, means that the program accessed a memory location that was not assigned. That's usually a bug in the program. So if you're writing your own program, that's the most likely cause. However, this FAQ will concentrate on the possibilities besides that. The cause can be software or (most likely) hardware for a Signal 11 crash. Read on to find out more. (*) Of course nothing is Linux specific. If your hardware is flaky, Linux, Windows 3.1, FreeBSD, Windows NT and NextStep will all crash. If you are not reading this at http://www.BitWizard.nl/sig11/, that's where you can find the most recent version. cheers, Sundara Pandian, Megasoft Ltd, India. - Original Message - From: SplitSlim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 10:14 AM Subject: Please, need help urgently I need some help, this is a mission critical server and it has CRASHED! Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port) The server had to be rebooted, and when it came back up, my MySQL server died. It's been working flawlessly for months (5 or 6), but all the sudden mysqld will not start. Here's whats in my log... __ 020219 22:52:00 mysqld restarted mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 020219 22:52:00 mysqld restarted mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 020219 22:52:01 mysqld restarted mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 020219 22:52:01 mysqld restarted mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. _--_ This keeps repeating and repeating. Since it's a port I don't have debugging compiled into MySQL, so I can't stack trace. I've used isamchk, myisamchk, and mysqld --flush to try to clean everything up, but no luck. Please help, I need to get this thing back up tonight! If you need anymore info, I'll be on this group all night until I get this thing back up. Thanks in advance! NR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: question on selects in multiple tables
Hi, I faced the same problem, but the solution to this is you is you add as many qualifiers as you can (i'm sure there are more elegant ways to do it but it works for me:-))specfiy the qualifiers FOR BOTH the tables you are picking data from in the where clause : For Example : as you said lets consider two tables (made up the fields) : Table 1 : Inventory Fields are :Sno, PurchasedBy, Stock, Quantity Date Table2 :Customer Fields are : ID, Customer_Ref, Address, Phone,Name Here i assume PurchasedBy and Customer_Ref reflect the same data. So now the query to pick values would be like: Mysqlselect Inventory.*,Customer.Name from Inventory,Customer where Inventory.PurchasedBy=Customer.ID and Customer.ID='yourID'; The should work if you still find it all messed up..add one more qualifier like this : Mysqlselect Inventory.*,Customer.Name from Inventory,Customer where Inventory.PurchasedBy=Customer.ID and Customer.ID='yourID' and Inventory.PurchasedBy='youID'; I know it doesnt make a lot of sense to add another redundant Inventory.PurchasedBy since we've already said Inventory.PurchasedBy=Customer.ID but it does the job. Sundru, megasoft Ltd, Chennai, India. - Original Message - From: Cindy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 12:42 PM Subject: question on selects in multiple tables OK... let's say I have two tables. Let's say one is an inventory table, a bunch of items. One of the fields is for the inventory items that have been sold, and are keys to the second table, which is a list of customers; names addresses. So let's say I want to pull out all inventory items acquired in a particular month. Some of them have been sold, some have not. I want to list them all, and if they've been sold, the names of the purchasers, if not, then just blank. Problem is, of course, when I construct something like SELECT Inventory.*, Customer.Name WHERE Inventory.PurchasedBy = Customer.ID (etc) I get an ungodly mess for those items with no Customer.Name becasue of the way the query is joined(I think that's the right terminology) across the tables. Is there a way around that? This has got to be a pretty common scenario. I've tried WHERE Inventory.PurchasedBy = Customer.ID OR Inventory.PurchasedBy = 0, but that does not help. Thanks... --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New Comer
v.v.simple download the window binary of version of mysql(latest) and go next,next,next..:-) only thing if install on anywhere else other than C:\mysql you'll have to place a file called my.cnf in you C:\ directory, there'll be a line there asking you to pint to the installation directory. To check if u've intslled properly.. go to youinstalldrive\mysql\bin and run winmysqladmin first time it would ask for a user and password. now open the a dos window and go to youinstalldrive\mysql\bin and type mysql.. if it goes in and the shell becomes mysql your installation is ok. cheers, sundru, Megasoft Ltd, Chennai, India. - Original Message - From: Ardian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 9:39 AM Subject: New Comer Dear All, I'm new comer, I want to ask about Installation MySQL for Windows Family. Thanks Ardian __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Driver for JRun
Hi, You can connect to the mysql database with the following line con = DriverManager.getConnection(jdbc:mysql://localhost/database?user=someuserp assword=somepwd); But first you need the mm.mysql driver download it from the following URL: http://www.mysql.com/downloads/api-jdbc.html You would probably find more demos and info at : http://mmmysql.sourceforge.net/ as for you last question i dont think you would need apache since you got both the webserver and servlet environs...should work hopefully :-) Sundru, Soft Engg, Megasoft Ltd, India. - Original Message - From: Vaishali Vaidya [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 5:32 PM Subject: Need Driver for JRun Hi, I am a novice to MySql and am trying to develop an application on IIS-Allair JRun combination on Win NT server, with MySql as backend database. Please let me know where I can get a driver to connect JRun and MySql for the above combination. Also, do I require Apache Webserver as well and if so why? Vaishali - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Reset MySQL Root password
Hi, Did u by any choice not FLUSH PRIVELEGES when u changed the root password, if u didnt do this it makes things very easy you could go inside with mysql -u root command, then go into mysql DB -Users table and remove password where root id specified there should be two of em change both of em. and then do a FLUSH PRIVILEGE (think thats the right spelling ...) Otherwise just try SHELLmysql, if it goes in ur problems are solved, fat chance though if you followed the instruction step by step for securing your server. cheers, Sundru Soft Engg., Megasoft Ltd, India. - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: Jeremiah Jester [EMAIL PROTECTED]; 'MySQL' [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 4:01 PM Subject: RE: Reset MySQL Root password use rpm -Uvh --force $PACKAGE -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 22:35 To: 'MySQL' Subject: Reset MySQL Root password Well it seems as though i may have mistyped my root password for mysql since nothing seems be working. Anybody no how to set a new root password or how to reset the old password in mysql? Already tried uninstalling the RPM from in hopes to redo the install but when i try it tells me the package hasn't been installed. odd. When i try to install (reinstall) the RPM it tells me the package cannot install because it is already installed. Grrr. JJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php