l Harald"
> To: "MySql"
> Sent: Tuesday, 13 September, 2016 13:39:59
> Subject: Re: MySQL Platform Migration
> Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
>> - Original Message -
>>> From: "Ryan Coleman"
>>> Subject: Re:
sman:
- Original Message -----
From: "Ryan Coleman"
Subject: Re: MySQL Platform Migration
Because they want to be belittled by european jackasses online.
The thing is, while he has a bit of a rough edge, his technical advice is
always solid. What has your contribution been, ou
>
>> Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
>> - Original Message -
>>> From: "Ryan Coleman"
>>> Subject: Re: MySQL Platform Migration
>>>
>>> Because they want to be belittled by european jackasses online.
>&g
Am 13.09.2016 um 12:13 schrieb Johan De Meersman:
- Original Message -
From: "Ryan Coleman"
Subject: Re: MySQL Platform Migration
Because they want to be belittled by european jackasses online.
The thing is, while he has a bit of a rough edge, his technical advice is
al
- Original Message -
> From: "Reindl Harald"
> Subject: Re: MySQL Platform Migration
>
> we discussed this multiple times here
True; but new people on the list may not have seen that.
> when you *copy* the datadir on the target machine nobody eats your data
- Original Message -
> From: "Matthias Schmidt"
> Subject: Re: MySQL Platform Migration
>
> I had to make certain adjustements to the config file thou.
Interesting - what changes did you have to make? I would expect most things to
just keep working as they are,
Am 13.09.2016 um 12:09 schrieb Johan De Meersman:
- Original Message -
From: "Reindl Harald"
Subject: Re: MySQL Platform Migration
why shouldn't it when the identical software is running?
it's just a bunch of files used by mysql
Little/big endianness, for one
- Original Message -
> From: "Ryan Coleman"
> Subject: Re: MySQL Platform Migration
>
> Because they want to be belittled by european jackasses online.
The thing is, while he has a bit of a rough edge, his technical advice is
always solid. What has your contrib
- Original Message -
> From: "Reindl Harald"
> Subject: Re: MySQL Platform Migration
>
> why shouldn't it when the identical software is running?
> it's just a bunch of files used by mysql
Little/big endianness, for one, although I seem to recall,
Hello,
I’m quite new to this list and I’m surprised about the vocabulary used on this
list by certain people, who besides that do not add any productive idea to the
problem asked by the OT.
Besides that I upgraded just from MacOS10.6 -> 10.11 and copying just the data
folder did the job.
As I
Am 12.09.2016 um 15:06 schrieb Ryan Coleman:
Dear sir,
You do not realize that there aren’t always sys admins on these lists
how does that change the fact that it just works and it did work from
day one as described long before i became a sysadmin and that it now
works over 15 years from m
Dear sir,
You do not realize that there aren’t always sys admins on these lists. Your
proven track record of asshole first, kid gloves later drives people away.
Your fight to change mailing lists is one which only you seem to share.
Goodnight.
> On Sep 12, 2016, at 7:27 AM, Reindl Harald wro
first: get rid of "reply-all"o n mailing-lists, you break others
"reply-list" button with the second copy which arrives usually faster
the the list one
Am 12.09.2016 um 13:35 schrieb Harrie Robins:
It is bad practice to do so in my eyes (and yes that is an *opinion*).
When you advice people, i
Hi,
.
It is bad practice to do so in my eyes (and yes that is an *opinion*). When
you advice people, instruct them to take the proven route, as described in
the mysql documentation.
Second, mastering mysqldump should be golden standard for any DBA. Telling
someone that asks for guidance to simply c
Am 12.09.2016 um 10:48 schrieb Harrie Robins:
Ok let's drop this. Simply copying files to migrate a server is not the
approach to take (in my humble opinion)
And why?
When you start with "Get the same release-version of mysql running on
the target platform" and dump/load what's the point in
Ok let's drop this. Simply copying files to migrate a server is not the
approach to take (in my humble opinion).
First asses the situation, a platform migration? Get the same
release-version of mysql running on the target platform. Dump your mysql
database the with the excellent tool mysq
Am 11.09.2016 um 20:27 schrieb Ryan Coleman:
Because they want to be belittled by european jackasses online.
if you insist in not get any mail from me just shut up when nobody asked
you - mind your own business
On Sep 10, 2016, at 11:56 PM, Reindl Harald wrote:
Am 11.09.2016 um 06:36
al Message -
>>> From: Reindl Harald
>>> To: mysql@lists.mysql.com
>>> Sent: Saturday, September 10, 2016 7:19 PM
>>> Subject: Re: MySQL Platform Migration
>>>
>>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
>>>> Is ther
gt; questions?
>
>> - Original Message -
>> From: Reindl Harald
>> To: mysql@lists.mysql.com
>> Sent: Saturday, September 10, 2016 7:19 PM
>> Subject: Re: MySQL Platform Migration
>>
>> Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
>&g
ne and you are done - why do people
these days not just try out things, look if it works and when it don't
asking questions?
- Original Message -
From: Reindl Harald
To: mysql@lists.mysql.com
Sent: Saturday, September 10, 2016 7:19 PM
Subject: Re: MySQL Platform Migration
Am 11.0
-
From: Reindl Harald
To: mysql@lists.mysql.com
Sent: Saturday, September 10, 2016 7:19 PM
Subject: Re: MySQL Platform Migration
Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
> Is there any documentation for migrating mysql 5.0 database from darwin to
> Linux
what do you
Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal:
Is there any documentation for migrating mysql 5.0 database from darwin to Linux
what do you need to migrate?
shutdown mysqld, copy the datadir to the new machine, stat mysqld with
adopted configuration ion the new machine - done
P.S:
don't
Hi,
Is there any documentation for migrating mysql 5.0 database from darwin to
Linux.
Thanks
Suresh Rajagopal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Workbench provides some migration features and supports SQL Server
http://www.mysql.com/products/workbench/migrate/
On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho
wrote:
> Hello,
>
> I'm a web developer and I'm developing a web application on Rails. I'm
> gonna u
te the data from SQL Server
to MySQL.
The databases are very similar:
- Few columns change the name.
- One table was split in two
- Few columns added
- Few columns changed the type.
Do you suggest any tool the helps with this migration?
Thank you,
Felipe.
--
Felipe Leal Coutinho
Website <
Hi,
Data migration made last night.
Use of a new MySQL instance has been quite useful to operate, the outage
was about 7 minutes.
ibdata1 is now using 58 MiB of disk space ! each table having a proper
.ibd file and full data directory from 13GiB to 3.2GiB ...
Server load divided by 3 ~ 4 ;).
I
Hi Shawn, and thanks for this concise anwser ;) .
Le 22/03/2014 05:35, shawn l.green a écrit :
>
> The system is operating exactly as designed. The ibdata* file(s) contain
> more than just your data and indexes. This is the common tablespace and
> it contains all the metadata necessary to identify
ime WHERE ..." seem to be reliable to do this.
*But*, in this one timed scheduled task in data migration (Previewed and
accepted by customer, by night / not tonight ... :) ), and *I'd like to
remove the ibdata1 file* , as it takes huge disk space.
Migration task also includes converting old tabl
is one timed scheduled task in data migration (Previewed and
accepted by customer, by night / not tonight ... :) ), and *I'd like to
remove the ibdata1 file* , as it takes huge disk space.
Migration task also includes converting old tables (previously in
InnoDB), to alter them into InnoDB
- Original Message -
> From: "Adam Lanier"
>
> What is the recommended course of action to keep data synchronized
> between the two platforms?
Not an easy one, I think :-)
For simple one-shot copies the MySQL Connector for ODBC should do fine. I'm not
sure if you can set up a continuou
I'm involved with a project that is migrating data from sql server to
mysql. The project will take up to a year to complete. During that
period of time, we will need to synchronize data from sql server to
mysql as we migrate windows based functionality to linux based servers.
What is the rec
I need to migrate about a dozen tables from ORACLE 10g to MySQL 5. I
have manually migrated the schema to MySQL. I am able to write SQL*PLUS
queries to extract ORACLE data into insert statements (including date
conversions to MySQL format etc) that I can run against the MySQL
database. The CLOB fie
Hi Kranthi!
Kranthi schrieb:
> Hi ,
>
> I am migrating the database from mssql server to Mysql.i am getting
> problem with newid(),I don't know about newid(),i am using mysql migration
> tool kit.
>
> if anybody knows please help me.
>
> Ex:
>
; PRIMARY KEY (`EmployeeID`)
> )
> ENGINE = INNODB;
>
>
>
> Thanks & Regards,
> Kranthi
>
>
>
> -Original Message-
> From: Lenz Grimmer [mailto:l...@mysql.com]
> Sent: Friday, August 13, 2010 3:56 PM
> To: mysql@lists.mysql.com
> Subject:
EmployeeID`)
)
ENGINE = INNODB;
Thanks & Regards,
Kranthi
-Original Message-
From: Lenz Grimmer [mailto:l...@mysql.com]
Sent: Friday, August 13, 2010 3:56 PM
To: mysql@lists.mysql.com
Subject: Re: Reg: Migration
Hi,
On 08/13/10 09:34, Kranthi wrote:
> I am migra
Hi,
On 08/13/10 09:34, Kranthi wrote:
> I am migrating the database from mssql server to Mysql.i am getting
> problem with newid(),I don't know about newid(),i am using mysql migration
> tool kit.
>
> if anybody knows please help me.
Would using the UUID() MySQL f
Hi ,
I am migrating the database from mssql server to Mysql.i am getting
problem with newid(),I don't know about newid(),i am using mysql migration
tool kit.
if anybody knows please help me.
Ex:
CREATE TABLE cust
(
cust_id uniqueidentifier NOT NULL
DEFAULT newid(),
co
>
> Another suggestion would be :-
>
> Take a FULL "tar" of the MYSQL Data Directory and push it to the NEW server
> and "untar" and start mysql (take the master status of the probable Master
> Server, for replication and bringing the new server to sync with its
> Master). I think this should be on
Hello Goeff,
Data Import might take some time (considering 50 GB) if the majority of the
tables are of type "INNODB". If yes, 4 hours should not be enough. If its
"MYISAM", you can go ahead (Provided you choose data import to replication).
Another suggestion would be :-
Take a FULL "tar" of the
On Sun, Jul 25, 2010 at 12:55 PM, Geoff Galitz wrote:
>
> Hello.
>
> I need to migrate a master and slave to new hardware. The DB is approx 50G
> on disk and my time window for downtime is approximately 4 hours.
>
> My question is, is it advisable to do a mysqldump from the old master and
> the
Hello.
I need to migrate a master and slave to new hardware. The DB is approx 50G on
disk and my time window for downtime is approximately 4 hours.
My question is, is it advisable to do a mysqldump from the old master and then
load on the new master and slave, or is it faster to just set th
Options such as these are set in my.cnf/my.ini (depending on your host
operating system).
innodb_file_per_table is a very useful option but not neccessarily the
best choice for a novice trying to set up replication.
- michael dykman
On Tue, Jul 13, 2010 at 5:43 AM, lejeczek wrote:
> I'm a novi
I'm a novice myself and yes I must say on-line documentation is not easy
nor comprehensive,
let's take this page as an example:
http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html
if I don't use InnoDB Hot Backup, doc says..
"..Otherwise, you can obtain a reliable binary snaps
Hi all!
Götz Reinicke - IT-Koordinator wrote:
> Am 08.06.10 12:05, schrieb Rob Wultsch:
>> On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
>> wrote:
>>> Hi,
>>>
>>> we do have different LAMP systems and recently I started to put some
>>> mysql databases on one, new master server.
Am 08.06.10 12:05, schrieb Rob Wultsch:
> On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
> wrote:
>> Hi,
>>
>> we do have different LAMP systems and recently I started to put some
>> mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
>> 5.0.xx)
>
> MySQL 4.X
On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
wrote:
> Hi,
>
> we do have different LAMP systems and recently I started to put some
> mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
> 5.0.xx)
MySQL 4.X is EOL. I strongly suggest not using it for new proj
Hi,
we do have different LAMP systems and recently I started to put some
mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x -
5.0.xx)
I did this by exporting some databases with mysqldump and importing tham
on the new server.
Now I'd like to add a slave mysqlserver and so I s
If you have an auto increment column, order it by that value. That
field will have the order the records were imported in.
Brent Baisley
On Mar 6, 2009, at 9:10 PM, revDAVE wrote:
Hi folks,
I'm trying to use MySQL Migration Toolkit 1.1 with MS SQL server 2005
http://dev.mysql.com/dow
Hi folks,
I'm trying to use MySQL Migration Toolkit 1.1 with MS SQL server 2005
http://dev.mysql.com/downloads/gui-tools/5.0.html
- basically all is working great - some tables import no problem - except...
I'm trying to import an address table and in the summary it says that
the
-rw-rw-r-- 1 pons pons 18576475 Aug 20 09:00
mysql-gui-tools-5.0r12-rhel4-i386.tar.gz
-rw-r--r-- 1 root root 5247393 May 3 2007
mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm
-rw-r--r-- 1 root root 3133875 May 3 2007
mysql-query-browser-5.0r12-1rhel4.i386.rpm
On Wed, Aug 20, 2008 at 5:02
I did the following to resolve this issue
[EMAIL PROTECTED] download]# rpm -Uvh
mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm
error: Failed dependencies:
libjvm.so(SUNWprivate_1.1) is needed by
mysql-migration-toolkit-5.0r12-1rhel4.i386
[EMAIL PROTECTED] download]# rpm -ivh --nodeps
mysql
Am trying to install the following pack:
[EMAIL PROTECTED] download]# rpm -Uvh
mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm
error: Failed dependencies:
libjvm.so(SUNWprivate_1.1) is needed by
mysql-migration-toolkit-5.0r12-1rhel4.i386
[EMAIL PROTECTED] download]# java -version
java
Much
work still to be done. Congrats to the Open Source Community for
producing such portable software.
Regards Tom
-Original Message-
From: Joerg Bruehe [mailto:[EMAIL PROTECTED]
Sent: Fri 20-Jun-08 6:57 PM
To: Swigg, Tom C
Cc: mysql@lists.mysql.com
Subject: Re: Migration of mysql 3.23.32
.
I know that migrating to MySQL 5 and PHP 5 would need quite some
resources, but I also think that adapting those old sources for current
compilers might need a similar amount of resources.
I do not think your current approach will take less effort than the
migration to current versions
Le Tuesday 17 June 2008 vers 14:51, Swigg, Tom C("Swigg, Tom C"
<[EMAIL PROTECTED]>) a écrit:
Hello,
> I have been given the task of migrating some 200+ web sites fom
> Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1
> Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the
> develop
I have been given the task of migrating some 200+ web sites fom Tru64
UNIX to Red Hat Enterprise Linux 64 bit V5.1
Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the
developers have long gone...
The objective is to provide a 3.23.32 environment on RHEL 5.1 which
will run in paralle
learnt
On Wed, Apr 30, 2008 at 5:18 AM, Mihail Manolov <[EMAIL PROTECTED]>
wrote:
> Hi all,
>
> I feel obliged to report on my success with migration from 32bit to 64bit
> platform.
>
> Last Sunday I braced myself and migrated 3 servers (one master and two
> slaves) wi
You are right.
Mysql 4.0 don't have a concept charset.
2008/5/16 MarisRuskulis <[EMAIL PROTECTED]>:
> Found partial sollution! Need to specify mysql_query("SET NAMES
> 'latin1'"); for connection charset.
>
> MarisRuskulis wrote:
>
> Hello!
> I'm trying to migrate database from mysql 4.0 to 5.0 (
Found partial sollution! Need to specify mysql_query("SET NAMES
'latin1'"); for connection charset.
MarisRuskulis wrote:
> Hello!
> I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
> maked dump from 4.0 and then restored it to 5.0, but without success
> because inside the web sy
Hello!
I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I
maked dump from 4.0 and then restored it to 5.0, but without success
because inside the web symbols isnt correct. On mysql 5.0 database
charset is latin1 and "SHOW TABLE STATUS" shows that table is latin1.
When I maked dump
Hi all,
I feel obliged to report on my success with migration from 32bit to
64bit platform.
Last Sunday I braced myself and migrated 3 servers (one master and two
slaves) with approximately 100GB data each by simply rsyncing the data
files. It took about 1 hour total downtime
On 4/26/08 Mihail Manolov wrote:
Hi!
MyISAM (MERGE; and therefore not an issue). The only exception is
Falcon, which is only available in MySQL 6.0.
While I haven't had a chance to read the wiki link you posted, as I
write this email offline, it should be noted that Falcon previews even
(cu
Mike wrote:
Hi!
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
Dump the database, restore on the 64-bit box, and all should be well
What is the difference between
, 25 April, 2008 5:33:49 PM
> > Subject: Re: Migration from 32-bit to 64-bit MySQL
> >
> > On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy
> > wrote:
> >
> > > Olaf Stein wrote:
> > >
> > > > Probably not
> > > >
> > > &
Mike wrote:
I not sure
what you mean by binary copy. Can you please explain?
A binary copy means copying the MySQL data directory directly, rather
than do a mysqldump, which converts the data to text format. The text
dump is converted back to binary format for disk storage on loading it
b
I am in process of planning 32 to 64 migration as well. I googled the
following, but it could be only relevant to a specific application:
It should be noted that, when switching between 32bit and 64bit server
using
the same data-files, all the current major storage engines
(with one
On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy <[EMAIL PROTECTED]>
wrote:
> Olaf Stein wrote:
>
> > Probably not
> >
> > AFAIK it should work in theory if you have no floating point columns but
> > I
> > would not try it.
> > Why cant you take a dump, you can do it table by table, you will have
Mike wrote:
I have so much data that we can't take a mysqldump of our database. The
directory tared is about 18GB.
Worst-case expansion for SQL data from binary to text format is about
5:1, which applies mainly to numeric data, not text. That's only 90 GB;
I carry a bigger hard drive in my
Every statement should be executed on the slave from the masters binary log
so in my opinion you should be ok
On 4/25/08 12:20 PM, "Mike" <[EMAIL PROTECTED]> wrote:
> That what I want to do, but I'm not sure if the data will propagate right.
> Because of lack of documentation for 64bit.
>
> On
That what I want to do, but I'm not sure if the data will propagate right.
Because of lack of documentation for 64bit.
On Fri, Apr 25, 2008 at 12:03 PM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> Probably not
>
> AFAIK it should work in theory if you have no floating point columns but I
> would no
Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add more 64 slaves.
On
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> As long as you use dumps to restore your databases on the new 64bit system
> (instead of the binary files) you should be fine
>
> Olaf
>
I have so much data that we can't take a mysqldump of our database. The
directory tar
ly, there is not a lot of documentation on migration or anything
> else regarding 64bit MySQL.
>
> My current setup consists of one master and two slaves (all using 32bit and
> MySQL 5.0). I am looking to add a 64bit slave to the mix.
>
> What is the difference between 32-bit and 6
On Fri, 25 Apr 2008, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
I would just dump the database from the 32-bit platform and import it
into the 64-bit server.
By "dump" do you mean "mysqldump", or some other process?
--
Tim McDaniel, n00b, [EMAIL PROTECTED]
--
MySQL General Mailing List
For li
Mike wrote:
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add a 64bit slave
r + Slave Replication server, with InnoDB tables only, over a new
> hardware.
>
> Unfortunately, this is the first time I play a role as MySQL DBA, and
> don't have a complete migration plan (yet).
>
> Can someone here please review my migration plan and help me
> adding/
Hi Luis,
On Jan 2, 2008 11:12 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote:
> Baron Schwartz wrote:
> > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote:
> >> Baron Schwartz wrote:
> >>> What are the biggest changes you anticipate? I'd say they will be
> >>> the version upgrade, converting to
Baron Schwartz wrote:
> On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote:
>> Baron Schwartz wrote:
>>> What are the biggest changes you anticipate? I'd say they will be
>>> the version upgrade, converting to InnoDB, and using
>>> replication. It looks like you have planned well for all but
>>> u
Hi,
On Jan 2, 2008 10:04 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote:
> Baron Schwartz wrote:
> > What are the biggest changes you anticipate? I'd say they will be the
> > version upgrade, converting to InnoDB, and using replication. It
> > looks like you have planned well for all but using
Baron Schwartz wrote:
> What are the biggest changes you anticipate? I'd say they will be the
> version upgrade, converting to InnoDB, and using replication. It
> looks like you have planned well for all but using replication.
That's interesting. What kind of activities (besides configuration,
th InnoDB tables only, over a new
> hardware.
>
> Unfortunately, this is the first time I play a role as MySQL DBA, and
> don't have a complete migration plan (yet).
>
> Can someone here please review my migration plan and help me
> adding/prunning missing/exceeding bits?
&g
, and
don't have a complete migration plan (yet).
Can someone here please review my migration plan and help me
adding/prunning missing/exceeding bits?
My current plan is more or less like below. I removed task descriptions
removed, guess the task name is descriptive enough. Indenting mark
[EMAIL PROTECTED] wrote:
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
Unless you are r
-Nachricht
> Datum: Fri, 31 Aug 2007 09:30:13 -0400
> Von: Baron Schwartz <[EMAIL PROTECTED]>
> An: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Betreff: Re: JOIN migration from Oracle to MySQL
> [EMAIL PROTECTED] wrote:
> > Hello,
> >
> > I've
[EMAIL PROTECTED] wrote:
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren'
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
selec
> >> LOL - an entertaining read!
> >>
> >
> > Entertaining? I feel to see the humor in his post.
> >
> >
> I thought it was concise and well written, with an undertone of "I know
> I'm swearing in church but...". So yes, I found it entertaining (I agree
> that it was not necessarily humorous or fun
Martijn Tonies wrote:
LOL - an entertaining read!
Entertaining? I feel to see the humor in his post.
I thought it was concise and well written, with an undertone of "I know
I'm swearing in church but...". So yes, I found it entertaining (I agree
that it was not necessarily humorous
> > Storage engines are unique to MySQL? yes. Is that good? YMMV. Most
> > of the purported benefits can be achieved with Oracle's features
> > without the compromises of balkanised storage engines. You're right,
> > they're not offered by Oracle, or anyone else ... there's a reason no
> > oth
Grant Allen wrote:
Storage engines are unique to MySQL? yes. Is that good? YMMV. Most
of the purported benefits can be achieved with Oracle's features
without the compromises of balkanised storage engines. You're right,
they're not offered by Oracle, or anyone else ... there's a reason no
Hey all, I'm trying to help out a friend of mine who has a database
based on powerbase - which is a really old database, and he said that
the company has long since closed down.
I was trying to see if I there was any way to import the data from
there in to MySQL. He doesn't think there's any way t
On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard,
wrote:
> Check out
> http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
>
Please note that PostgreSQL provides a gateway to other databases thanks to
the DBI-Link extension, as well as it support more than o
Tangirala, Srikalyan wrote:
Hi All:
Could you provide some more information about Oracle limitations, MySQL
limitations, Oracle vs. MySQL etc?
Sure, let's play devil's advocate for a minute.
Some things unique to MySQL that Oracle does not offer include:
- Storage engines, choices like In
: RE: Migration from Oracle to MySQL
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Raj Mehrotra
hccs - Experts in Healthcare Learning
[EMAIL PROTECTED]
-Original Message-
From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007
Thanks for your input Raj.
Regards,
Sri
-Original Message-
From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:32 AM
To: Tangirala, Srikalyan; cluster
Cc: mysql@lists.mysql.com
Subject: RE: Migration from Oracle to MySQL
Check out
http://www-css.fnal.gov
@lists.mysql.com
Subject: Migration from Oracle to MySQL
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL.
In this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All of
Hi,
>Could you provide some more information about Oracle limitations, MySQL
>limitations, Oracle vs. MySQL etc?
I thought it was your study?
MySQL doesn't have (compared to Oracle):
- check constraints
- a procedural language as mature as Oracle PL/SQL
- triggers on a per statement basis as Ora
Hi All:
I am doing a study on the migration of databases from Oracle to MySQL. In
this process, I gathered few points.
Overall, I think arguments can be made in favor of MySQL in terms of
performance, stability, ease of use, and cost. All of these things point to
decreased TCO when using MySQL
1 - 100 of 317 matches
Mail list logo
