How to shutdown mysql from Java

Hi, my application starts mysqld (via Runtime.getRuntime().exec) and I would like to stop it also from Java (because of technical reasons I cannot use mysqladmin). What is the best way stop shutdown mysqld? 1. FLUSH TABLES 2. Process.destroy() 3. kill PID auf Unix What do you think? Zsolt

Re: MySQL malloc error on Solaris

Ubaidul, - Original Message - From: ""Ubaidul Khan"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, March 20, 2006 8:31 PM Subject: MySQL malloc error on Solaris Hello, We are running MySQL 4.0.13 on Solaris 8 UltrSPARC with 2048 MB of RAM. This machine has pl

Re: RIGHT JOIN better than INNER JOIN?

The only relational databases I've ever used to any significant extent are MySQL and DB2. I've used DB2 for a lot longer than MySQL and on most of the platforms on which it runs over various versions. As far as I'm concerned, the answer to your questions, at least as far as DB2 goes, is: it depe

Problems with MySQL Migration Toolkit

I have downloaded sucesfully the MySQL Migration Toolkit tool. After start the error with Java appears. I have Java installed on my PC because I work with Eclipse 3.1.1 + PHPEclipse Plugin. The JDK installed is 1.5. So if any can help me ... Regards, -- ReynierPM 4to. Ing. Informática Linux

~Mysql cluster info~

Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can an

Re: Discussion: the efficiency in using foreign keys

I've always been a believer in avoiding sql procedures, for the main reason that I want to be as database-independent as possible. I know it is less efficient, but being able to switch between MySQL, Postgre, and the new freebies from IBM, Oracle, and Microsoft is a strong advantage from the bu

Re: beginning confusions

On Mon, 2006-03-20 at 16:53 -0500, Eric Beversluis wrote: > I'm just starting with mysql. I've got it going but am running into > difficulties working through 2.9.2 of the user's manual. Specifically > I'm having problems with where commands on pp 115ff are run from. > > (I'm running Fedora Core

RIGHT JOIN better than INNER JOIN?

I apologize if this is a naive question but it appears through my testing that a RIGHT JOIN may out perform an INNER JOIN in those cases where they would produce identical result sets. i.e. there are no keys in the left table that do not exist in the right table. Is this true? If so, it this pecu

Repairing packed MyISAM tables with no index file (.MYI)

Hello, I have been using myisampack to pack old MyISAM tables to archive huge amounts of data. To save more space I decided to get rid of index (.MYI) files based on the assumption that I can reconstruct those indexes whenever I needed. I've rebuild indexes on plain MyISAM tables with no problem.

Re: Errors 1005 and 1025 - but not foreign keys

Ah, it was an orphaned table due to a bad shutdown. Thanks. David On Mar 18, 2006, at 12:50 AM, Heikki Tuuri wrote: David, - Original Message - From: "David Felio" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, March 16, 2006 11:31 PM Subject: Errors 1005 and

beginning confusions

I'm just starting with mysql. I've got it going but am running into difficulties working through 2.9.2 of the user's manual. Specifically I'm having problems with where commands on pp 115ff are run from. (I'm running Fedora Core 4 and Ver 8.41 Distrib 4.1.11, for redhat-linux-gnu on i386). I fi

another update error

Ok now I am running this statement UPDATE products INNER JOIN products_ums ON products.products_id = products_ums.products_id SET products_ums.products_ums_price="552" WHERE ( products.products_model="2420-01" OR products.products_model="242001") AND products_ums.products_ums_um="EA"; and I am g

MySQL malloc error on Solaris

Hello, We are running MySQL 4.0.13 on Solaris 8 UltrSPARC with 2048 MB of RAM. This machine has plenty of swap space and has worked fine for over a year now. Out of the blue, it stopped working yesterday and after looking through the error logs, following is what I found: <

Re: update statements problem

Hey guys! thanks a bunch that really fixed my problem. Thanks for your prompt response. cybm On 3/20/06, Johan Höök <[EMAIL PROTECTED]> wrote: > > Hi, > I think your problem is that OR and AND do not > have the same precedence, AND binds tighter. > So what you need is probably: > (products_mode

Re: multiple DB copies with periodic synchronization

Chris, Interesting problem. We just went through a similar scenario. Our setup is: 1. A central server that has all data for everyone. 2. Remote databases (could be on either a single workstation or a server.) Requirements: 1. All administration (price changes, etc.) is done (web interface

Re: update statements problem

"cybermalandro cybermalandro" <[EMAIL PROTECTED]> wrote on 03/20/2006 11:00:51 AM: > I am trying to update a table with a file that has more than one update > statements like this: > > > UPDATE products set products_price="22.00" WHERE products_model="5217-01" > OR products_model="521701" AND

Re: update statements problem

Hi, I think your problem is that OR and AND do not have the same precedence, AND binds tighter. So what you need is probably: (products_model="5217-01" OR products_model="5217-01") AND products_um="CS" and the same for "PK" and "EA". The way you have you'll get an update as soon as products_mode

update statements problem

I am trying to update a table with a file that has more than one update statements like this: UPDATE products set products_price="22.00" WHERE products_model="5217-01" OR products_model="521701" AND products_um="CS"; UPDATE products set products_price="3" WHERE products_model="5217-01" OR produ

Re: multiple DB copies with periodic synchronization

Chris Cowen <[EMAIL PROTECTED]> wrote on 03/20/2006 10:34:48 AM: > Hi > > We have a mySQL database which is being used by a restaurant ordering > system, in which many of the tables > are being used to store menu item information, pricing etc. > The restaurant started off as a single outlet, but

multiple DB copies with periodic synchronization

Hi We have a mySQL database which is being used by a restaurant ordering system, in which many of the tables are being used to store menu item information, pricing etc. The restaurant started off as a single outlet, but is now about to open some more new premises. We would like to have ordering s

Re: Problems with UTF and MySQL

One must issue immediately after connection: SET NAMES 'utf8' Also look at: SHOW VARIABLES LIKE 'collation_%'; SHOW VARIABLES LIKE 'character_set_%'; Server must know what you are assking for... and they ALL have to "talk the same language" !!! -- Gabriel PREDA Senior Web Developer

Problems with UTF and MySQL

I have problem with UTF-8 character set. I use MySQL 5 and Tomcat 5.5.9.I use NetBeans for programinnig in Java. I made one database and is in UTF8,also all my JSP pages are set to UTF8 encoding,and also all HTML are set to UTF8. When i put š,đ,č,ć,ž character date in database directly from MySQL

Re: Discussion: the efficiency in using foreign keys

I'd also like to add that if you have a choice between doing something in the application logic vs. MySQL's SQL statements, then it is probably more efficient to use SQL statements, constructs and related functions, to get the job done, rather than in the application logic if possible. Keith

RE: Easy regex replace?

If "%20" are the actual characters in the varchar column you shuld be able to do UPDATE table SETcolumn_name =REPLACE(column_name,'%20',' '); You might have to use REPLACE(column_name,'\%20',' '); to force MySQL to treat "%" as an actual value instead of a wild card. -Original Message-

Re: Easy regex replace?

2006/3/19, Adam i Agnieszka Gąsiorowski FNORD <[EMAIL PROTECTED]>: > > On 2006-03-18, at 00:59, Yani Copas wrote: > > > > > Is there a quick and dirty way to update such that I can only > > affect the portion > > of a string (varchar column) that matches a regexp? > > (e.g. replace all '%20' with '

Re: deadlock - further information

Rithish, - Original Message - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, March 20, 2006 10:02 AM Subject: deadlock - further information --=_NextPart_000_0059_01C64C23.16088020 Content-Type: text/plain; charset="iso-8859-1" Co

deadlock - further information

Hello. We have a web application for our intranet, which uses MySQL for db management. The application has a way of logging query errors that are generated in the system. We get a mysql error recorded as - "Deadlock found when trying to get lock; try restarting transaction" when one of the files