Re: Oracle imports into MySQL
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 export the linked oracle table directly into the existing ODBC-DSN of the MySQL DB. If (later on) the destination MySQL table exists, you can create an Add-Query that inserts selected rows from the Oracle table to the end of the MySQL table. These actions could be placed into macros (Access 'autoexec' for example) and in scheduled jobs of your operating system (I hope it's Windows, because you didn't say anything about that). If you don't like the Access built-in Visual Basic language, you can use any other programming language that has components to access to ODBC databases like Borland/Embarcadero C++Builder/Delphi or Microsoft Visual C++ etc. Hope this helps. Guido Machiel Richards machi...@rdc.co.za schrieb im Newsbeitrag news:1289457988.2320.27.ca...@machielr-laptop... Good day all I am hoping that someone has got some more answers for me on the topic as most of the websites which have not been very useful. All websites I have found thus far reffers to software that either needs to be bought or otherwise need to be run manually. One of our clients are currently running MySQL for their web based systems, however all other systems are running oracle. There is a current data load process from oracle that generates a dump file of specific data, goes through a convertion process, gets imported into a mysql runnign on VM to test import, then gets pushed to MySQL production. This process was put in place quite some time ago by developers. At some stage I read something about this process not being required from MySQL 5 onwards and data imports from oracle is less troublesome. The import process needs to run every 30 minutes and the current process is too troublesome. We are busy plannign a hardware migration for the systems and are also looking at improving these processes. Does anybody have experience with this to perhaps provide me with some info on how we can improve this import process? Any assistance will be appreciated. Regards Machiel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle imports into MySQL
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 that goes the other way round :-) On Thu, Nov 11, 2010 at 7:46 AM, Machiel Richards machi...@rdc.co.zawrote: Good day all I am hoping that someone has got some more answers for me on the topic as most of the websites which have not been very useful. All websites I have found thus far reffers to software that either needs to be bought or otherwise need to be run manually. One of our clients are currently running MySQL for their web based systems, however all other systems are running oracle. There is a current data load process from oracle that generates a dump file of specific data, goes through a convertion process, gets imported into a mysql runnign on VM to test import, then gets pushed to MySQL production. This process was put in place quite some time ago by developers. At some stage I read something about this process not being required from MySQL 5 onwards and data imports from oracle is less troublesome. The import process needs to run every 30 minutes and the current process is too troublesome. We are busy plannign a hardware migration for the systems and are also looking at improving these processes. Does anybody have experience with this to perhaps provide me with some info on how we can improve this import process? Any assistance will be appreciated. Regards Machiel -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Oracle, Sun and MySQL
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 future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! regards John 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 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle, Sun and MySQL
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 john.dais...@butterflysystems.co.uk 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 future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! regards John 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 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=hexi...@gmail.com -- Thanks Best regards, Xiong HE
Re: Oracle, Sun and MySQL
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 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. 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 future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! Please remember that there are 3rd parties offering MySQL support already now, outside of MySQL AB. I'm pretty sure that should Oracle raise these prices, 3rd parties will take up that part of the market pretty quickly. Liz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle, Sun and MySQL
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 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. 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 future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! Please remember that there are 3rd parties offering MySQL support already now, outside of MySQL AB. I'm pretty sure that should Oracle raise these prices, 3rd parties will take up that part of the market pretty quickly. Liz I am aware of this Liz but corporate customers like to see support coming from 'source'. There is also a bit of an unknown with 3rd party support whereas MySQL's own support has a very good reputation and from personal experience I know it to be second to none. Regards John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle, Sun and MySQL
Martin, What does monty say? Monty made a submission to EU regulators. I can't find the URL just now. One-line summary: Letting Oracle have MySQL is worse than putting the fox in charge of the henhouse... (Florian Mueller, http://news.cnet.com/8301-13578_3-10379870-38.html). Other URLs: http://monty-says.blogspot.com/2009/10/press-release-concerning-oraclesun.html http://monty-says.blogspot.com/ http://news.cnet.com/8301-13578_3-10379870-38.html PB http://www.artfulsoftware.com - Martin Gainty wrote: tendency to work normal working hours 7am-7pm PST which could be a problem for someone in Europe, Asia or even GMT+5 who needs an immediate answer and cant wait until 7am PST i too would like MySQL to stay OpenSource there is no better a feeling of applying a patch (for your own purposes) without having to wait for the corporate leviathans 6 month cycle to release a minor patch what does monty say? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message 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 12:48:28 + Subject: Re: Oracle, Sun and MySQL From: j...@butterflysystems.co.uk To: l...@dijkmat.nl CC: john.dais...@butterflysystems.co.uk; peter.braw...@earthlink.net; mysql@lists.mysql.com 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 2009; who else but an anti-competitive giant would take a chance on buying Sun now? Story here: http://www.economist.com/businessfinance/displayStory.cfm?story_id=14840272; source=features_box1. 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 future development would go and a fear that when the deal goes through Oracle may slowly raise support and training costs to the sort of levels applicable to Oracle database products. These kind of arguments seem impossible to counter for as long as the uncertainty continues and I for one wish they would just resolve the situation either way very quickly because its hurting my business and open source software! Please remember that there are 3rd parties offering MySQL support already now, outside of MySQL AB. I'm pretty sure that should Oracle raise these prices, 3rd parties will take up that part of the market pretty quickly. Liz I am aware of this Liz but corporate customers like to see support coming from 'source'. There is also a bit of an unknown with 3rd party support whereas MySQL's own support has a very good reputation and from personal experience I know it to be second to none. Regards John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com Bing brings you maps, menus, and reviews organized in one place. Try it now. http://www.bing.com/search?q=restaurantsform=MFESRPpubl=WLHMTAGcrea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.425 / Virus Database: 270.14.60/2496 - Release Date: 11/11/09 07:40:00
RE: Oracle , what else ?
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 MySQL, as a company, they don't make even close to the potential money they can. People do not really go to MySQL for support, which is the model RedHat uses. For MySQL, it's different, because the MySQL userbase by their very nature, solve problems for a living. They have the attitude of how can I fix things? How do I make things work the way I want? This has a serious adverse effect on MySQL as a company, because the number one revenue stream for any company whos main 'product' or 'service' is open source based, is the support contract. The code is available under the GPL but the documentation is not. Without adequate documentation a project becomes less accessible and less used. -Janek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
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 MySQL, as a company, they don't make even close to the potential money they can. People do not really go to MySQL for support, which is the model RedHat uses. For MySQL, it's different, because the MySQL userbase by their very nature, solve problems for a living. They have the attitude of how can I fix things? How do I make things work the way I want? This has a serious adverse effect on MySQL as a company, because the number one revenue stream for any company whos main 'product' or 'service' is open source based, is the support contract. The code is available under the GPL but the documentation is not. Without adequate documentation a project becomes less accessible and less used. -Janek At the MySQL Conference Expo 2009 they were talking about making the documentation GPL. Lets hope they press on with that! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
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 MySQL, as a company, they don't make even close to the potential money they can. People do not really go to MySQL for support, which is the model RedHat uses. For MySQL, it's different, because the MySQL userbase by their very nature, solve problems for a living. They have the attitude of how can I fix things? How do I make things work the way I want? This has a serious adverse effect on MySQL as a company, because the number one revenue stream for any company whos main 'product' or 'service' is open source based, is the support contract. The code is available under the GPL but the documentation is not. Without adequate documentation a project becomes less accessible and less used. -Janek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
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...@jab.org
Re: Oracle , what else ?
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 question was asked, I supplied my thoughts. Further I never suggested any of the things you are stating. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 of how you can prepare. That said I do agree he's jumped in at the right time to do a bit of Postgres pushin' and pimpin' :-) You have to take your opportunities when you can :) Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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's posted a few ideas of how you can prepare. No he didn't. He posted doom and gloom: Boy you really just can't handle someone not agreeing with you can you? It will be a supported but second class citizen from Oracle. Yes, and I stand by that. Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. All you have to do is look at the SEC filings and the pricing sheet. maintain it long enough to allow MySQL to kill itself. Which I do still believe will happen. I would expect that MySQL in two years likely won't exist except on the most tertiary level. How we take one piece of the whole puzzle to make our point in the fruitless effort to discredit those who are clearly more well thought out than you. My whole point was: 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). Considering my discussion with Monty this weekend, I would exert that the above is even more true. MariaDB is set to be a meritocracy based, true community (something the current MySQL is not). I expect that it will return to a quality form of development of release when ready not when the marketing droids force you to. I have a strong faith (even if I am not technically interested) in the direction Monty is going with MariaDB. I expect to see great things. One more time: begone Postgres troll! Based on your definition of troll, I would say that I am more a MariaDB troll. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 no-where. Open source, yes, but free, no way ... When it comes to free usuage, people can go to PostgreSQL or Firebird, hey, some parties might even be better off, cause those two don't need a license for commercial usuage! With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 step up and pay those people, else you're beloved product will go no-where. SQL Lite and PostgreSQL were both originally developed for free. Yes much of PostgreSQL is sponsored by people who now get paid to work on the product but that isn't 100% the case and it took a long way to get there. That being said, this is a good point. A team of developers are likely not to pick up MySQL unless they get paid. There are too many as good or better options that are also open source. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 people, else you're beloved product will go no-where. Correct. There are multi-million dollar companies using MySQL who would lose their investment and skill set if they switched to another database. These are the ones likely willing to fund for continued development of MySQL, like the Firebird community who took up the development of the Interbase fork. There is a huge interest in MySQL and no matter what happens, it will be around for some time to come. If Oracle was smart, they should put a lot of effort into supporting it. Open source, yes, but free, no way ... When it comes to free usuage, people can go to PostgreSQL or Firebird, hey, some parties might even be better off, cause those two don't need a license for commercial usuage! I agree. They are better choices for commercial development because of the MySQL licensing policies. But no such licenses are needed for web development which is where MySQL dominates. I doubt MySQL AB makes a lot of money from licenses anyway. When was the last time you saw MySQL on a desk top? The real money is in support, just ask IBM. If Oracle dropped the licensing restrictions on MySQL altogether and charged only for support, it would put MySQL on many more desk tops and I feel they could profit from it immensely. Oracle would have a high end database and a low end database and they would end up dominating the database marketplace. It's like a manufacturer coming out with a generic no-name product to compete with its higher end product. It is done all the time in the food industry. They'd rather have the customer using their generic product than lose the customer to a competitor. Hopefully Oracle sees it that way. Just one guy's opinion. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
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 MySQL will live on in various incarnations but I do think its glory days are over. It will be a supported but second class citizen from Oracle. I was at Innotech yesterday speaking on the open source panel (http://vimeo.com/4307197) and one of the participants stated that they were nervous about the fact that MySQL had been bought twice in the last two years. I did mention that I didn't think MySQL was going away and that Oracle is a smart company and there is a lot of mind share with MySQL. However, Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. It is estimated that MySQL AB was only doing 50M a year when they were bought by Sun. 50M a year is petty cash for Oracle. So Oracle has two choices, completely change MySQL to make it more profitable and thus alienate its main user base (small websites) or maintain it long enough to allow MySQL to kill itself. MySQL is already killing itself through the various forks that have permeated through the last 9 months. Another issue I see is the potential for mass migration from MySQL by non web applications. Yes there are a lot of them. Why? Because one way Oracle can make money from MySQL is to continue to charge for linked software against MySQL. If you are building a web app as long as your web language is open source, you are good with the GPL. However if you are building a monolithic app in say C++ you have a serious problem because the nature of the GPL guarantees that your C++ app will have to be open source. As much as a lot of us are pro Open Source the majority (by far) of the world still isn't. MySQL does have a strong following in the appliance state in this way. 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...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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...@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. Begone Postgres troll! ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
--- On Fri, 24/4/09, David Sparks d...@ca.sophos.com wrote: From: David Sparks d...@ca.sophos.com Subject: Re: Oracle , what else ? To: j...@commandprompt.com j...@commandprompt.com Cc: mysql@lists.mysql.com mysql@lists.mysql.com Date: Friday, 24 April, 2009, 6:42 PM 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...@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. 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. That said I do agree he's jumped in at the right time to do a bit of Postgres pushin' and pimpin' :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 posted doom and gloom: It will be a supported but second class citizen from Oracle. Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. maintain it long enough to allow MySQL to kill itself. I would expect that MySQL in two years likely won't exist except on the most tertiary level. One more time: begone Postgres troll! Switching gears ... All said, I'm cautiously optimistic that Oracle taking over the reins to Mysql will benefit all. Mysql is the long running leader in the open source database space, and with the DB smarts of Oracle behind it I expect to see the gap between Mysql and the other open source DB servers widen, not close up. Mysql is getting better at a pace that is making the other open source DB servers irrelevant. ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
--- On Fri, 24/4/09, David Sparks d...@ca.sophos.com 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
--- On Wed, 22/4/09, Joshua D. Drake j...@commandprompt.com wrote: From: Joshua D. Drake j...@commandprompt.com Subject: Re: Oracle , what else ? To: Martijn Tonies m.ton...@upscene.com Cc: mysql@lists.mysql.com Date: Wednesday, 22 April, 2009, 10:45 PM 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? I second that. You should all have a play with the 8.4 beta -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 be funny. Microsoft buying Oracle - the new world software company name would be Miracle then! :-D Of course, Oracle will have bought IBM for their DB2 system and Java affinity before, and Microsoft will as well have bought Adobe for their PDF and Flash technologies. Then, MySQL is going to be abandoned by Miracle (they still have MSSQL, which may be a re-labelled DB2 with full PL/SQL compatibility then...) and a new small company is taking over the Open Source MySQL development... At least my crystal ball home oracle says so. But maybe I should clean it again to see things more accurately. ;-) -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Thu, 2009-04-23 at 08:25 +, Glyn Astill wrote: --- On Wed, 22/4/09, Joshua D. Drake j...@commandprompt.com 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 missing a lot of great stuff in PostgreSQL. Of course I am biased but when I look at the complaints about PostgreSQL they are largely based on years old information that is out of date. Alternately it is people who really don't know anything about databases but understand how to use MySQL. That is obviously a compelling argument. If I know how to use something and it does what I need, why change? The only counter argument I can provide to you is that there is a good chance you don't know what you are missing. Give it a shot. There are plenty of Pg people that would be happy to help MySQL people make their migration. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
-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 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 MySQL, as a company, they don't make even close to the potential money they can. People do not really go to MySQL for support, which is the model RedHat uses. For MySQL, it's different, because the MySQL userbase by their very nature, solve problems for a living. They have the attitude of how can I fix things? How do I make things work the way I want? This has a serious adverse effect on MySQL as a company, because the number one revenue stream for any company whos main 'product' or 'service' is open source based, is the support contract. Is Oracle is too big to make MySQL updates any kind of priority? The updates are not going to be a priority, granted - but compatibility might be their goal. If they can produce an upgrade path straight to Oracle, for all the current users of MySQL, the price paid for Sun, will be like peanuts, an investment for a better future. But let's not forget, Sun have some pretty kick ass systems on the go. I've seen their thin client setup, for things like presentations, and just being able to work at any terminal in the building/small group of close proximity buildings/across the entire city . *sweet!* It seems that the larger the company and the more products they have, the less interest they have in their lower revenue making products. I hope this is not the case with Oracle, but the updates in the next year will determine where MySQL is headed. Just one guy's opinion. Mike It's a good opinion Mike :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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. rofl 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 would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? Mike :-) On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller fuller.art...@gmail.comwrote: 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 bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered as an appliance and/or a blade. And if you don't think this is formidable, then wake up and smell the coffee. This could well leap-frog certain other competitors -- which is not to say they won't catch up eventually, but it is to say that Oracle has raised the bar and it's time for competitors such as MS to jump through several flaming hoops. On
Re: Oracle , what else ?
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. rofl 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 would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? The MySQL name is not free though, it's owned by MySQL AB (or Sun nowadays). So even if a fork happens, it cannot take the mysql name, having to rename tools/filenames in order to work. And after that, it has to stick with the community public. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download FREE Database Workbench Lite for MySQL! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 mo...@fastmail.fm wrote: 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. rofl 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 would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? Mike :-) On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller fuller.art...@gmail.com wrote: 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 bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered
Re: Oracle , what else ?
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, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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) there is always PostgreSQL to fall back on. Simon. smime.p7s Description: S/MIME cryptographic signature
Re: Oracle , what else ?
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.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 buy Oracle. :-) (Sorry, just kidding) re:MySQL. This is a smart move by Oracle because now they will have the dominant database on the web. They can't sell Oracle to most web developers so they need to keep MySQL alive. Whether they keep updating it is another question. I am a little worried about MySQL enterprise because they will likely hike the fees for that. They could try and pressure the major MySQL web sites like Wikipedia to switch to Oracle. I don't think this will work since most websites are free and not cash driven so they don't have the money or skill set to switch to Oracle. If they try and kill MySQL enterprise, Oracle will get one very angry community after it and they can't afford that. The real question is whether they will let MySQL wither and die by not providing updates for it? 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 and the more products they have, the less interest they have in their lower revenue making products. I hope this is not the case with Oracle, but the updates in the next year will determine where MySQL is headed. Just one guy's opinion. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 and the more products they have, the less interest they have in their lower revenue making products. I hope this is not the case with Oracle, but the updates in the next year will determine where MySQL is headed. On a similar note, Oracle bought Sleepycat in February 2006 and hence acquired the embedded BerkeleyDB database in the process. In the 3 years since then I believe there has been two updates released to BerkeleyDB. Previous to the acquisition I was updating BerkeleyDB on my servers roughly once every few months. Personally (and I hope I'm wrong) I don't believe there's room in Oracle's portfolio for two diverse RDBMSs, and I envisage them re-branding MySQL as an Oracle open-source derivative which begins as being the MySQL codebase but is slowly migrated toward Oracle's engineering, to ease the transition for growing companies moving from MySQL/Oracle open-source to the Oracle enterprise versions. Having said that this is pure speculation, and only yesterday I read something in the manual that a particular option was going to be deprecated in MySQL 7 - we haven't even seen 6 in beta yet! Like Mike said, the next year or so will tell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 the community would just keep developing 'pre-oracle' MySQL, even if that happens to be under a different name. Personally I would be surprised if the Oracle deal goes unchallenged. I don't think Oracle really 'want' MySQL as it makes very little money and it raises competition concerns. I wouldn't be surprised if Oracle were to look at offloading MySQL to ease competition fears, perhaps to someone like Google who are already heavily involved in the development of MySQL. On Tue, 2009-04-21 at 22:36 +0100, Andy Shellam wrote: Personally (and I hope I'm wrong) I don't believe there's room in Oracle's portfolio for two diverse RDBMSs, and I envisage them re-branding MySQL as an Oracle open-source derivative which begins as being the MySQL codebase but is slowly migrated toward Oracle's engineering, to ease the transition for growing companies moving from MySQL/Oracle open-source to the Oracle enterprise versions. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered as an appliance and/or a blade. And if you don't think this is formidable, then wake up and smell the coffee. This could well leap-frog certain other competitors -- which is not to say they won't catch up eventually, but it is to say that Oracle has raised the bar and it's time for competitors such as MS to jump through several flaming hoops. On Tue, Apr 21, 2009 at 6:57 PM, John Daisley john.dais...@mypostoffice.co.uk wrote: 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 the community would just keep developing 'pre-oracle' MySQL, even if that happens to be under a different name. Personally I would be surprised if the Oracle deal goes unchallenged. I don't think Oracle really 'want' MySQL as it makes very little money and it raises competition concerns. I wouldn't be surprised if Oracle were to look at offloading
Re: Oracle , what else ?
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 fuller.art...@gmail.comwrote: 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 bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered as an appliance and/or a blade. And if you don't think this is formidable, then wake up and smell the coffee. This could well leap-frog certain other competitors -- which is not to say they won't catch up eventually, but it is to say that Oracle has raised the bar and it's time for competitors such as MS to jump through several flaming hoops. On Tue, Apr 21, 2009 at 6:57 PM, John Daisley john.dais...@mypostoffice.co.uk wrote: 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 the community
Re: Oracle is acquiring...............................
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 Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle is acquiring...............................
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 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 Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle is acquiring...............................
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 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 Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Glyn Astill ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle is acquiring...............................
What is the reason for Oracle to detain Mysql Features like BDB, INNODB...? Is there any Hidden Market strategies for that Thanks Regards , Dhandapani S -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, November 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, under which both MySQL and InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle is acquiring...............................
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 for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle is acquiring...............................
Hi, I wouldn't say the Sleepycat/BDB acquisition had anything to do with MySQL. BDB is much more useful *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, Jeremy Shanmugam, Dhandapani wrote: What is the reason for Oracle to detain Mysql Features like BDB, INNODB...? Is there any Hidden Market strategies for that Thanks Regards , Dhandapani S -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, November 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, under which both MySQL and InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Sleepycat, which has been rumored for weeks, gives Oracle another open-source product to complement its proprietary database offerings. At an investor conference last week, Oracle CEO Larry Ellison reiterated the company's strategy to generate revenue from a combination of open-source and proprietary software. They produce and support the famed Berkeley DB embedded database engine and have radically improved it's features since the version 1.x days. Nowadays you get a small, fast, transactional database engine with industrial grade reliability and replication. Dilip -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] 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 *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, Jeremy Shanmugam, Dhandapani wrote: What is the reason for Oracle to detain Mysql Features like BDB, INNODB...? Is there any Hidden Market strategies for that Thanks Regards , Dhandapani S -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, November 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, under which both MySQL and InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle is acquiring...............................
Does all these reasons brings oracle massive on Global market.. compared to other databases...? Thanks Regards , Dhandapani S -Original Message- From: Parikh, Dilip Kumar Sent: Tuesday, November 27, 2007 12:03 AM To: Jeremy Cole; Shanmugam, Dhandapani Cc: Martijn Tonies; MySql 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 Sleepycat, which has been rumored for weeks, gives Oracle another open-source product to complement its proprietary database offerings. At an investor conference last week, Oracle CEO Larry Ellison reiterated the company's strategy to generate revenue from a combination of open-source and proprietary software. They produce and support the famed Berkeley DB embedded database engine and have radically improved it's features since the version 1.x days. Nowadays you get a small, fast, transactional database engine with industrial grade reliability and replication. Dilip -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] 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 *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, Jeremy Shanmugam, Dhandapani wrote: What is the reason for Oracle to detain Mysql Features like BDB, INNODB...? Is there any Hidden Market strategies for that Thanks Regards , Dhandapani S -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, November 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, under which both MySQL and InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle is acquiring...............................
Yup But it has come up with new features like Oracle's Berkeley DB 4.5 is a replication framework .etc. Dilip -Original Message- From: Jimmy G [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 12:13 AM To: Parikh, Dilip Kumar Cc: Jeremy Cole; Shanmugam, Dhandapani; 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 Well past the rumor stage at this point :) -- Jimmy Parikh, Dilip Kumar wrote: 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 Sleepycat, which has been rumored for weeks, gives Oracle another open-source product to complement its proprietary database offerings. At an investor conference last week, Oracle CEO Larry Ellison reiterated the company's strategy to generate revenue from a combination of open-source and proprietary software. They produce and support the famed Berkeley DB embedded database engine and have radically improved it's features since the version 1.x days. Nowadays you get a small, fast, transactional database engine with industrial grade reliability and replication. Dilip -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] 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 *outside* of MySQL, and has a much bigger market there anyway. The BDB storage engine is all but useless. As for Innobase/InnoDB, their motives are still unclear. :) Regards, Jeremy Shanmugam, Dhandapani wrote: What is the reason for Oracle to detain Mysql Features like BDB, INNODB...? Is there any Hidden Market strategies for that Thanks Regards , Dhandapani S -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Monday, November 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, under which both MySQL and InnoDB are published, does not allow, without permission from MySQL AB and Innobase Oy, linking of InnoDB and MySQL, or the client libraries of MySQL, to a product which you distribute but which does not itself satisfy the GNU GPLv2 license. So if Innobase doesn't grant MySQL permission, they have no leg to stand on. Either way, I think Falcon is the future if you want to stay with MySQL only, other options are available if you want to go 3rd party... Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle is acquiring...............................
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 why is Oracle buying InnoDb and BDB? I think it is because Larry Ellison is a true humanitarian who would like to share some of his wealth with the Open Source community (including MySQL) who have been overworked and under funded for years. cough cough :) Mike 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 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 Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle to Mysql Sync
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, and look for any changed rows between those two dates/times. All dates/times need to come from the database (not the OS). After it finishes, the current date that the code generated needs to be saved somewhere for the next iteration. This won't work when rows are deleted from the database. If you are lucky, and this never happens, it's not an issue. If it only happens on a few tables, you can put triggers on that table (ON DELETE) to generate delete-statements to store in some log-type-table that your program can then execute on the mysql database (and then remove the rows from the log-type-table). If you have 500 tables that can have rows deleted, then you have a bit of work on your hands. This isn't an elegant or simple solution, but I don't know of any application or tool that can be used to watch Oracle tables and apply the changes to a MySQL table in real-time or near real time. On the flip side, because you will be batching updates/inserts/deletes that happen over a period of time (even if it's just 10-15 minutes) and apply them to MySQL all at once, you will be putting 10-15 minutes worth of Oracle processing onto MySQL all at once. Unfort, this isn't an apples-to-apples test. The Oracle statement might be, update some_table set some_column = 'xyz' where some_other_column='abc' and some_third_column_id in (select some_value from some_other_table where some_column = 12) and the mysql statements would just be a bunch of updates keyed off the primary key. Oracle is doing way more work. If you need to do an oranges-to-oranges comparison, then unfortunately the only thing I can think of is to log statements in a centralized location (the Oracle database?) and then replay them in order on the MySQL database. Again, this could be quite a bit of work. The third option is to take the archived redo logs and extract the SQL from them, and replay that SQL (assuming your Oracle-SQL is ANSI-compliant and doesn't use (+) etc for outer joins, and isn't full of Oracle-specific functions, etc). This will only capture updates, inserts, deletes, however; any load on your database due to selects-statements won't be replayed on the MySQL cluster. Check out, http://download-east.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90117/logminer.htm Note that you might have a tough time running this every 15 minutes. All that said, MySQL Cluster is definitely a different beast. No foreign keys, and potentially slow selects if the query needs to hit multiple clusters to retrieve data. You also need a lot of RAM (2.1 times your dataset, if I remember correctly), etc, etc. Some of this goes away in MySQL 5.1. There is a book coming out in a few weeks on the MySQL Cluster, and the MySQL Conference in Santa Clara has a set of talks devoted to MySQL Cluster. David Shain Miley wrote: Hello everyone, I had a quick question...I am looking to move away from our dependence on Oracle over to using a Mysql Cluster. Due to the complexity of the move it will have to happen over a period of time, what I would like to do is keep our mysql database in sync with our Oracle DBthis would allow us to prove that the MySQL db can deal with the load, provide the needed uptime,etc. Does anyone have any thoughts on this..I don't mean I need this done once..best case is every time something changes in an oracle table, the change will get send to Mysql...worst case...it needs to be out of sync by no more the 15 minutes...what do you thinkis it possible? Thanks in advance, SKM - Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: oracle transfer question
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. - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, December 21, 2006 8:29 AM Subject: oracle transfer question There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 137 3600 14-7月 -95 0 141 3500 17-10月-95 70.7106781 133 3300 14-6月 -96 152.752523 142 3100 29-1月 -97 221.735578 131 2500 16-2月 -97 435.889894 125 3200 16-7月 -97 389.871774 129 3300 20-8月 -97 357.903951 138 3200 26-10月-97 331.393163 130 2800 30-10月-97 339.116499 139 2700 12-2月 -98 352.136337 143 2600 15-3月 -98 369.028208 EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 140 2500 06-4月 -98 388.762606 144 2500 09-7月 -98 399.679359 134 2900 26-8月 -98 384.664832 126 2700 28-9月 -98 377.586319 127 2400 14-1月 -99 390.72582 132 2100 10-4月 -99 427.974023 135 2400 12-12月-99 430.116263 136 2200 06-2月 -00 443.800703 128 2200 08-3月 -00 453.379126 I transfer the oracle sql to mysql sql: SELECT employee_id, salary, hire_date, STDDEV_pop(salary)Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; But the result are: +-+++-+ | employee_id | salary | hire_date | Std Deviation of Salary | +-+++-+ | 137 | 3600 | 1995-07-14 | 0. | | 141 | 3500 | 1995-10-17 | 0. | | 133 | 3300 | 1996-06-14 | 0. | | 142 | 3100 | 1997-01-29 | 0. | | 131 | 2500 | 1997-02-16 | 0. | | 125 | 3200 | 1997-07-16 | 0. | | 129 | 3300 | 1997-08-20 | 0. | | 138 | 3200 | 1997-10-26 | 0. | | 130 | 2800 | 1997-10-30 | 0. | | 139 | 2700 | 1998-02-12 | 0. | | 143 | 2600 | 1998-03-15 | 0. | | 140 | 2500 | 1998-04-06 | 0. | | 144 | 2500 | 1998-07-09 | 0. | | 134 | 2900 | 1998-08-26 | 0. | | 126 | 2700 | 1998-09-28 | 0. | | 127 | 2400 | 1999-01-14 | 0. | | 132 | 2100 | 1999-04-10 | 0. | | 135 | 2400 | 1999-12-12 | 0. | | 136 | 2200 | 2000-02-06 | 0. | | 128 | 2200 | 2000-03-08 | 0. | +-+++-+ Why all the compute column values are 0?What is the correct sql? thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
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 able to give you more accurate advice than people here? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
Thanks dear. i thought u could be of some use in Oracle aswelll - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 1:59 PM Subject: Re: Oracle query.. 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 able to give you more accurate advice than people here? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 so that I could see all the tables. For eample..when I have an SQl file(*.sdl) I used to import it in dos mode like Mysql4.1 binmysql .. .sql -p -u root; Thank you very much. Regards, Renish There are probably migration tools available to move your data. Check on the MySQL website. If there are tools, I would recommend using them. If you want to do it yourself, you need to export your data from Oracle before importing it into MySQL. Dump each table to a comma-delimited file, and use 'load data infile' to import it into MySQL. Read up on 'load data infile' to find the exact format and commands to use. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 matter. Cheers, Renish Koshy - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 11:50 AM Subject: 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 so that I could see all the tables. For eample..when I have an SQl file(*.sdl) I used to import it in dos mode like Mysql4.1 binmysql .. .sql -p -u root; Thank you very much. Regards, Renish There are probably migration tools available to move your data. Check on the MySQL website. If there are tools, I would recommend using them. If you want to do it yourself, you need to export your data from Oracle before importing it into MySQL. Dump each table to a comma-delimited file, and use 'load data infile' to import it into MySQL. Read up on 'load data infile' to find the exact format and commands to use. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 time in this matter. Ah. Well you're asking the wrong list then. But the general idea is the same. First I would look for a migration tool. Failing that, I would export each table to csv files, create the destination tables in Oracle, and then import from the csv files. But again, migration tools are going to be the best bet, as they will set up your table definitions. There is a *remote* chance that Oracle will be able to import from a 'mysqldump' backup. You can also check that out, but I doubt it will work somehow. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]; mysql@lists.mysql.com 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.. Please tell me in step by step what i should do? as I am new to this field. I appreciate ur time in this matter. Ah. Well you're asking the wrong list then. But the general idea is the same. First I would look for a migration tool. Failing that, I would export each table to csv files, create the destination tables in Oracle, and then import from the csv files. But again, migration tools are going to be the best bet, as they will set up your table definitions. There is a *remote* chance that Oracle will be able to import from a 'mysqldump' backup. You can also check that out, but I doubt it will work somehow. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.. 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
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't The oracle-supplied DBMS_METADATA package can do this for you. -Jason Martin -- Silence is more eloquent at times than words. This message is PGP/MIME signed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
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 something intelligable (to mysql) but it would be a fair amount of work. On 10/25/05, Cummings, Shawn (GNAPs) [EMAIL PROTECTED] wrote: I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name Null? Type - CCS_UNITID NOT NULL CHAR(7) DIS_POSI_TION NOT NULL CHAR(3) OPC CHAR(11) CIRCUIT_ID_CODE NUMBER etc.. etc.. etc.. Does mysql have a way to import these Oracle dumps easily?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
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 you use a trigger. So I think you're stuck on the Oracle DDL - MySQL DDL. Ask your Oracle DBA to give you a sample of the data, too (is it just a comma-separated, enclosed-by-something file? It's not likely going to be a series of INSERT statements, like mysqldump gives), AND the full code of all the triggers. -Sheeri On 10/25/05, Sid Lane [EMAIL PROTECTED] wrote: 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 something intelligable (to mysql) but it would be a fair amount of work. On 10/25/05, Cummings, Shawn (GNAPs) [EMAIL PROTECTED] wrote: I have some data that has been dumped from Oracle into what appears to be a proprietary text file... It is not delimited into a format that I can just import into mysql (easily). The IT guy has provided me an outline of the dump.. ie; SQL describe isup051024; Name Null? Type - CCS_UNITID NOT NULL CHAR(7) DIS_POSI_TION NOT NULL CHAR(3) OPC CHAR(11) CIRCUIT_ID_CODE NUMBER etc.. etc.. etc.. Does mysql have a way to import these Oracle dumps easily?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DMP to mySQL -- Possible???
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 more eloquent at times than words. This message is PGP/MIME signed. pgpLVYHOkxNxK.pgp Description: PGP signature
Re: Oracle buys InnoDb! Arghhh!
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 develops. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?
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 our Schema Migration tool in Database Workbench a try. Download a copy here: www.upscene.com With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?
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-toolkit/ One of the ways I like to use it is to reverse engineer the Oracle schema, and then have the MySQL schema definition script created for further modification. Note we do not have support for sequences, and its typical to just use AUTO_INCREMENT columns for these. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?
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: Nguyen, Phong [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 26, 2005 7:55 AM To: mysql@lists.mysql.com Subject: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..? 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? Appreciated your help, Thank you, Phong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query to mysql
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_N , ROUND(SUM(IMRTAB1.IMRDSC),2) AS DUR_N , ROUND(SUM(IMRTAB1.IMRDSC)/SUM(IMRTAB1.IMRCLL),2) AS PRO_N , SUM(IMRTAB2.IMRCLL) AS CLL_R , ROUND(SUM(IMRTAB2.IMRDSC),2) AS DUR_R , ROUND(SUM(IMRTAB2.IMRDSC)/SUM(IMRTAB2.IMRCLL),2) AS PRO_R FROM IMRTAB , IMRTAB IMRTAB1 , IMRTAB IMRTAB2 /* here does the tables alias*/ WHERE IMRTAB.IMRIDE = IMRTAB1.IMRIDE (+) AND IMRTAB.IMRIDE = IMRTAB2.IMRIDE (+) /* links by the uniqID both alias */ AND (IMRTAB1.IMRTAR (+) = 'N') /* takes N calls and discard the rest for IMRTAB1 */ AND (IMRTAB2.IMRTAR (+) = 'R') /* takes R calls and discard the rest for IMRTAB2 */ AND (IMRTAB.IMRFLL BETWEEN '01/09/2004' and '10/09/2004') AND (IMRTAB.IMRCLI=2584 AND (IMRTAB.IMR906=803xx )) GROUP BY IMRTAB.IMR906,IMRTAB.IMRFLL ORDER BY IMRTAB.IMR906,IMRTAB.IMRFLL My MySQL translation: 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_N , ROUND(SUM(IMRTAB1.IMRDSC),2) AS DUR_N , ROUND(SUM(IMRTAB1.IMRDSC)/SUM(IMRTAB1.IMRCLL),2) AS PRO_N , SUM(IMRTAB2.IMRCLL) AS CLL_R , ROUND(SUM(IMRTAB2.IMRDSC),2) AS DUR_R , ROUND(SUM(IMRTAB2.IMRDSC)/SUM(IMRTAB2.IMRCLL),2) AS PRO_R FROM IMRTAB LEFT JOIN IMRTAB IMRTAB1 ON IMRTAB.IMRIDE = IMRTAB1.IMRIDE AND IMRTAB1.IMRTAR = 'N' /* N calls only for IMRTAB1 */ LEFT JOIN IMRTAB IMRTAB2 ON IMRTAB.IMRIDE = IMRTAB2.IMRIDE AND IMRTAB2.IMRTAR = 'R' /* R calls only for IMRTAB2 */ WHERE IMRTAB.IMRFLL BETWEEN '2004-09-01' and '2004-09-10' AND IMRTAB.IMRCLI=2584 AND IMRTAB.IMR906=803xx GROUP BY IMRTAB.IMR906,IMRTAB.IMRFLL ORDER BY IMRTAB.IMR906,IMRTAB.IMRFLL You were using the Oracle syntax , ...(+) to declare your outer joins. The equivalent MySQL form is LEFT JOIN... ON http://dev.mysql.com/doc/mysql/en/JOIN.html I also had to reformat the dates in your WHERE clause to be MySQL formatted: '01/09/2004' (dd/mm/) = '2004-09-01' (-mm-dd) http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html http://dev.mysql.com/doc/mysql/en/DATETIME.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine martin fasani [EMAIL PROTECTED] wrote on 09/28/2004 07:23:38 AM: Hi guys, I'm working in a telecom company that has Oracle for the call statistics. Now we export the daily stats to a remote mySql. The daily resume table looks like this: ++---+-++--+ --+++ | IMRFLL | IMR906| IMRTER | IMRTAR | IMRDUR | IMRFAC | IMRCLI | IMRCLL | ++---+-++--+ --+++ | 2004-06-01 | 803xx | x | N | 446.9166572 | 40355904 | 21 | 26 | | 2004-06-01 | 803xx | 0 | R | 9.414 | 40355904 | 21 | 10 | ++---+-++--+ --+++ What I need it's to get a report that joins the table to itself two times to get the Normal tarif ( IMRTAR=N) and the Reduced tarif (IMRTAR=R). In Oracle is done using Outer joins like this: 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_N,ROUND(SUM(IMRTAB1.IMRDSC),2) AS DUR_N,ROUND(SUM(IMRTAB1.IMRDSC)/SUM(IMRTAB1.IMRCLL),2) AS PRO_N, SUM(IMRTAB2.IMRCLL) AS CLL_R,ROUND(SUM(IMRTAB2.IMRDSC),2) AS DUR_R,ROUND(SUM(IMRTAB2.IMRDSC)/SUM(IMRTAB2.IMRCLL),2) AS PRO_R FROM IMRTAB, IMRTAB IMRTAB1, IMRTAB IMRTAB2 /* here does the tables alias */ WHERE IMRTAB.IMRIDE = IMRTAB1.IMRIDE (+) AND IMRTAB.IMRIDE = IMRTAB2.IMRIDE (+) /* links by the uniqID both alias */ AND (IMRTAB1.IMRTAR (+) = 'N') /* takes N calls and discard the rest for IMRTAB1 */ AND (IMRTAB2.IMRTAR (+) = 'R') /* takes R calls and discard the rest for IMRTAB2 */ AND (IMRTAB.IMRFLL BETWEEN '01/09/2004' and '10/09/2004') AND (IMRTAB.IMRCLI =2584 AND (IMRTAB.IMR906=803xx )) GROUP BY IMRTAB.IMR906,IMRTAB.IMRFLL ORDER BY IMRTAB.IMR906,IMRTAB.IMRFLL And this query returns something like this: +---++++++ | NUM906| FLL| CLL| DUR| DUR_N | CLL_N | DUR_R | CLL_R
Re: Oracle 2 MySQL updates/replication?
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 could call a Perl, C++ or Java program from cron to periodically update the MySQL instance from Oracle but was hoping to use a trigger/stored procedure to initiate the update so it seems more real time. Does this seem possible? Of course it may turn out non-trivial to write the synchronization code so I'll take suggestions on that front also. Golden Gate Software makes a product that does this. I'd have a look at what they offer. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle 2 MySQL updates/replication?
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 used to read 8i redo logs as well, so you might want to use the newer 9i client if you go this way. Updates to the oracle database could be processed the same way using the mysql binary log as long as no mysql extensions were used like inserting multiple rows with a single insert statement. --- Jeremy Zawodny [EMAIL PROTECTED] wrote: 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 could call a Perl, C++ or Java program from cron to periodically update the MySQL instance from Oracle but was hoping to use a trigger/stored procedure to initiate the update so it seems more real time. Does this seem possible? Of course it may turn out non-trivial to write the synchronization code so I'll take suggestions on that front also. Golden Gate Software makes a product that does this. I'd have a look at what they offer. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle Listener Like Functionality
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 listener down. The listener in Oracle just allows clients to connect if it is up. With the listener down no external clients can connect to the DB. Is there similar functionality in MySQL? Start it up with --skip-networking, and do your maintenance via the Unix socket. Another option is to use your OSes firewall software to block port 3306 (this method doesn't require you to bounce mysql to en/disable the port). -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ORACLE to MySQL migration
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 like Delphi, or like the EMS DataPump tool. Have fun! :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 9: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 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 commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORACLE to MySQL migration
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 commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ORACLE to MySQL migration
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 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 commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: oracle to mysql
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 to migrate Oracle databases and schema to MySQL 5.0? I know one such tool, Oracle-to-mysql which is not free though. Thanks Raza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle Question
-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 the ODBC trace is less than useful Ken Oh wow... I can't think of how you'd get that to work without a ton of custom. For starters, you'll have to write your own transactional triggers and intercept every one of Oracle's select, lock, update, insert, delete, like On-Lock, On-Insert, etc. since Forms will want things like rowids. You'll also have to write your own on-Login. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle nvl function equivalent.
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]
Re: Oracle nvl function equivalent.
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 is called IFNULL(). ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle date
The kind of processing you desired is easily accomplisches
with the following perl program:
#!/usr/bin/perl
while (STDIN) {
if (/TO_DATE/) {
s/TO_DATE/STR_TO_DATE/;
s/(..)\/(..)\/()/$1-$2-$3/;
s/MM\/dd\//%m-%d-%Y/;
}
print $_;
}
[EMAIL PROTECTED] cat Landon.odat
insert into log_book values
(TO_DATE('08/12/1973','MM/dd/'),'C150','N5787G',1,1.8);
[EMAIL PROTECTED] ./Landon.pl Landon.odat
insert into log_book values
(STR_TO_DATE('08-12-1973','%m-%d-%Y'),'C150','N5787G',1,1.8);
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
At 17:24 -0700 8/20/03, Michael S. Fischer wrote: 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 preallocate space for 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 Oracle followup question Oracle supports Tablespaces That is 2 or more logically separate entities for System Data and User Data Does MySQL have Tablespace support? Many Thanks, Martin - Original Message - From: Adam Nelson [EMAIL PROTECTED] To: 'Johnson, 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 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 devoted to the initial setup of the program on each major OS. It's such a simple thing, but often there are very competent individuals who just want to read the best practices setup in concise form. Then, when more time is available, go back and tweak, etc.. -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 6:43 PM To: MySQL Users Subject: Oracle DBA here looking for advice on MySQL 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DBA here looking for advice on MySQL ....
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 preallocate space for its tables like Oracle does. That's for MyISAM tables. InnoDB tables do use a tablespace, but it's one big file for everything, indexes and tables. You can't create multiple tablespaces and assign individual tables/indexes/users to different tablespaces. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DBA here looking for advice on MySQL ....
That's not entirely correct. InnoDB currently supports a single tablespace (comprised of multiple datafiles). Heikki Tuuri (the developer and maintainer of InnoDB) also mentioned that multiple-tablespace support might be in InnoDB this fall (September 2003 according to the TODO list at InnoDB: http://www.innodb.com/todo.html). As an Oracle DBA (I'm one myself), InnoDB will give you close to Oracle features. As an FYI, we also spent alot of time looking @ Postres and SAPDB. Postgres is a great database engine, and would be very adequate if it didn't have one significant missing feature - there is no replication or standby support unless you buy an expensive licence (which brings the cost close to that of Oracle); we need the high-availability of clusters and replication. Both Postgres and MySQL have great support via their mailing lists, but once in a while, the people on the Postgres mailing list decide to kick MySQL around a bit; I think they have an inferiority complex. SAPDB is a mess right now and the documentation is atrocious; hopefully the MySQL developers can clean it up. It also doesn't have replication (though it has utilities and features that imply replication via their name; the latest version renamed them, with a comment that it wasn't really replication). MySQL, with InnoDB and replication, is better than either for what we need. David. - Original Message - From: Michael S. Fischer [EMAIL PROTECTED] 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 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 preallocate space for its tables like Oracle 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 Oracle followup question Oracle supports Tablespaces That is 2 or more logically separate entities for System Data and User Data Does MySQL have Tablespace support? Many Thanks, Martin - Original Message - From: Adam Nelson [EMAIL PROTECTED] To: 'Johnson, 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 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 devoted to the initial setup of the program on each major OS. It's such a simple thing, but often there are very competent individuals who just want to read the best practices setup in concise form. Then, when more time is available, go back and tweak, etc.. -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 6:43 PM To: MySQL Users Subject: Oracle DBA here looking for advice on MySQL 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DBA here looking for advice on MySQL ....
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 datafile, the other is the index file. MySQL also does not preallocate space for its tables like Oracle does. That's for MyISAM tables. InnoDB tables do use a tablespace, but it's one big file for everything, indexes and tables. You can't create multiple tablespaces and assign individual tables/indexes/users to different tablespaces. Not yet. But that's supposed to be under development now. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 959,687,607 queries (567/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
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 devoted to the initial setup of the program on each major OS. It's such a simple thing, but often there are very competent individuals who just want to read the best practices setup in concise form. Then, when more time is available, go back and tweak, etc.. -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 6:43 PM To: MySQL Users Subject: Oracle DBA here looking for advice on MySQL 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DBA here looking for advice on MySQL ....
As a Oracle followup question Oracle supports Tablespaces That is 2 or more logically separate entities for System Data and User Data Does MySQL have Tablespace support? Many Thanks, Martin - Original Message - From: Adam Nelson [EMAIL PROTECTED] To: 'Johnson, 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 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 devoted to the initial setup of the program on each major OS. It's such a simple thing, but often there are very competent individuals who just want to read the best practices setup in concise form. Then, when more time is available, go back and tweak, etc.. -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 6:43 PM To: MySQL Users Subject: Oracle DBA here looking for advice on MySQL 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
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 preallocate space for its tables like Oracle 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 Oracle followup question Oracle supports Tablespaces That is 2 or more logically separate entities for System Data and User Data Does MySQL have Tablespace support? Many Thanks, Martin - Original Message - From: Adam Nelson [EMAIL PROTECTED] To: 'Johnson, 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 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 devoted to the initial setup of the program on each major OS. It's such a simple thing, but often there are very competent individuals who just want to read the best practices setup in concise form. Then, when more time is available, go back and tweak, etc.. -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2003 6:43 PM To: MySQL Users Subject: Oracle DBA here looking for advice on MySQL 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle DBA here looking for advice on MySQL ....
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 it. Unlike Oracle the richness and integrity of language is simply missing - these people have lived without something as useful as sub-queries for a long time. (The argument being that speed and data integrity are all-important). It's more a file system than a relational database. I know you asked about books rather than a comparison of the products, but the software philosophy is reflected in the documentation. If someone else pays you to be an Oracle Dba then I bet you have at least a 10 foot shelf of comprehensive documentation. This list is about as good as it gets (see your previous response). There is a PDF copy of the manual somewhere and setting up MySql was accompilshed by a colleague who wouldn't have known where to start with Oracle, so it has that in its favour. So, if you're thinking of migrating, think carefully! If I could get Oracle to give me a sensible price (say USD 1000) to sell their db with my product I would be out of here so fast. So far with mySQL i've written my own database for a particular (simple) structure that it wouldn't handle to my satisfaction; I've written my own date/time routines to calculate things like seconds between 2 datetimes (despite a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Oracle DBA's is how the whole database starts up and how all those processes work together and where to find bottlenecks when things start to bog down.It 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 advice on MySQL 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 it. Unlike Oracle the richness and integrity of language is simply missing - these people have lived without something as useful as sub-queries for a long time. (The argument being that speed and data integrity are all-important). It's more a file system than a relational database. I know you asked about books rather than a comparison of the products, but the software philosophy is reflected in the documentation. If someone else pays you to be an Oracle Dba then I bet you have at least a 10 foot shelf of comprehensive documentation. This list is about as good as it gets (see your previous response). There is a PDF copy of the manual somewhere and setting up MySql was accompilshed by a colleague who wouldn't have known where to start with Oracle, so it has that in its favour. So, if you're thinking of migrating, think carefully! If I could get Oracle to give me a sensible price (say USD 1000) to sell their db with my product I would be out of here so fast. So far with mySQL i've written my own database for a particular (simple) structure that it wouldn't handle to my satisfaction; I've written my own date/time routines to calculate things like seconds between 2 datetimes (despite a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
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 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 Oracle DBA's is how the whole database starts up and how all those processes work together and where to find bottlenecks when things start to bog down.It didnt see any of that in the MySQL docs I read. I appears that MySQL has some potential though. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
Michael, The reason you think there's not much to this database is that compared to Oracle, there really is not much to this database. :-) From a 50,000-foot point of view, it's really just a nice SQL interface to ISAM files (it started out that way, anyway). It is designed for high-performance in read-intensive environments, and so it doesn't really need to be that complicated. MySQL is a single-process, multithreaded server. That means you start mysqld through the wrapper script and that's all that runs. It doesn't have separate specialized daemons for doing various tasks like Oracle and PostgreSQL do. All data is stored in MyISAM files (assuming you're not using InnoDB or BDB), two per table (one data, one index file), and tables are stored in directories corresponding to the database name in the configured data directory. Some basic knowledge of system performance tuning for your given OS and reading the manual, particularly Chapter 5 (MySQL Optimization) should put you well ahead of the pack. Best, --Michael -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 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 Oracle DBA's is how the whole database starts up and how all those processes work together and where to find bottlenecks when things start to bog down. It 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 advice on MySQL 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 it. Unlike Oracle the richness and integrity of language is simply missing - these people have lived without something as useful as sub-queries for a long time. (The argument being that speed and data integrity are all-important). It's more a file system than a relational database. I know you asked about books rather than a comparison of the products, but the software philosophy is reflected in the documentation. If someone else pays you to be an Oracle Dba then I bet you have at least a 10 foot shelf of comprehensive documentation. This list is about as good as it gets (see your previous response). There is a PDF copy of the manual somewhere and setting up MySql was accompilshed by a colleague who wouldn't have known where to start with Oracle, so it has that in its favour. So, if you're thinking of migrating, think carefully! If I could get Oracle to give me a sensible price (say USD 1000) to sell their db with my product I would be out of here so fast. So far with mySQL i've written my own database for a particular (simple) structure that it wouldn't handle to my satisfaction; I've written my own date/time routines to calculate things like seconds between 2 datetimes (despite a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Oracle DBA here looking for advice on MySQL ....
Just look at amazon. There are more books popping up all the time. The manual with user comments is the best. http://www.mysql.com/doc/en/ Paul DuBois wrote a good book that helped me get started on a few things. This one is a newer one I think. http://www.amazon.com/exec/obidos/tg/detail/-/0735709211/ref=pd_sim_books_1/ 103-1999417-1493463?v=glances=books or for 4.0 by Ian Gilfillan http://www.amazon.com/exec/obidos/tg/detail/-/0782141625/ref=pd_sbs_b_1/103- 1999417-1493463?v=glances=books opinion per 1st reply I've noticed a lot of Oracle people don't like MySQL for one reason or another. I don't understand why that is, but in my opion MySQL is easier, faster and more fun to use. Granted there are not as many features available in MySQL, but having the ability to create my own solutions to problems is what I enjoy most about it. That's the reason I became a programmer, not an app user. /opinion per 1st reply 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'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 it. Unlike Oracle the richness and integrity of language is simply missing - these people have lived without something as useful as sub-queries for a long time. (The argument being that speed and data integrity are all-important). It's more a file system than a relational database. I know you asked about books rather than a comparison of the products, but the software philosophy is reflected in the documentation. If someone else pays you to be an Oracle Dba then I bet you have at least a 10 foot shelf of comprehensive documentation. This list is about as good as it gets (see your previous response). There is a PDF copy of the manual somewhere and setting up MySql was accompilshed by a colleague who wouldn't have known where to start with Oracle, so it has that in its favour. So, if you're thinking of migrating, think carefully! If I could get Oracle to give me a sensible price (say USD 1000) to sell their db with my product I would be out of here so fast. So far with mySQL i've written my own database for a particular (simple) structure that it wouldn't handle to my satisfaction; I've written my own date/time routines to calculate things like seconds between 2 datetimes (despite a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: 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. ? I am not looking for a SQL book here. What is the best My SQL book you have read ? Thank you in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. __ 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: Oracle to MySQL or ?
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.) 1. The primary question/issue here is that with the complexity of our databases, Oracle's Intermedia was/is very necessary. IBM evidently offers a similar feature in its db2, which is a frontrunner for our database/RnD people here. Intermedia. Hmm. I guess I could look it up. http://www.google.com/search?hl=enie=ISO-8859-1q=oracle+intermedia http://www.oracle.com/ip/deploy/database/oracle9i/index.html?cm_imedia.html Okay, it looks like a set of tools for managing multimedia databases. Could you explain how you use intermedia? ... -- Joel Rees [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: oracle.
'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 mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - 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: oracle.
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 fields mught be owner or something then you can do select * from user_tables where owner='SCOTT'; Now, I am not 100% sure on htat command but you need to key on somethin gin the user_tables :-) ---Original Message--- From: Anil Garg [EMAIL PROTECTED] Sent: 03/17/03 09:34 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: a target=_blank href=http://www.mysql.com/manual.php;http://www.mysql.com/manual.php/a (the manual) a target=_blank href=http://lists.mysql.com/;http://lists.mysql.com//a (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: a target=_blank href=http://lists.mysql.com/php/unsubscribe.php;http://lists.mysql.com/php /unsubscribe.php/a - 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: oracle.
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 WHERE owner = 'YOUR NAME' If you want to see all the tables in the database use dba_tables but you'll need to be granted access to it. Dave From: Anil Garg [EMAIL PROTECTED] Date: 2003/03/17 Mon PM 12:34:32 EST To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - 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: Oracle to Mysql
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 stored procedures and triggers available in MySQL. 3. You will need to use the Innodb or equivalent extensions to get transaction processing. 4. The table and index creation syntax is different with MySQL. (Personally I found MySQL somewhat more logical). If you want to discuss the issues in more detail please e-mail me directly. Regards Peter Goggin - Original Message - From: RP C987342 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 4:29 PM Subject: Oracle to Mysql hello I want to move my database from Oracle to MySql, I am new to MySql. Is there any documentation listing the important issues involved in the migration? thanks, _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: Oracle .dmp to mySQL
Hi Mike, I am not sure, but as I remember Microsoft SQLServer has Import/Export utility (standard installation) that can import data from different sources (Oracle?! why not). Best regards, Mikhail. - Original Message - From: Mike Townend [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 3:09 PM Subject: Oracle .dmp to mySQL Hi all, We have just recently inherited a web project from another company who's DB was Oracle 8. And as such they have provided us with an exported .dmp file of the database they were using... We are using mySQL as our DB backend... Does anyone know of any tools that will allow me to import this file into mySQL (or maybe SQL Server which we can then import to mySQL) MTIA Mike - 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: Oracle .dmp to mySQL
I think it will be very difficult to do. In Oracle export files the data is written in Oracle's own proprietary binary format. I don't know of any tools other than Oracle's own import utility that is able to read the .dmp file. You may need to get them to send you a .csv file instead. --Walt Weaver Bozeman, Montana -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 7:10 AM To: [EMAIL PROTECTED] Subject: Oracle .dmp to mySQL Hi all, We have just recently inherited a web project from another company who's DB was Oracle 8. And as such they have provided us with an exported .dmp file of the database they were using... We are using mySQL as our DB backend... Does anyone know of any tools that will allow me to import this file into mySQL (or maybe SQL Server which we can then import to mySQL) MTIA Mike - 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: Oracle .dmp to mySQL
We don't have access to the Oracle server :( So as to a project handover to the client they just gave them the dmp file... Im currently downloading Oracle from the Oracle site but it's a major download :( Ive found a util that attempts to get the information from the dmp files but this is failing :( so was just putting a feeler out to see if anyone else had done this... So far I can recreate the table structure but cant extract the actual data from the file. TIA Mike -Original Message- From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 14:17 To: Mike Townend; [EMAIL PROTECTED] Subject: Re: Oracle .dmp to mySQL Hi Mike, I am not sure, but as I remember Microsoft SQLServer has Import/Export utility (standard installation) that can import data from different sources (Oracle?! why not). Best regards, Mikhail. - Original Message - From: Mike Townend [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 3:09 PM Subject: Oracle .dmp to mySQL Hi all, We have just recently inherited a web project from another company who's DB was Oracle 8. And as such they have provided us with an exported .dmp file of the database they were using... We are using mySQL as our DB backend... Does anyone know of any tools that will allow me to import this file into mySQL (or maybe SQL Server which we can then import to mySQL) MTIA Mike - 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: 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 saves you some time and hassle. It worked for me going from SQL Server 6.5 to MySQL 3.23. Hope this helps, Tim - Original Message - 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 AM Subject: RE: Oracle .dmp to mySQL We don't have access to the Oracle server :( So as to a project handover to the client they just gave them the dmp file... Im currently downloading Oracle from the Oracle site but it's a major download :( Ive found a util that attempts to get the information from the dmp files but this is failing :( so was just putting a feeler out to see if anyone else had done this... So far I can recreate the table structure but cant extract the actual data from the file. TIA Mike -Original Message- From: Mikhail Entaltsev [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 14:17 To: Mike Townend; [EMAIL PROTECTED] Subject: Re: Oracle .dmp to mySQL Hi Mike, I am not sure, but as I remember Microsoft SQLServer has Import/Export utility (standard installation) that can import data from different sources (Oracle?! why not). Best regards, Mikhail. - Original Message - From: Mike Townend [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 12, 2002 3:09 PM Subject: Oracle .dmp to mySQL Hi all, We have just recently inherited a web project from another company who's DB was Oracle 8. And as such they have provided us with an exported .dmp file of the database they were using... We are using mySQL as our DB backend... Does anyone know of any tools that will allow me to import this file into mySQL (or maybe SQL Server which we can then import to mySQL) MTIA Mike - 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 - 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
