Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 11:09:02AM -0700, Martin Gainty wrote: Doug I copied this from an SAP integration with Orace site http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm 5.5.3 tsnames.ora File the file ORACLE_HOME/network/admin/tnsnames.ora must point to the listener (i.e., the TCP/IP port) on the database server. (ORACLE_HOME is the directory on Unix where Oracle is installed.) For example, ora_db0_net= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=test-console.think.com) (PORT=1521) ) (CONNECT_DATA= (SID=ORCL) ) ) Note: Do not use tabs in the file tnsnames.ora. *OracleDump is performed by (SID=ORCL)* Keep us apprised to your progress... Hi Marty, Thanks for following up. I've created a tnsnames.ora file in /usr/local/oracle/9.0.1/network/admin with the settings appropriate to my host. When I run the following commands: % setenv ORACLE_HOME /usr/local/oracle/9.0.1 % setenv ORACLE_SID VAPDEV % oracledump -c -u myUser -p myPassword I get the error message... % Can't call method do on an undefined value at /home/doug/bin/oracledump line 95. When I run it with the -x switch I see... Configuration: (remove --explain/-x option to run with this configuration) Database SID: VAPDEV Database user: myUser Database password: myPassword Tables: All tables Options: --default-databaseUse default database (VAPDEV) --with-table-comments Include table comments --with-column-commentsInclude column comments --default-precision Set to 18 --default-scale Set to 0 --complete-insert Includes list of column names in insert statements I'm not a perl guy and I'm not sure what to make of it other than the variables $nls_date_format, $nls_time_format, $nls_timestamp_format have data at run-time. Thanks again for your help so far... -- Regards, Doug Marty Gainty - Original Message - From: Doug Poland [EMAIL PROTECTED] To: Jim Smith [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 6:18 AM Subject: Re: Need help with oracledump (contributed program) On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote: I'm trying to figure out how to use the contributed program oracledump in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle dump command seems to be looking for a SID in a file called tnsnames.ora. Those do not exist on the system I am using. Is it possible to still use oracledump in this case? I doubt it. It looks as if oracledump requires Oracle's network layer (SQL*Net) and unless you have that you can't do anything. The oracle thin JDBC driver implements SQL*Net for java only, but the other Oracle jdbc drivers require SQL*Net Thanks for the reply. Looks like I'll have to roll my own in Java. -- Regards, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help with oracledump (contributed program)
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote: A TNSNAMES file isn't going to help unless you have the Oracle client software installed. If you had the software, you would already have a tnsnames file. Thanks all for your help. I've found a free java-based application (JOracleDump) and am modifying that to do what I need. -- Regards, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help with oracledump (contributed program)
Hello, I'm trying to figure out how to use the contributed program oracledump in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle dump command seems to be looking for a SID in a file called tnsnames.ora. Those do not exist on the system I am using. Is it possible to still use oracledump in this case? -- Regards, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help with oracledump (contributed program)
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote: I'm trying to figure out how to use the contributed program oracledump in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle dump command seems to be looking for a SID in a file called tnsnames.ora. Those do not exist on the system I am using. Is it possible to still use oracledump in this case? I doubt it. It looks as if oracledump requires Oracle's network layer (SQL*Net) and unless you have that you can't do anything. The oracle thin JDBC driver implements SQL*Net for java only, but the other Oracle jdbc drivers require SQL*Net Thanks for the reply. Looks like I'll have to roll my own in Java. -- Regards, Doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Book
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - 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: importing from text base file with | delimiters
On Fri, Dec 14, 2001 at 03:16:56PM -0800, Phillip B. Bruce wrote: Hi, How can I import a text file database in which delimiters are | character field separated into mysql database? Crack open the manual and look for the section on *load data*. The answer is there... -- Regards, Doug - 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: ERD
On Fri, Nov 30, 2001 at 12:15:26PM -0500, Won Lee wrote: Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive. Just saw announcement for Data Architect from www.thekompany.com Check it out... -- Regards, Doug - 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: Client-side developing
On Tue, Sep 25, 2001 at 02:50:09PM -0700, Rodney Broom wrote: From: Walter Omar Autalán [EMAIL PROTECTED] I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. Have you thought about a web based app? I've successfull steered customers from an Access/MDB or VB/MDB applications to HTML based apps talking to *nix/apache/php/mysql. -- Regards, Doug - 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: Mysql Fulltextsearch
On Thu, Sep 13, 2001 at 02:17:51PM +0200, Sergei Golubchik wrote: On Sep 07, Doug Poland wrote: On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the State of Texas online. My query time went down from 120 seconds to less than a second. So, yes, it's really worth it. Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? Limited number of columns restriction applies to FULLTEXT indexes as well (I think). 500 char/index limitation does not . I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. What was your problem, exactly ? Problems is knowning how many columns can be indexed in a table. Is that number including non-FULLTEXT indexes as well? Is the 500 char/index limitation a compile-time option? I've got some more questions about the behavoir of FULLTEXT but am leaving for the weekend and will ask on Monday. Thanks for your help so far! -- Regards, Doug - 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: Mysql Fulltextsearch
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Yup. I've got the entire set of laws for the State of Texas online. My query time went down from 120 seconds to less than a second. So, yes, it's really worth it. Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? -- Regards, Doug - 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: Mysql Fulltextsearch
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote: Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build a fulltext index. Is there documentation on the limitations of fulltext? I've had no problems, but I also haven't seen any documentation on limitations. The FULLTEXT page is at http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something I've missed... Thanks for the URL, the limitiations I mentioned were discovered when I was attempting to build fulltext indexes on said tables. -- Regards, Doug - 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: Does anybody know the formula to convert difference of time in decimal
I like to work with times as follows: if 1 second = 1 / 86400 or 0.12 then 12 hours = 0.5 24 hours = 1.0 36 hours = 1.5 48 hours and 1 second = 2.12 and so on. Regards, Doug -Original Message- From: lkeeton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 13:29 To: [EMAIL PROTECTED] Subject: Does anybody know the formula to convert difference of time in decimal I am working on a project that needs to get This particular format 1000.25 1000 representing hours and 25 represent minutes 1000 means a full 1000 minutes .25 means a quarter of an hour so essentially in english language we could say a thousand hours and about 15 minutes I need a way in sql or simple programming to take a timpestamp(end time) and a timestamp(beginning time) for instance 12:00:00 is the end time 11:30:44 is the start time from here is where i need a solution that gets me the difference of these two times in a decimal format. Of course once I get that I may need to convert back in english to say there are 30 minutes and 44 seconds. any ideas - 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: newbie mysqldump problem, SOLVED!
Doug Poland wrote: Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument The problem was the ~/.my.cnf file. I took out the database=... line and mysqldump worked fine. Thanks for the help! -- Regards, Doug - 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 mysqldump problem
Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument I've perused the list archives and looked at the manual. It should work but doesn't. What am I doing wrong? mysql ver 11.12 distrib 3.23.32 mysqldump ver 8.12 distrib 3.23.32 -- Regards, Doug - 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 mysqldump problem
On Thu, Mar 08, 2001 at 03:33:54PM -0600, Gerald L. Clark wrote: Well, I am running 3.23.33, and it works for me. I'm working via ssh on an ISP's host. I wonder if there are permissions that have to be set in order to run mysqldump. Out of curiosity, I tried it on another ISP running MySQL and I have the same result :( However, on my local box, it works just fine. Anyone know what's going on? -- Regards, Doug Doug Poland wrote: On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote: mysqldump --databases db1 db2 db3 ... Note, these are complete databases, NOT tables. to try it do: mysqldump --databases mysql I've tried that. But I tried it again anyway. This is a screen copy... admin:~$ /usr/local/mysql/bin/mysqldump --databases mysql /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument /usr/local/mysql/bin/mysqldump Ver 8.12 Distrib 3.23.32, for pc-linux-gnu (i686) By Igor Romanenko, Monty, Jani Sinisa This software comes with ABSOLUTELY NO WARRANTY. This is free software, ... ... blah, blah, blah... ... Doug Poland wrote: Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument I've perused the list archives and looked at the manual. It should work but doesn't. What am I doing wrong? mysql ver 11.12 distrib 3.23.32 mysqldump ver 8.12 distrib 3.23.32 -- Regards, Doug - 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: XML support under mySQL
On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) My naive understanding is that it would be effortless to write a module in perl that translates the data returned by the DBI to XML. I'm not a perl expert so I cannot speak to that. However, I doubt that it's effortless or trivial. -- Regards, Doug - 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: XML support under mySQL
Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both implementing a lot of XML functionality in their RDBMS's. Oracle is ahead of SQLServer, I believe. Like it or not, these two RDBMS's are very influential with how the web/db community create applications. An Oracle/Java web combination is a powerful, object-oriented way for web app to speak to a database. When XML browser support matures, the web developer will be able to "easily" separate the db content from the display with style-sheets. XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. -- Regards, Doug - 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: XML support under mySQL
On Wed, Feb 21, 2001 at 05:22:31PM -0500, Michael Bacarella wrote: XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't want Microsoft and Oracle to take over the world, do we? :) Their popularity does not imply sound design. Just that they have superior marketing. SQLServer and Oracle both have superior functionality to MySQL. I'm not enough of an expert to impune their design. They do, however, get the job done quite nicely. My naive understanding is that it would be effortless to write a module in perl that translates the data returned by the DBI to XML. I'm not a perl expert so I cannot speak to that. However, I doubt that it's effortless or trivial. Why would it be easier to write said layer if it was inside the DBMS instead of outside? Speed is the reason to have it in the RDBMS. My point is that XML is coming and it's a good thing. MySQL is an important part of the Open Source community and I don't want to see it trivialized or handicapped in relation commercial RDBMS. In the meantime, I'm willing to recommend it to clients and wait patiently for increased functionality. -- Regards, Doug - 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
