Migration from ORACLE to MySQL - CLOB

lines when the SQL*PLUS data is spooled into a flat file. How can I deal with quotes and carriage returns in CLOB data? Thanks, Rajesh

RE: Visio Stencils

Google: http://www.google.com/search?hl=en&q=MySQL+Visio+stencils&btnG=Google+Se arch -Raj. -Original Message- From: Ben Wiechman [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 12:39 PM To: mysql@lists.mysql.com Subject: Visio Stencils Does anyone have a set of MySQL Visio stenc

RE: Database Synchronisation Methods

Hi Paul, You need to set up replication. Check http://dev.mysql.com/doc/refman/5.0/en/replication.html -Raj. -Original Message- From: Paul Ikanza [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 08, 2008 1:05 PM To: 'mysql@lists.mysql.com' Subject: Database Synchronisation Methods Hi

RE: innodb transaction not works

Hi Saravanan, Please check http://forums.mysql.com/read.php?97,18003,18003 -Raj. -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2008 1:59 PM To: mysql@lists.mysql.com Subject: innodb transaction not works Hi lists, We are running database with mi

RE: How to import oracle dump?

Have you tried the MySQL Migration Toolkit? Check http://www.mysql.com/products/tools/migration-toolkit/ Raj Mehrotra HCCS - Experts in Healthcare Learning -Original Message- From: Metalpalo [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:25 AM To: mysql@lists.mysql.com

RE: how ti put several records of one mysql table in one row of html table?

Hi, I think "GROUP_CONCAT" will do it. -Raj. -Original Message- From: afan pasalic [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 11:49 AM To: mysql@lists.mysql.com Subject: how ti put several records of one mysql table in one row of html table? hi, I have "standard" organ

RE: MySQL database synchronizing from 2 locations

Hi, Set up two-way replication between Corporate and Manufacturing. As long as a live network connection is available between the two sites, replication will carry on. Make sure that all your hardware is able to handle the peak I/O loads, in order to keep replication humming along seamlessly. If

RE: Migration from Oracle to MySQL

Check out http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html Raj Mehrotra hccs - Experts in Healthcare Learning [EMAIL PROTECTED] -Original Message- From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 26, 2007 11:11 AM To: cluster Cc: mysql@list

RE: database structure

Hi, You can do this in four tables: 1. Tag 2. Shape (with an additional field, let us call it X, describing how many data elements each shape has) 3. ShapeElements : one record describing each data element (length, width etc.) for each shape. Record count for each shape: X 4. Data Table : "X" numb

Error 2013 (Lost Connection to MySQL Server) On A Solaris 10 Box

Hi, We copied over a test copy of a multi-GB database to a new Sun V440 box running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to connect to the database, we consistently get Error 2013. Any pointers? TIA. Sincerely, Raj Mehrotra hccs [EMAIL PROTECTED]

RE: making varchar field to act like numeric field

Hi Steve, Correction: Use: "select * from table where field1 like '4%' or like '5%' or like '6%' or field1 like '7%';" Sincerely, Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rajesh Mehrotra Sent: Thursday, Septembe

RE: making varchar field to act like numeric field

Hi Steve, Try "select * from table where field1>=4% and field1<=7%" instead. Sincerely, Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 11:24 PM To: mysql@lists.mysql.com Subject: making varchar fi

RE: transitioning from ms sql

Hi Arjun, Check out the MySQL Migration Toolkit and some other tools available at http://www.mysql.com/products/tools/migration-toolkit/ and http://dev.mysql.com/downloads/gui-tools/5.0.html. Do a test migration and some testing on the migrated dataset, and you can then probably set up a plan for

RE: Looking for free MySQL Administrator

Check out http://www.mysql.com/products/tools/ for some good stuff... Raj Mehrotra [EMAIL PROTECTED] -Original Message- From: Rithish Saralaya [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 1:21 PM To: mysql@lists.mysql.com Subject: RE: Looking for free MySQL Administrator > I

Re: moving the datadir

. The db was always working fine over JDBC - it was just the cmd line utilities [like /usr/local/mysql/bin/mysql] that were acting strange. RO On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > How did you accomplish that? > > Ezra > > On 11/24/05, Rajesh Olafson &

Re: moving the datadir

Thanks Gleb, Ezra. Fixing the root user was the trick. I've got it working now. ~mm On 11/24/05, Ezra Taylor <[EMAIL PROTECTED]> wrote: > > Did you set the permissions on the new datadir? > > Ezra > > On 11/18/05, Rajesh Olafson <[EMAIL PROTECTED]> wrote

Re: moving the datadir

;# mysql -u=root > > > > What is 'SELECT CURRENT_USER();' reporting for you? > > > > > > Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > >hanks Gleb. > > > > > >I get the exact same results when I connect with: > > > >

Re: moving the datadir

atabases for which you have some > > kind of privilege, unless you have the global SHOW DATABASES privilege. > > Connect to mysql under the root user. > > > > > > Rajesh Olafson <[EMAIL PROTECTED]> wrote: > > >Hi, > > >I'm on Solaris 9 with

moving the datadir

Hi, I'm on Solaris 9 with mysql 4.1. I've moved the datadir to a new location, and edited the mysql start script directly so that it now has the line: datadir=/export/www1/data The server restarts no problem, and my phpBB web app can talk to it no problem. However when I try to connect to it us

RE: RE: MSSQL to MySQL mapping

User % instead of * -Original Message- From: John c [mailto:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 9:48 AM To: mysql@lists.mysql.com Subject: FW: RE: MSSQL to MySQL mapping Also mysql complaints when I use the *= syntax: select a.userID from USers a, UserGroups b where

Newbie - dependencies Same problem --Plz giv the solution !!

Hi Robert / Victor /. ! Tried your method and got: error : Failed dependencies > "MySQL-server conflicts with mysql-server-3.23.54a-11" > "mysql conflicts with mysql-3.23.54a-11" rpm -i mysql-server-3.23.58-1.i386.rpm > > error:Failed dependencies: > > libmysqlclient.so.10 is needed by mysq

select query

nm4 14 1nm4 37 1nm4 32 because 1n3j and 1nm4 are the only two codes which have all the 'size's requested ie., 14,32, 37. Hope my question is clear. Any kind of help is highly appreciated. Best Rajesh -- Ratna Rajesh Thangudu Research Scholar Laboratoire de Biochimie et Génét

Re: UPDATE based on value in another table

, you need to set up a Trigger. Or else, just use multiple queries, to either delete the referenced columns, or to set values in them to NULL. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: h

Re: PHP mysql_connect randomly failing

D] Try finding how you're connected using the MySql CURRENT_USER() function. Also: error_reporting (E_All ^ E_NOTICE); $con = mysqk_connect ("localhost","uname","") or die(mysql_error()); ?> Try supplying all three arguments to mysl_connect(). -- [ Rajesh

PHP API Question.

ecute the BENCHMARK() function using PHP, but there is not point to this, as I am not able to figure out the number of seconds it took. Thanks. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list arc

Re: Copying distinct data to a new table

://www.mysql.com/doc/en/INSERT_SELECT.html ex: INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE tblTemp1.fldOrder_ID > 100; -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List

Re: MySQL running out of date

27;2002-102-31') | +---+ |1037026951 | +---+ We could then probably eliminate all timestamps stored as 1969-12-31 as we know that they're illegal. -- [ Rajesh Kumar ] __

Re: MySQL running out of date

#x27;1996-67-31'); select * from test3; I ran it on MYSQL-4.10-max and was not amused. Anyone to comment?? Yeah, what's wrong with this? Absolutely expected results. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL Gene

Re: Seeking advice on best table structure

nk before you choose, for you don't want to be sorry later. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: myisamchk question (important)

enerate the warning, as that is not its duty. It is upto YOU, the DBA, to consider this. Better safe than sorry.. -- [ Rajesh Kumar ] __ Meet the guy at http://www.meetRajesh.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: "hard" sort table order

anders thoresson unknowingly asked us: Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure? If you use PhpMyAdmin (latest version), follow these steps: 1. Select your table by clicking on the left. 2. Choose '

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: and then it ran the mysql_select_db which selected the wrong table. Please re-read, re-phrase. I have an uncomfortable feeling when people use the wrong function for the wrong purpose. I'm an idiot, I should have looked for this before. Think to think more.

Re: Oracle DBA here looking for advice on MySQL ....

Johnson, Michael unknowingly asked us: What is the best book on MySQL with regard to its Architecture and how it starts up, shutdowns, processes queries, rolls back data, etc etc. ? Doesn't the documentation help? -- Think to think more, work to work more. _

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: Thank you for the code, when I did that (which I should have done, you're right) it worked fine. So, now I gotta find out where this is going wrong and why the same code is working in one place but not the other. While my connection function is only run once

Re: Server to Server Connection

Thomas Deliduka unknowingly asked us: Right, however, I am following the progression of 1,2,3. My code I pasted here showed that the connection function did the connect and select in the same function and in my debugging I did confirm that $db does equal my_database. I have also manually typed it

Re: Problem to use mysql

Dathan Vance Pattishall unknowingly asked us: There is actually a C++ mysql list that might be able to help you better then this one. -->-Original Message- -->From: Z. S.Ghand [mailto:[EMAIL PROTECTED] -->Sent: Monday, August 18, 2003 9:49 AM -->To: [EMAIL PROTECTED] -->Subject: Problem to

Re: set up question

David Fair wrote: i have working install of 3.23.46. on one server. by working, i mean that i can get this far c:\mysql\bin>mysql mysql>use mysql and then run queries. on my other server, i have reloaded 3.23.57 back from 4.04b when i was having trouble with a php page not working, (failing

Re: "table is read only" after copying table files to new server

Bennett Haselton wrote: At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote: Bennett Haselton wrote: I had already run the command: grant all on tracerlock.test to bhaselto identified by "" and that didn't work when I did it, but I didn't restart mysql after running the comma

Re: [MYSQL] Confused about DATETIME compare/subtraction

PAUL MENARD wrote: Hello All, I'm having trouble understanding the MySQL docs on how to subtract two DATETIME values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN to bring in both sets of rows. What I want is to subtract the DATETIME values to determine the number

Re: "table is read only" after copying table files to new server

Bennett Haselton wrote: I'm trying to port my MySQL tables for a database called "tracerlock" from one server to another. On the old server, in the /var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and ".frm" file for every table in the database. So after creating a database cal

importing database

my previous database was ORACLE8 IN WHICH THE BACKUPS ARE .DMP FILES PLEASE HELP ME TO CONVERT THAT INTO MYSQL DATABASE PRATHIMA RAO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

MySQL is Crashing

7;.\erecruiter\address.db', errno: 4862976) I am using My SQL version 3.23.39 Max on Windows XP I have to reboot the machine to get MySQL running again. Please help. Rajesh Kanade 8 Janapriya 34/1 Erandwane Pune 4 -

How to use Auto Increment

MySQL. Rajesh Kanade 8 Janapriya 34/1 Erandwane Pune 4 http://www.geocities.com/rrkanade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

problem

hello sir, I am Rajesh. I am an administrator in DeUS Infotech.Hyderabad,India. I had installed mysql on windows and connected with the database with Jrun for JSP pages. I am getting the error and some times the data accesiible.I am using the mmmysql.jar file for connecting the mysql with jsp

about installing mysql on windows 98

dear sir, please help me out to install the mysql windows version.the problem is i have only windows 98 as stand alone.i donot have windows NT SERVER. so can mysql be installed on windows 98 as stand alone without the help of a server.please mail back.

Link request.

Hello! Let me introduce myself. My name is Mr. Rajesh Tavakari from www.website-promotion-ranking-services.com, and you can contact me at [EMAIL PROTECTED] or [EMAIL PROTECTED] I enjoyed visiting your interesting site at http://www.mysql.com/documentation/. You may know that having high

data directory.........

Hi, I have a problem here. I installed mysql-3.23.37 on my linux 2.4.2 i686 box...as specified in the INSTALL_SOURCE file itself. For configure prefix I gave the value of /usr/local/mysql. But, when I see the directory, everything is present but the data or var directory is missing.

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Is MySQL support distributed database ?

Dear Sir, Is MySQL support distributed database or not ? If yes, then please let me know , how it's doing . Regards Rajesh Matkar

Query

ions effectively. Also can we set the autocommit to false? Here are my specifications OS= Win NT MySQL version : 3.23.35a Berkeley DB= 3.2.9 Please send me an email about the detail instructions & guidelines to solve my problems. Thanx! Regards -Rajesh

Cannot connect to local mySQL server through socket error (111)

I have the exact problem. I wonder why the file size is 0 of the file mysql.sock? I >Hi! > >Socket file specified is : /var/lib/mysql/mysql.sock >which on my system%2

Connection to remote Mysql Server.

where will I get SSH client for Windows, so that it can interact with Linux Mysql server. Rajesh.