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 use MySQL at production (I'm u
Hi Lenz,
You cannot use UUID() or indeed any other function (with the exception
of current_timestamp) as the default value for a column
As per the manual at
http://dev.mysql.com/doc/refman/5.1/en/create-table.html
The DEFAULT clause specifies a default value for a column. With
on
Hi Lenz,
I used UUID() function, I am getting error "Check the manual that
corresponds to your mysql server version for the right syntax to use near
UUID()". I am using mysql version 5.0.45.
DROP TABLE IF EXISTS `AdventureWorks_HumanResources`.`Employee`;
CREATE TABLE `AdventureWorks_Huma
>
> 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
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
Hi Tom, all,
Swigg, Tom C wrote:
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 o
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
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) with approximately 100GB data
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
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.
Everythin
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 exceptio
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
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
On 4/25/08 11:23 AM, "Mike" <[EMAIL PROTECTED]> wrote:
> I would like to move from 32-bit to 64-bit MySQL within the next year.
> Unfortunately, there is not a lot of
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 a
> >> 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
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
Check out
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
Raj Mehrotra
hccs - Experts in Healthcare Learning
[EMAIL PROTECTED]
-Original Message-
From: Tangirala, Srikalyan [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 26, 2007 11:11 AM
To: cluster
Cc: mysql@list
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
YIKES!
:)
- Thanks Shawn
>>> <[EMAIL PROTECTED]> 2/14/06 10:08:14 AM >>>
I haven't tried the migration toolkit so I don't know what it can or cannot
do. I am assuming that you have hand-transferred a few users from your old
system to the new one.
What I can suggest is that you generat
I haven't tried the migration toolkit so I don't know what it can or
cannot do. I am assuming that you have hand-transferred a few users from
your old system to the new one.
What I can suggest is that you generate two sets of data. The first is a
list of your users, their hostnames, and their
Does anyone have any idea on this one?
- Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 2/10/06 3:09 PM >>>
I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0
system. It doesn't appear that it can successfully migrate my usernames and
privileges. Is it supposed to be able to an
choking on jos_banner as incorrect syntax
- Original Message -
From: "James Dey" <[EMAIL PROTECTED]>
To: "Gabriel PREDA" <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, February 11, 2006 1:52 AM
Subject: Re: Migration
Thanks!
The line is:
/*!4 ALTER
Thanks!
The line is:
/*!4 ALTER TABLE `jos_banner` */;
LOCK TABLES `jos_banner` WRITE;
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM 1',0,46,0,'osmbanner1.png
','http://www.opensourcematters.org','2004-07-07$
UNLOCK TABLES;
/*!4 ALTER TABLE `jos_banner` ENABLE KEYS */;
For the rec
Not the whole... maybe it's humongous... some lines above line 20 and some
beneath...
--
Gabriel PREDA
Senior Web Developer
On 2/10/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
>
> James,
>
> You're going to need to show us the contents of olddbname.sql.
>
> -Sheeri
>
> On 2/10/06, James Dey <
2 785-5102
> fax +27 11 388-8907
> mail[EMAIL PROTECTED]
>
>
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 10 February 2006 11:58 AM
> To: mysql@lists.mysql.com
> Subject: Re: Migration
>
>
> > I am migrating a datab
o: mysql@lists.mysql.com
Subject: Re: Migration
> I am migrating a database from mySQL 4.0 to 4.1.16 and have the error
>
>
>
> ERROR 1064 at line 21: You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right syntax
to
> use
> I am migrating a database from mySQL 4.0 to 4.1.16 and have the error
>
>
>
> ERROR 1064 at line 21: You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right syntax
to
> use near 'ALTER TABLE `jos_banner` */' at line 20
>
>
>
> Could a
Hello.
My fault - it is a typo, instead of dealer_type_name, I should have
written PRIMARY KEY (`dealer_type_id`,`dealer_type_id`). I don't know
how it was possible to import this table to the same version, but it is
not a right syntax. Change it to PRIMARY KEY (`dealer_type_id`).
cybermalandr
My fault about not replying to the list. What is the cause of this extra
line? is this a mysqldump bug in that older version of MySQL? how come I was
able to export and import this DB in the same version but different
platform? Any ideas?
Thanks,
cybm
On 1/17/06, Gleb Paharenko <[EMAIL PROTECTE
Hello.
Sorry for such a late reply. The problem is in the duplicate line
`dealer_type_name`. Remove one of these lines. Please, always send
a copy of the message to the list. Most probably somebody whould have
suggest you the same, if you had posted you mail to the list as well.
Kuai
cybermala
Hello.
Please, provide the peace of the dbname.mysql file with lines around 574
line.
cybermalandro cybermalandro wrote:
> I have a dump from a database in a FreeBSD box with MySQL version 4.0.20 and
> I am trying to import this dump to a mysql DB server which runs gentoo and a
> MySQL version o
[EMAIL PROTECTED] wrote:
First, THANK YOU VERY MUCH!!! You actually posted the results of SHOW
CREATE TABLE and EXPLAIN. I wish everyone who had a query problem would do
those two very simple things.
Agreed!
Second, let's look again at what your EXPLAIN is telling you. If you
locate the col
"ISC Edwin Cruz" <[EMAIL PROTECTED]> wrote on 11/01/2005 04:33:39 PM:
> Hi All!!
> I recently have migrated a database from SQL Server 7.0 to Mysql 5.0.14
> (I´ve used MySQL Migration tool), mi probem is that the queries where i
use
> foreing keys are tooo sloowww
>
> Specialy in two tables;
>
Hello.
Sometimes, after an upgrade it is necessary to rebuild indexes
in the tables (I'm not sure if it always produces an error if
you haven't done it). In general - usual recommendations for
optimizing queries work in your case. Use the slow query log
to find slow queries. Check if indexes
Hi,
why not using the -e otion to mysqldump ? it make an INSERT command as
long as your max_command_packet permit it.
2005/8/23, Bruce Dembecki <[EMAIL PROTECTED]>:
> Once you decide to use mysqldump, be aware that the quickest way to
> export/import large files is to use the --tab feature on ex
hi,
should I use mysqldump from the Mysql 4.0 or 4.1?
Regards,
Rafal
p.s.
Thx for all other tips!
At 21:44 23.08.2005, Bruce Dembecki wrote:
Once you decide to use mysqldump, be aware that the quickest way to
export/import large files is to use the --tab feature on export and
mysqlimport to l
Once you decide to use mysqldump, be aware that the quickest way to
export/import large files is to use the --tab feature on export and
mysqlimport to load the data...
Essentially:
On the old (4.0) server:
mysqldump --tab=/var/tmp/directory mydatabase
On the new (4.1) server (assuming you
Hello.
Use mysqldump, but be aware of incompatibles between 4.0 and 4.1:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Rafal Kedziorski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> we have an J2EE application which ist using MySQL 4.0. There is an
> bug, which was fixed in MySQL
At 15:30 23.08.2005, Jason Pyeron wrote:
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
Correct, I wan't minimize downtime :)
Regards,
Rafal
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE app
AFAIK, to move the data from one InnoDB file to one table per file,
the only option is to dump and restore.
(you may want to remove index, and foreign key checks before the
restore, and put it back afterwards)
2005/8/23, Rafal Kedziorski <[EMAIL PROTECTED]>:
> Hi,
>
> we have an J2EE application
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an bug, which
was fixed in MySQL 4.1. We are using tr
is there other ways of doing this?
tia,
On Tuesday 02 August 2005 20:33, Gleb Paharenko wrote:
> Hello.
>
>
> Have a look here:
> http://solutions.mysql.com/technology/technology/?item=425
>
> SQLPorter supports Postgres according to this page.
>
> JM <[EMAIL PROTECTED]> wrote:
> > hi all,
> >
Hello.
Have a look here:
http://solutions.mysql.com/technology/technology/?item=425
SQLPorter supports Postgres according to this page.
JM <[EMAIL PROTECTED]> wrote:
> hi all,
>is there a howto on this? or an application for this?
>
> tia,
>
--
For technical sup
from a purely religous logical architecture viewpoint it is better to
keep the business rules as close to the persistence layer (ex. RDBMS)
as possible. in the practical physical/business world it is severly
hyperlinearly expensive (both hardware as well as Oracle licenses) to
support that model.
Thank you for your input,
V/R,
Phong
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 3:41 AM
To: Johnson, Michael ; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com; 'Nguyen, Phong'
Subject: Re: Migration from ORACLE 9i to MySQL
Sha
k you for input,
Nguyen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 2:25 PM
To: Johnson, Michael
Cc: mysql@lists.mysql.com; 'Nguyen, Phong'
Subject: RE: Migration from ORACLE 9i to MySQL
"Johnson, Michael " <[E
Shawn, others,
> Maybe the US Air Force has an unlimited budget but the rest of us do not.
> It seems to me that they "powers that be" in Nguyen's shop have made a
> decision (rational or not, you know how some managers are) to move away
> from a PREMIUM-priced package like 9i to something that ca
Johnson, Michael wrote:
MySql is an 8th grade toy.
So why are you here? Go haunt an Oracle mailing list.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I got no experience in migrating Oracle to Mysql, but here might be what you
were looking for:
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
Scott
On 7/28/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote:
>
>
> I will be migrating Oracle database 9i to Mysql. Do anyone have any
> expe
"Johnson, Michael " <[EMAIL PROTECTED]> wrote on 07/28/2005
01:56:33 PM:
> Why are you going backwards MySql is an 8th grade toy.
>
> -Original Message-
> From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 28, 2005 9:42 AM
> To: mysql@lists.mysql.com
> Subject: M
Why are you going backwards MySql is an 8th grade toy.
-Original Message-
From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 9:42 AM
To: mysql@lists.mysql.com
Subject: Migration from ORACLE 9i to MySQL
I will be migrating Oracle database 9i to Mysql. Do a
Jeff,
- Original Message -
From: "Jeff Mathis" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 20, 2004 6:51 PM
Subject: migration of InnoDB 4.1.3 to 4.1.6
I see from the release notes that tables with timestamp column will need
to be rebuilt. will the se
Might try using windows program called SQLYOG.. makes this dead easy..
On Fri, 24 Sep 2004 09:52:10 -0700 (PDT), Seena Blace
<[EMAIL PROTECTED]> wrote:
> Hi,
> How to migrate mysql database from one box to another box ?
> thanks
> -Seena
>
>
> -
> Do you Yahoo!?
* Seena Blace
> How to migrate mysql database from one box to another box ?
You could use mysqldump on the source box, and the standard client to import
the dumped file on the target box:
http://dev.mysql.com/doc/mysql/en/mysqldump.html >
There are other options, depending on the table handler u
e.
>
> Thanks,
> Narasimha
> 91 98456 82459
>
> -Original Message-
> From: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE
> PROVIDER)
> Sent: Tue 8/17/2004 3:08 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc:
>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc:
Subject: RE: Migration tools/plan from oracle 7.3 to Mysql 4.0
Hi,
Thank you for your response. Could any one give more clarification on
the alternatives for Views, Stored procedures
Martijn Tonies wrote:
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
that you:
- have to change your queries so that they include the full VIEW sql,
because MySQL doesn't have an alternative
- have to recreate your stored procedures in appli
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Hi Narasimha,
Please reply to the MySQL list instead of me personally only.
> How we can write the equivalent code for triggers of
>oracle in Mysql?. Shall we do it by using User Defined
>Functions?. Can we use database queries inside
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
that you:
- have to change your queries so that they include the full VIEW sql, because MySQL
doesn't have an alternative
- have to recreate your stored procedures in application code and do
> Thank you for your response. Could any one give more
clarification on the alternatives for Views, Stored procedures, triggers and
contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot
support the InnoDB storage engine.
>
Well, what other alternative do you have but appl
Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tue 8/17/2004 12:59 PM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER); [EMAIL PROTECTED]
Cc:
Subject: Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
First: please don't hijack threads... And don't quote them completely
if you do.
> I am new to MySql. Could you please let me know the different
migration tools avialable for the migration of oracle 7.3 database to mysql
4.0 classic version.
You could try the Schema Migrator tool in Data
d learning experiment:) The query/view option was in reality a
cheat to get things done and working.
Regards
Brian
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 3:27 PM
To: Brian L. Walter; [EMAIL PROTECTED] Mysql. Com
Subject: Re: Migratio
Brian L. Walter wrote:
Thanks for your reply.
Let me try again.
In access, you can create views. These are called 'queries' in Access. The
current version of MySQL does not support views, as I understand it.
Using DBManager, I import all my tables and data to MySQL from Access. One
of the opt
Thanks for your reply.
Let me try again.
In access, you can create views. These are called 'queries' in Access. The
current version of MySQL does not support views, as I understand it.
Using DBManager, I import all my tables and data to MySQL from Access. One
of the options during the import
Brian L. Walter wrote:
Greetings,
I'm in the process of migrating from Access to MySQL. I've imported access
queries into MySQL, and they do show up (using a third party db manager,
they show up under tools).
In Access, queries can be used like views. I.e. you can select from them.
Now, the ver
What kind of my.cnf file are you using with that setup?
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net
On Jan 8, 2004, at 2:48 PM, [EMAIL PROTECTED] wrote:
We moved our main production server to a dual opteron last night,
running SuSE 9.0 x86_64 (kernel 2.4.21), and the binaries mysql
Run all your tables thru this. Save the script as xinno_convert. As in
xinno_convert < foo.sql | mysql
Suposedly you can also alter a table to innodb. But that never worked
for me it just looped using cpu for days. So I made this script which
worked fine. Other than converting implicit lockin
ok in my case.
Good luck!
-Holly
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:20 AM
To: Prasad Budim Ram; [EMAIL PROTECTED]
Subject: Re: Migration tools for sybase to MySQL
if you can export the same from sybase, then undoubtedly you ca
Hi,
Sql Porter Might Be Of Some Help, But Alas Its Not Free...
P
Prasad Budim Ram wrote:
> Hi,
>
> Are there any tools to migrate db schema as well as data from sybase
> to mysql?
>
> Thanks,
> Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
if you can export the same from sybase, then undoubtedly you can import
those iinto mysql
Nitin
- Original Message -
From: "Prasad Budim Ram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 1:57 PM
Subject: Migration tools for sybase to MySQL
> Hi,
>
> Are the
<[EMAIL PROTECTED]>
> To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
> Sent: Thursday, December 12, 2002 12:27 PM
> Subject: Re: Migration from Oracle
>
> Dear Stefan,
>
> Thank you for your help.
> I used MyODBC 3.51, and successfully migrated to My
>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Satish Vohra" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 12:27 PM
Subjec
Dear Satish,
> I want to migrate from Oracle to MySQL.
> So I need to import the tables and data from Oracle.
> Can anyone suggest any tool which can do this.
> Any pointer regarding this will be appreciated.
(1) I am not familiar with Oracle, but I assume (oh, that word again) that
it has a dump
Hi,
Mark Hennessy wrote:
> I have decided to use MAX(tablename_index)+1 in advance of inserting the
> record, as I want to use as little dbms-specific magic as possible and
> this matches as close as I can figure the behavior of _seq in mSQL.
>
> I would be doing the following in the same thread
: Mark Hennessy <[EMAIL PROTECTED]>
> To: Gerald Clark <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Migration of a database from mSQL 2.x to MySQL 3.23.51
>
> I don't see how AUTO_INCREMENT preserves its value in the output of a
&
I use a shareware tool called dbScripter (www.dkgas.com), which is very
cheap to license. It lets you generate scripts that will create table
structures, indexes and table-loads. It comes with syntax profiles for SQL
Server, Oracle and Access, and you can also create your own profiles. I
created o
* Sonia
> I`m a newbie to mysql and linux and have at the moment a necessity
> concerning to both that I`m not able to handle due to my lack of
> knowledge in these fields. The fact is that I need to migrate a mysql
> database and its tables from windows to linux and haven`t found anything
> i
IL PROTECTED]
> Subject: Re: Migration to mysql from MS SQL Server
>
>
>
> Harpreet writes:
>
> > Can we create a php page that will use mssql_connect to connect
> to ms sql
> > server get the data and then use mysql_connect and connect to
> mysql server
> &g
Harpreet writes:
> Can we create a php page that will use mssql_connect to connect to ms sql
> server get the data and then use mysql_connect and connect to mysql server
> and populate the table.
>
> Is this possible.
Yes, but only if you don't include 8 kilobytes worth of
redundant irrelevanc
1 - 100 of 110 matches
Mail list logo
