Re: Import oracle

Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. Install Oracle. Pump/transfer metadata. Pump data. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS

Which to download

Hello all, Just wanted to know what is the difference between Red Hat Enterprise Linux 3 RPM (x86) downloads and Linux x86 generic RPM (dynamically linked) downloads Which one should I download for a RHEL 3 system? Thanks, Ratheesh Bhat K J

Re: Which to download

Ratheesh K J wrote: Hello all, Just wanted to know what is the difference between Red Hat Enterprise Linux 3 RPM (x86) downloads and Linux x86 generic RPM (dynamically linked) downloads Which one should I download for a RHEL 3 system? Hi Ratheesh, Use the RHEL3 one. Regards --jm

£ (Great Britain Pound) breaks MySQL insert and u pdate - disastrous overwrite

Hello, I have a Java Struts application running on Tomcat 5. I have mysql 5 installed on redhat EL 3. When a user enters text with a £ sign (Great Britain Pound) in the browser and clicks enter, any insert or update statement apparently gets truncated in mysql. The insert reliably breaks

Re: bin-log with expire_logs_days

Hi, The system variable expire_logs_days removes the binary logs automatically after the given number of days. The default is 0, which means no automatic removal. Possible removals happen at startup and at binary log rotation. For transactions, it never causes rotation instead it writes to

Fw: bin-log with expire_logs_days

Hi, For Info about the 'expire-logs-days' bug fix and new release, http://www.developertutorials.com/mysql-manual/manual_News.html Thanks ViSolve DB Team. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: George Law [EMAIL PROTECTED]; mysql@lists.mysql.com Sent:

Re: Which to download

Hi Jacques, Thanks for your response. I can see the NDB cluster storage engine rpms under the Linux x86 generic RPM (dynamically linked) downloads but not under the Red Hat Enterprise Linux 3 RPM (x86) downloads. What If the same is needed for our system (later perhaps)? What exactly is the

Re: CREATE TABLE Inv_Id

Wish MySQL would have something like what Microsoft use, uniqueidentifier as datatype.

merging mysql databases

Hi, I am developping some devices that gather and process data using mysql(embedded). Is there any easy way to merge the databases from these devices into a single database? I could easily deal with the semantics of the merge in SQL level. What I don't know is how can my merge/analysis

Seeking contribution for MySQL Quality Assurance

Hi, all. MySQL is about to launch yet another contribution project. We are still in the planning phase, and I have outlined the issue in this article: http://datacharmer.blogspot.com/2006/10/contributing-to-mysql-qa-ideas-wanted.html Comments welcome! Giuseppe -- Giuseppe Maxia, QA Developer

RE: bin-log with expire_logs_days

Thanks Dan. According to the docs, the BEFORE option was introduced in 4.1. I just tried the purge with the to option : PURGE MASTER LOGS TO 'db1-bin.002'; Query OK, 0 rows affected (0.01 sec) so I think I will just purge a couple log files at a time until I can get the disk space down to a

Re: Re: CREATE TABLE Inv_Id

Scott, what's wrong with 'PRIMARY KEY' ? Dan On 10/19/06, Scott Hamm [EMAIL PROTECTED] wrote: Wish MySQL would have something like what Microsoft use, uniqueidentifier as datatype. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Re: CREATE TABLE Inv_Id

Scott, what's wrong with 'PRIMARY KEY' ? A PRIMARY KEY has nothing to do with the uniqueidentifier datatype. A uniqueidentifier is a GUID. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts:

How can I do a SELECT without locking the table against updates?

I have a simple single-table SELECT query that takes of several minutes to complete, due to a very large number of result rows being involed. I don't think there is any way to optimise the query - MySQL is already using the appropriate index etc, it's just a huge table and the query has a large

Re: How can I do a SELECT without locking the table against updates?

On Thursday 19 October 2006 17:06, Jon Ribbens wrote: I have a simple single-table SELECT query that takes of several minutes to complete, due to a very large number of result rows being involed. I don't think there is any way to optimise the query - MySQL is already using the appropriate

RE: Re: CREATE TABLE Inv_Id

How about the UUID() function. As I recall, the differences between a UUID and Microsoft's GUID are trivial. INSERT INTO Inv_Id SET id = UUID(); Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original

Re: How can I do a SELECT without locking the table against updates?

At 09:06 AM 10/19/2006, you wrote: I have a simple single-table SELECT query that takes of several minutes to complete, due to a very large number of result rows being involed. I don't think there is any way to optimise the query - MySQL is already using the appropriate index etc, it's just a

RE: Hungarian collation

From: Peter Gulutzan [EMAIL PROTECTED] MySQL is looking for an authoritative, official statement which states all the current Hungarian collation rules. According to the Reference Level Description of the hungarian language (ISBN 9634206441 or the hungarian version on line:

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

Ok, here is an update. I have now switched everything to UTF-8, database, application, jsp page. I have added a tomcat filter that sets the request and response encoding to UTF-8 presumably before anything else sees the request (it seems to write to the log 10 times for each request). I

Re: How can I do a SELECT without locking the table against updates?

You would need to convert the table to InnoDB as George mentioned. Alternatively, break up your SELECT into many smaller selects. If your query is running slow now, it's only going to get slower and slower as your table grows. I've noticed with MySQL that large result queries don't slow down

Re: £ (Great Britain Pound) breaks MySQL insert and update - disastrous overwrit e

Paul Warner wrote: Ok, here is an update. I have now switched everything to UTF-8, database, application, jsp page. I have added a tomcat filter that sets the request and response encoding to UTF-8 presumably before anything else sees the request (it seems to write to the log 10 times for

Re: InnoDB messup

I had this problem just this morning and wound up fixing it by changing the innodb data and log file directories to new folders in the .cnf file. This enabled to server to start up (new data and log files were created) and I then restored the data from a dump. Kathy Mazur Worden -Original

Re: merging mysql databases

imre - If you are using MyISAM tables, you might be able to employ the 'mysqlhotcopy' script to snapshot the data tables, then transfer them to your merge/analysis application db. You'd need to make sure to avoid filename overlaps, and make sure to get permissions correct. In my experience

Re: £ (Great Britain Pound) breaks MySQL insert a nd update - disastrous overwrite

Turn on the querylog, and see what query mysql is actually getting. Thanks, Gerald! Indeed the query with £ signs is truncated - mysql isn't getting the last two characters (in this case it should be 424). If one more character were taken off, it would overwrite the table. update advert set

Re: How can I do a SELECT without locking the table against updates?

I have this problem too on large tables. Currently my table is 5 million or so but could easily grow to 10 to 50 times that. I ended up adding a field called Status, and then adding an index for the primary key and status fields. Then I do my UPDATES or DELETES for a particular status value

CPUs not being utilized

I am running MailWatch with mysql 4.1.20 with Red Hat Enterprise 4 on a dual XEON 3.2 with 4 GB mem. I have the smp kernel loaded so both CPUs are seen. They show up as 4 CPUs. That is the only application the server runs. I moved to this server so I could increase the query speed that was

RE: CPUs not being utilized

I don't now your application at all. That being said, if you are running a single-threaded application I don't see how MySQL could have more than one thread running on one CPU. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX:

Re: CPUs not being utilized

I don't know the MailWatch application either but I'll share my experience with a multi-threaded application that uses MySQL. I wrote a Java app that uses several threads to process data (we're validating a set of data according to our business rules). Each thread has its own connection to

Re: MySQL 5.1

any update on the 5.1 general release date? is it still on target for Q4 - Q1? any narrower window? On 8/30/06, Colin Charles [EMAIL PROTECTED] wrote: Logan, David (SST - Adelaide) wrote: Hi! Does anybody have any idea when 5.1 may come to General Release? I am particularly interested in

Re: InnoDB messup

On Thu, Oct 19, 2006 at 11:03:11AM -0500, Mazur Worden, Kathy wrote: I had this problem just this morning and wound up fixing it by changing the innodb data and log file directories to new folders in the .cnf file. This enabled to server to start up (new data and log files were created) and I

delimiter

Hi everyone. I have getting a sintax error when i try to execute DELIMITER | in my mysql 5 server. Could anyone help me about it? -- João Cândido de Souza Neto Curitiba Online [EMAIL PROTECTED] (41) 3324-2294 (41) 9985-6894 http://www.curitibaonline.com.br -- MySQL General Mailing List

Re: delimiter

João, the pipe character | often needs to be escaped, usually with a backslash like so: \| Can you post the command you are running and the error you get? Dan On 10/19/06, João Cândido de Souza Neto [EMAIL PROTECTED] wrote: Hi everyone. I have getting a sintax error when i try to execute

Re: mysqlclient in Apache

On Wednesday 18 October 2006 20:44, Dan Nelson wrote: In the last episode (Oct 18), Danny Swarzman said: I'm developing an Apache module that uses mySQL. It needs to be able to talk to a remote host. I'm doing this in a Mac. I have a simple program in C that calls

Re: delimiter

I tried to escape the pipe character but it does not work. I shall try to explain better what is happening. I have got a .sql file which create my whole database (including triggers). When i run it at phpmyadmin it fails, then i tried to run a part of my .sql file which creates a trigger in a

Deletes on big tables

Hi, This is a bit of a long mail, so apologies in advance, I've tried to five as much information as possible that I think might be useful regarding my problem. I have 3 tables where I keep cache records, the structures are something like TableA TableB TableC Id

Re: Deletes on big tables

2. If I could split the tables up into smaller tables would this help ? My dilemma here is that I can split the data, the data would be in different tables but on the same hardware, the same number of deletes would still have to happen so would it actually make any difference ? No idea

Re: Deletes on big tables

Marvin Wright wrote: I have 3 tables where I keep cache records, the structures are something like TableA is a 1 to many on TableB which is a 1 to many on TableC To give you an idea of size, TableA has 8,686,769 rows, TableB has 5,6322,236 rows and TableC has 1,089,635,551 rows. My

innodb and high server load

hi,i’ve some two forum tables with abot 700Mb each one, and they was type myisam. I was getting some lock problems and i decided to switch them to innodb, but server load growed from 3 to 20. I followed your steps but i got not any server load improvements. should i back to myisam? or is

Alter Table Add Column - How Long to update

Just curious to know, I tried to update a table with ~1.7 million rows (~1G in size) and the update took close to 15-20 minutes before it says it's done. Is this kind of speed expected? I don't really understand how the alter table add column is done, but when I look at the show processlist I

Connection character set be changed silently?

My programm connect to MYSQL server(4.1.12), set it's character set by set NAMES gbk, the variables when client programm started is character_set_client gbk character_set_connection gbk character_set_databasegbk

Oracle query..

Hi All, I have oracle 7.3 data available with me..I see many *.ora files and one Import _Rawdata.bat file. . I dont know which one to import. Now I have installed, Oracle 10 g version server and client. Could you pls tell me. how can I import those data into the Oracle 10g so that I could

Re: Oracle query..

Renish wrote: Hi All, I have oracle 7.3 data available with me..I see many *.ora files and one Import _Rawdata.bat file. . I dont know which one to import. Now I have installed, Oracle 10 g version server and client. Could you pls tell me. how can I import those data into the Oracle 10g

Re: Oracle query..

Hi Mr Kasak think you misunderstood my question I dont want to Import to MYSQL. I want to import the data into Oracle 10 G. AS I said I have orcle 7.3 data already available with me.. Please tell me in step by step what i should do? as I am new to this field. I appreciate ur time in this

Re: Oracle query..

Renish wrote: Hi Mr Kasak think you misunderstood my question I dont want to Import to MYSQL. I want to import the data into Oracle 10 G. AS I said I have orcle 7.3 data already available with me.. Please tell me in step by step what i should do? as I am new to this field. I appreciate ur

Re: Oracle query..

Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Lets imagine I only have Oracle 7.3 data and then import the same data into Oracle 10g I hope this helps Renisn - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED];

Re: Oracle query..

Renish wrote: Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Lets imagine I only have Oracle 7.3 data and then import the same data into Oracle 10g He's saying you need to talk to an oracle mailing list or forum. We don't use oracle so we can't help you. -- MySQL

Re: Oracle query..

Thank u for ur speedy reply. - Original Message - From: Chris [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: Daniel Kasak [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 1:51 PM Subject: Re: Oracle query.. Renish wrote: Hello, Sorry. Again u r wrong..