Hi Machiel,
I'm not sure if you like the method I use for Export from Oracle to MySQL
databases:
You need an ODBC DSN for each, source and destination DB. Then you create an
empty Access Database with a link to the Oracle Source table.
If the destination MySQL table doesn't yet exists, you can
My quick suggestion for such a process would be to use SQL*NET formatting
commands to create a well-formed CSV file, which you then import into MySQL
using LOAD DATA INFILE.
I'm not aware of any Oracle-specific import tools in MySQL. If anything,
after the merger I would rather expect something th
ge sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> Date: Wed, 11 Nov 2009
> On Nov 11, 2009, at 9:34 AM, John Daisley wrote:
>> On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote:
>>> European regulators agree with Monty that the Oracle-Sun deal threatens
>>> database competition. Apparently Oracle means to play hardball.
>>> Meanwhile
>>> Sun revenue fell 25% in 3rd
On Nov 11, 2009, at 9:34 AM, John Daisley wrote:
> On Tue, 2009-11-10 at 23:50 -0600, Peter Brawley wrote:
>> European regulators agree with Monty that the Oracle-Sun deal threatens
>> database competition. Apparently Oracle means to play hardball. Meanwhile
>> Sun revenue fell 25% in 3rd quarter 2
I believe MySQL will still have great influence in Open Source area.
The better is that MySQL will be a separate Company which has no relation to
Sun and Oracle.
Maybe Oracle can sell MySQL to a 3rd company.
2009/11/11 John Daisley
> What I am more concerned about at the moment is how much the u
What I am more concerned about at the moment is how much the uncertainty
over the deal is hurting MySQL?
I was recently in a project planning meeting where MySQL was dismissed
completely because nobody could give guarantees about where MySQL was
going. There were a lot of concerns over where futur
In case anyone is interested, here is Monty's views on the Oracle buyout.
http://monty-says.blogspot.com/2009/04/to-be-free-or-not-to-be-free.html
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@ja
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
> > The real question is whether they will let MySQL
> > wither
> > and die by not providing updates for it?
>
> Well, MySQL is open source, right? And the source is available? I'm
> sure
> a team of devs will come to the rescue. As for
> On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
>> > The real question is whether they will let MySQL
>> > wither
>> > and die by not providing updates for it?
>>
>> Well, MySQL is open source, right? And the source is available? I'm
>> sure
>> a team of devs will come to the rescue.
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
> > The real question is whether they will let MySQL
> > wither
> > and die by not providing updates for it?
>
> Well, MySQL is open source, right? And the source is available? I'm
> sure
> a team of devs will come to the rescue. As for M
On Fri, 2009-04-24 at 12:15 -0700, David Sparks wrote:
> Glyn Astill wrote:
> >> Begone Postgres troll!
> >
> > Oh the hostility of a scorned mysql user. Joshua has posted no more FUD
> > than you mysql chaps have done yourselvs over the past few days. You were
> > worried about the future and he'
On Fri, 2009-04-24 at 18:15 +, Glyn Astill wrote:
>
> > Begone Postgres troll!
> >
>
> Oh the hostility of a scorned mysql user. Joshua has posted no more FUD than
> you mysql chaps have done yourselvs over the past few days. You were worried
> about the future and he's posted a few ideas
On Fri, 2009-04-24 at 10:42 -0700, David Sparks wrote:
>
> > --
> > PostgreSQL - XMPP: jdr...@jabber.postgresql.org
>
> Your FUD would be better posted on a Postres list with all the onging
> discussions on how Mysql doesn't support foreign keys, transactions, etc.
There is no FUD here. The que
--- On Fri, 24/4/09, David Sparks wrote:
> Mysql is getting better at a pace that is making the other
> open source DB
> servers irrelevant.
>
lol. Is that a typo? Surely you wanted to say "Mysql's bug fix list is
gathering pace..."
--
MySQL General Mailing List
For list archives: http:/
Glyn Astill wrote:
>> Begone Postgres troll!
>
> Oh the hostility of a scorned mysql user. Joshua has posted no more FUD
> than you mysql chaps have done yourselvs over the past few days. You were
> worried about the future and he's posted a few ideas of how you can
> prepare.
No he didn't. He p
--- On Fri, 24/4/09, David Sparks wrote:
> From: David Sparks
> Subject: Re: Oracle , what else ?
> To: "j...@commandprompt.com"
> Cc: "mysql@lists.mysql.com"
> Date: Friday, 24 April, 2009, 6:42 PM
> Joshua D. Drake wrote:
> > I would expect
Joshua D. Drake wrote:
> I would expect that MySQL in two years likely won't exist except on the
> most tertiary level. Most new projects will be developed in either
> PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle).
>
> Sincerely,
>
> Joshua D. Drake
>
> --
> PostgreSQL - XMPP: jdr
On Fri, 2009-04-24 at 10:56 -0400, Martin Gainty wrote:
> IF MySQL returns to opensource..(presumably under Monty's benevolent
> leadership)
> then packages that utilise MySQL could be "for paying clients only"
>
> from your perspective what is the future of MySQL?
Interesting question. I think M
At 01:44 AM 4/24/2009, Martijn Tonies wrote:
Well, MySQL is open source, right? And the source is available? I'm sure
a team of devs will come to the rescue.
Really? What would make a group of developers wanting to develop
a -database engine- for free? Some party needs to step up and pay
those
On Fri, 2009-04-24 at 08:44 +0200, Martijn Tonies wrote:
> >Well, MySQL is open source, right? And the source is available? I'm sure
> >a team of devs will come to the rescue.
>
> Really? What would make a group of developers wanting to develop
> a -database engine- for free? Some party needs to
Well, MySQL is open source, right? And the source is available? I'm sure
a team of devs will come to the rescue.
Really? What would make a group of developers wanting to develop
a -database engine- for free? Some party needs to step up and pay
those people, else you're beloved product will go n
> -Original Message-
> >After MySQL bought by the java maker,
> > and now Sun bought by Oracle,
> >
How did I miss this!?
>
> It seems like the little fish are getting eaten by the bigger fish.
>
> I understand Microsoft is now going to buy Oracle. :-)
> (Sorry, just kidding)
> The
On Thu, 2009-04-23 at 08:25 +, Glyn Astill wrote:
> --- On Wed, 22/4/09, Joshua D. Drake wrote:
> > > >what are we gonna run as RDBMS ?
> >
> > How about PostgreSQL?
> >
>
> I second that. You should all have a play with the 8.4 beta
>
I actually think a lot of primarily MySQL people are
On 21.04.2009 18:40 CE(S)T, mos wrote:
> At 08:06 AM 4/21/2009, Gilles MISSONNIER wrote:
>> what are we gonna run as RDBMS ?
>
> It seems like the little fish are getting eaten by the bigger fish.
>
> I understand Microsoft is now going to buy Oracle. :-)
> (Sorry, just kidding)
No, that would
--- On Wed, 22/4/09, Joshua D. Drake wrote:
> From: Joshua D. Drake
> Subject: Re: Oracle , what else ?
> To: "Martijn Tonies"
> Cc: mysql@lists.mysql.com
> Date: Wednesday, 22 April, 2009, 10:45 PM
> On Tue, 2009-04-21 at 15:19 +0200, Martijn
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote:
> Hey Gilles,
>
>
> >After MySQL bought by the java maker,
> > and now Sun bought by Oracle,
> >
> >what are we gonna run as RDBMS ?
How about PostgreSQL?
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
i agree with you, Since mysql code is GPL anyone can start developing
further wither another name say 'MySQL NEW'
I don't understand how any company can own since mysql code is GPL.
On Wed, Apr 22, 2009 at 11:48 AM, mos wrote:
> At 07:13 PM 4/21/2009, you wrote:
>
>> It will great if the MYSQL
It will great if the MYSQL guys were to buy mysql from Oracle for half the
price that Sun paid.
Yeah, I'm sure Widenous is writing a check as we speak. He is busy
working on Maria, a stripped down branch of MySQL.
http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html
They w
At 07:13 PM 4/21/2009, you wrote:
It will great if the MYSQL guys were to buy mysql from Oracle for half the
price that Sun paid.
Yeah, I'm sure Widenous is writing a check as we speak. He is busy
working on Maria, a stripped down branch of MySQL.
http://monty-says.blogspot.com/2008/01/maria
It will great if the MYSQL guys were to buy mysql from Oracle for half the
price that Sun paid.
They would come out making lots of money and back controlling their own
destiny.
:-)
On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller wrote:
> I hereby bet the farm that this shall not occur. I have $1
I hereby bet the farm that this shall not occur. I have $10 to say that this
shall not occur.
a) Who is going to challenge the deal?
b) What possible purpose would it serve to interr MySQL?
c) Assuming there is some reason for b) above, why incur the wrath of the
MySQL community and their possible
MySQL will live on regardless of who owns the brand. First and foremost
MySQL is a community and that community will continue to develop MySQL and
take it in the direction they want it to go. Sure Oracle could try and
force some 'features' or changes through but if the community didn't like
them th
Hi,
To see what will happen to MySQL take a look at how Oracle handled
InnoDb. How many updates have they released since they purchased it? I
really don't know so someone will need to check. Is Oracle is too big
to make MySQL updates any kind of priority? It seems that the larger
the company
At 08:06 AM 4/21/2009, Gilles MISSONNIER wrote:
hello people,
bad joke is not it ?
After MySQL bought by the java maker,
and now Sun bought by Oracle,
what are we gonna run as RDBMS ?
It seems like the little fish are getting eaten by the bigger fish.
I understand Microsoft is now going to
Hey Gilles,
After MySQL bought by the java maker,
and now Sun bought by Oracle,
what are we gonna run as RDBMS ?
Not sure what "we" are gonna run, but my office is continuing
to run MySQL when required, Firebird otherwise :-)
With regards,
Martijn Tonies
Upscene Productions
http://www.ups
On 21 Apr 2009, at 14:06, Gilles MISSONNIER wrote:
hello people,
bad joke is not it ?
After MySQL bought by the java maker,
and now Sun bought by Oracle,
what are we gonna run as RDBMS ?
I don't see what the problem is really. Anyway if there ever is a
problem in the future (which I doubt)
At 07:26 AM 11/26/2007, you wrote:
>
> Like Falcon?
>
Yes, Falcon is a great piece in the "MySQL arsenal" if you ask me (or
probably any MySQL devotee).
Craig,
I have my doubts about Falcon replacing InnoDb. I don't think it
will be fast enough to handle a lot of users.
As to w
apani; Martijn Tonies; MySql
Subject: Re: Oracle is acquiring...
Hello,
This shouldn't come as anything shocking to regular readers of this
list. Oracle picked up Sleepycat back in Feb of 2006.
http://www.oracle.com/corporate/press/2006_feb/sleepycat.html
Wel
ySql
Subject: RE: Oracle is acquiring...
Hi all,
Wow, the rumors were true. Oracle is snapping up Open Source Database
companies now. First it was Innobase (see Oracle buys Innobase. MySQL
between rock and hard place?) and now it's Sleepycat Software.
The purchase of
D] On Behalf Of
Jeremy Cole
Sent: Monday, November 26, 2007 11:15 PM
To: Shanmugam, Dhandapani
Cc: Martijn Tonies; MySql
Subject: Re: Oracle is acquiring...
Hi,
I wouldn't say the Sleepycat/BDB acquisition had anything to do with
MySQL. BDB is much more useful *outsid
vember 26, 2007 7:41 PM
To: MySql
Subject: Re: Oracle is acquiring...
surely mysql would just fork the last gpl innodb release if they got
bummed by oracle...
I doubt if they can -- from the InnoDB website:
The GPLv2 License
The GNU General Public License version 2, un
>What is the reason for Oracle to detain Mysql Features like BDB,
>INNODB...? Is there any Hidden Market strategies for that
Who knows, but Oracle?
Either way, given that MySQL isn't free and thus InnoDB isn't free,
there's money in it.
Martijn Tonies
Database Workbench - development tool f
ject: Re: Oracle is acquiring...
> surely mysql would just fork the last gpl innodb release if they got
> bummed by oracle...
I doubt if they can -- from the InnoDB website:
The GPLv2 License
The GNU General Public License version 2, under which both MySQL and
> surely mysql would just fork the last gpl innodb release if they got
> bummed by oracle...
I doubt if they can -- from the InnoDB website:
The GPLv2 License
The GNU General Public License version 2, under which both MySQL and InnoDB
are published, does not allow, without permission from MySQL
surely mysql would just fork the last gpl innodb release if they got
bummed by oracle...
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> > I am little bit worried about the mysql future and me too. Oracle
> has
> > acquired Innobase and now BDB also. Slowly it is capturing the
> whole. What
> > i
>
> Like Falcon?
>
Yes, Falcon is a great piece in the "MySQL arsenal" if you ask me (or
probably any MySQL devotee).
Cheers,
Craig Huffstetler
On Nov 26, 2007 8:06 AM, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> > I am little bit worried about the mysql future and me too. Oracle has
> > acqui
> I am little bit worried about the mysql future and me too. Oracle has
> acquired Innobase and now BDB also. Slowly it is capturing the whole. What
> is the future of mysql. my future is also related to mysqls future. MySQL
> should have some thing in their own hands
Like Falcon?
Martijn Tonies
I'd given some thought to this a while ago. The only way you are going
to be able to tell if a row changes is to have a date column on every
oracle table that indicates the last time the data changed.
You'll need some program to start up that knows the last time it ran,
and the current date, a
Hi,
Try using STDDEV(), which was given for Oracle compatibility by MySQL.
SELECT employee_id, salary, hire_date, STDDEV(salary) "Std Deviation of
Salary" FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id,
salary, hire_date ORDER BY hire_date;
Thanks,
ViSolve DB Team.
- Origin
Thanks dear. i thought u could be of some use in Oracle aswelll
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:59 PM
Subject: Re: Oracle query..
Renish wrote:
Hello,
Renish wrote:
Hello,
Sorry. Again u r wrong..
Thers no connection with MYSQL here.
Well you're *very* much in the wrong list. Why are you posting to a
MySQL list if your question has nothing to do with MySQL? You do realise
there are Oracle lists, don't you? Surely people there will be abl
Thank u for ur speedy reply.
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: "Daniel Kasak" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:51 PM
Subject: Re: Oracle query..
Renish wr
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 Ge
sh" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:39 PM
Subject: 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.
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 ti
matter.
Cheers,
Renish Koshy
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 11:50 AM
Subject: Re: Oracle query..
Renish wrote:
Hi All,
I have oracle 7.3 data available
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 s
Oops, I stand corrected.
-Sheeri
On 10/25/05, Jason Martin <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
> > What you need is the table schemas and the data. Oracle doesn't have
> > SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn'
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
> What you need is the table schemas and the data. Oracle doesn't have
> SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The oracle-supplied DBMS_METADATA package can do this for you.
-Jason Martin
--
Silence is
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
have fun tools like AUTOINCREMENT -- you're going to want to know what
the code is for any triggers on the data, because in order to do
AUTOINCREMENT in oracle
that looks like a spool file from sqlplus. does it have the data too or just
a bunch of describes?
if this is what he gave you he is either severly clue-challenged or trying
to sabotage you (my $ on later though they're not mutually exclusive).
you could write a perl program to parse this into so
mos <[EMAIL PROTECTED]> wrote on 10/10/2005 01:26:04 PM:
> http://www.crmbuyer.com/story/Kp6sQkF1sF59LB/Oracle-Puts-Squeeze-on-
> MySQL-With-Latest-Buy.xhtml
>
> How is this going to affect MySQL users?
>
> Mike
>
So far (check today's archives) not at all. We will have to wait to see
what de
I recomend to you FabForce DBDesigner 4.x with this tool you can do "Reverse
Engineering" to a database in oracle, and then once created a model, export
sql to mysql and that's it!
I have made this to some databases in oracle, is really easy do it!
Saludos!
-Original Message-
From: Nguye
Nguyen, Phong wrote:
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
You can try our Migration Toolkit which has pretty good support
for Oracle now...
http://www.mysql.com/products/migration-toolk
Hi,
> I have scripts to create constraints, sequences, storage..., tables from
> ORACLE and I don't know if I can create them in MySQL?
MySQL doesn't have "sequences" or "storage" specifiers.
You cannot run your script directly.
Depending on your current Oracle structure, you might want to give
Your original Oracle(R) query (slightly reformatted):
SELECT IMRTAB.IMR906 AS NUM906
, IMRTAB.IMRFLL AS FLL
, SUM(IMRTAB.IMRCLL) AS CLL
, ROUND(SUM(IMRTAB.IMRDSC),2) AS DUR
, ROUND(SUM(IMRTAB.IMRDSC)/SUM(IMRTAB.IMRCLL),2) AS PRO
, SUM(IMRTAB1.IMRCLL) AS CLL
An option would be a log reader program that uses
Oracle log miner to only show commited transactions
from the redo logs. You could then replay the SQL
that is being executed on the oracle box on the mysql
server as long as the tables are defined the same.
9i has an enhanced log miner that can be
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
> Hello,
>
> I found a question about Oracle 2 MySQL replication in the
> archive on Sep. 2001 but no mention since?
>
> We have a department using Oracle 8.1.7 and I'm running MySQL
> 4.0 and neither of us wants to change :-)
>
> I
In the last episode (Apr 29), Sam Peterson said:
> We are designing a new solution and I have not been able to find
> functionality anywhere in the MySQL documentation or literature.
>
> With an Oracle database you can bring up the database, recover what
> is needed, all while leaving the listene
You have a number of options, but to name a couple you could:
.. Use a tool called DBScriptor to export schema/data out of Oracle
and with a few tweaks
it can generate MySQL DDL/insert statements.
.. Use an ODBC "pump" tool like those included with the Borland
tools lik
Perl/DBI is a possibility.
--Walt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: ORACLE to MySQL migration
>
>
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
Try SQLyog - http://www.webyog.com/sqlyog
Karam
--- [EMAIL PROTECTED] wrote:
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
> MySQL 3.23
>
> I'm looking for a tool or for an algorithm which
> fully supports any
> ORACLE structures ...
> If needed I may use a commerc
SQLyog - www.webyog.com is NOT FREE but has a very
good ODBC import tool for $49 and it includes lot of
other poerful tools. You might check it out.
You can try it out for 30days before purchasing it.
karam
--- "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTECTED]>
wrote:
> Does anyone know any FREE tool
> -Original Message-
> From: Ken Brown [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 31, 2004 11:45 AM
> To: '[EMAIL PROTECTED]'
> Subject: Oracle Question
>
> Anyone managed to get oracle forms 6i to talk to MySQL - if so how?
>
> I've got ODBC working but it will not connect and
On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:
Is there an equivalent to the nvl() function of Oracle available in
MySql. I
am currently using version 4.1 alpha and am trying to execute the
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
In MySQL, the function i
What does nvl do? Here is a list of the functions from the MySQL manual:
http://www.mysql.com/doc/en/Function_Index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The kind of processing you desired is easily accomplisches
with the following perl program:
#!/usr/bin/perl
while () {
if (/TO_DATE/) {
s/TO_DATE/STR_TO_DATE/;
s/(..)\/(..)\/()/$1-$2-$3/;
s/MM\/dd\//%m-%d-%Y/;
}
print $_;
}
[EMAIL PROTECTED] cat Landon.
On Wed, Aug 20, 2003 at 10:41:54PM -0500, Dan Nelson wrote:
> In the last episode (Aug 20), Michael S. Fischer said:
> > In a word, no. The way MySQL organizes its datafiles is trivial by
> > comparison: one directory per database, two files per table (table.MYI
> > and table.MYD), one is the data
TECTED]>
To: "'Martin Gainty'" <[EMAIL PROTECTED]>; "'MySQL Users'"
<[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 5:24 PM
Subject: RE: Oracle DBA here looking for advice on MySQL
> In a word, no. The way MySQL organizes
In the last episode (Aug 20), Michael S. Fischer said:
> In a word, no. The way MySQL organizes its datafiles is trivial by
> comparison: one directory per database, two files per table (table.MYI
> and table.MYD), one is the datafile, the other is the index file. MySQL
> also does not preallocat
its tables like Oracle does.
The InnoDB storage engine does.
--Michael
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 2:20 PM
To: 'MySQL Users'
Subject: Re: Oracle DBA here looking for advice on MySQL
As a Oracl
> -Original Message-
> From: Martin Gainty [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 2:20 PM
> To: 'MySQL Users'
> Subject: Re: Oracle DBA here looking for advice on MySQL
>
>
> As a Oracle followup question
> Oracle supports Tables
ohnson, Michael '" <[EMAIL PROTECTED]>; "'MySQL Users'"
<[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 7:49 AM
Subject: RE: Oracle DBA here looking for advice on MySQL
> I'd say MySQL 2nd edition by Paul Dubois. It has the first 200 pa
I'd say MySQL 2nd edition by Paul Dubois. It has the first 200 pages
with stuff you already know, but the next 800 pages are mysql specific.
Very good reference book and best practices guide.
The only thing it's missing is what I think should be in every book (and
is in virtually none). 5 pages
er, not an app user.
Brian
-Original Message-
From: Andy Jackman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 2:29 AM
To: Johnson, Michael
Cc: MySQL Users
Subject: Re: Oracle DBA here looking for advice on MySQL
I've used a lot of Oracle, some MS Access and I'
19, 2003 9:48 AM
> To: 'Andy Jackman'
> Cc: MySQL Users
> Subject: RE: Oracle DBA here looking for advice on MySQL
>
>
> I went thru the documentation this weekend on it and found
> that there is really not to much to this database. One thing
> we learn as Orac
You might also like the INNODB table type for which there is a fairly
large online manual at http://www.innodb.com/ibman.html
-Original Message-
From: Johnson, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 12:48 PM
To: 'Andy Jackman'
Cc: MySQL Users
S
didnt see
any of that in the MySQL docs I read.
I appears that MySQL has some potential though.
Mike
-Original Message-
From: Andy Jackman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 12:29 AM
To: Johnson, Michael
Cc: MySQL Users
Subject: Re: Oracle DBA here looking for advi
I've used a lot of Oracle, some MS Access and I'm newish to MySQL. I
found it easy to write an abstraction layer for Ms Access and Oracle
despite their different approaches to some important things. I find
MySQL very sparse by comparison and I spend more time working round the
db than working with
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.
_
> I have searched the archives but have not found an answer to this.
My searches seem to come up dry the first time around lately, too.
> Our company is moving from Oracle and is in a determination phase as to its
> replacement.
> (Platforms are Windows and Solaris, and better be Linux soon, too
Some people have already mentioned the answer but forgot to mention one point. If
you do a
select owner, table_name from user_tables;
It will show you all the tables you have access to, not necessarily ones owned by you.
If you want to see tables you have created add a where clause WH
thanks, that helped
anil :)
-Original Message-
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 12:51 PM
To: Anil Garg
Subject: Re: oracle.
Anil,
I do not remember correct but you need to look
at the user_tables. 'desc user_tables'
One of the fi
'select table_name from user_tables' to see your own tables.
To see all tables you have to select from dba_tables.
-- anthony
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 9:35 AM
To: [EMAIL PROTECTED]
Subject: oracle.
hi,
m a frequent user of
There are several major differences that you will need to consider.
1. So far as I know MySQL does not allow you to assign tables and indexes to
table spaces, hence load spreading is much more difficult. You cannot split
tables and indexes so that they reside on differentt disks.
2. There are no
42 AM
To: [EMAIL PROTECTED]
Subject: RE: Oracle .dmp to mySQL
Except I don't have any access whatsoever to the Oracle server... All I
have is a flat dmp file on a CD which has all the data embedded into
this file...
I have found a tool that will extract the table structure from this
file..
ssage-
From: Tim Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 18:11
To: [EMAIL PROTECTED]
Subject: RE: Oracle .dmp to mySQL
There is a application out there that does this called SQLPorter made by
Real Soft Studio (http://www.realsoftstudio.com). It might be worth the
$$ if it
-
Sent: Monday, August 12, 2002 1:06 PM
> Hope this helps you out a little on your conversion.
>
> Serge.
>
>
> - Original Message -
> From: "Mike Townend" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 12, 2002 9:29
pe this helps you out a little on your conversion.
Serge.
- Original Message -
From: "Mike Townend" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 12, 2002 9:29 AM
Subject: RE: Oracle .dmp to mySQL
> We don't have access to the Oracle se
1 - 100 of 107 matches
Mail list logo
