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
Greetings List-
I have heard that there are details to be worked out when backing up from MySQL 4.0.x and restoring to MySQL 5.0.x, specifically in the area of special characters. I know that at least one of my
databases has special characters.
Does anyone know the syntax and what commands I s
I have downloaded sucesfully the MySQL Migration Toolkit tool. After start the
error with Java appears. I have Java installed on my PC because I work with
Eclipse 3.1.1 + PHPEclipse Plugin. The JDK installed is 1.5. So if any can help
me ...
Regards,
--
ReynierPM
4to. Ing. Informática
Linux
Is it normal for MySQL migration 1.14 rc to leave MS Access open when it is
done with migration (leaving ldb file)?
Scott
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Hi,
On May 26, 2005, at 5:03 PM, David Griffiths wrote:
This isn't exactly the right spot, but I can't find any info on the
MySQL web site.
Anyone know who maintains the MySQL Migration Tool (or who is
developing it, as it is currently Apha)?
MySQL AB is actively developing it
This isn't exactly the right spot, but I can't find any info on the
MySQL web site.
Anyone know who maintains the MySQL Migration Tool (or who is developing
it, as it is currently Apha)?
It does not support Orace 8i (9i and 10g only), but I've looked through
the source code,
Hello,
> The platform we are working is Mysql 4.1.8 version
> and Windows XP os.
>
> In ms sql server the space used and free space
> available for each database is obtained through
> 'sp_spaceused'procedure( built in ).
>
> Primary memory used by ms sql server and related
> services l
hello,
The platform we are working is Mysql 4.1.8 version
and Windows XP os.
In ms sql server the space used and free space
available for each database is obtained through
'sp_spaceused'procedure( built in ).
Primary memory used by ms sql server and related
services like query
Hi Joshua,
> Making the MySQL indexes would be your responsibility. Importing the data
> would most likely not import the index definitions also. You need to
> recreate those. Your explain seems to indicate that you have *no* indexes
on
> your table. I would guess that your query doesn't hang
Please reply to the list, and not to me. Thanks.
Making the MySQL indexes would be your responsibility. Importing the data
would most likely not import the index definitions also. You need to
recreate those. Your explain seems to indicate that you have *no* indexes on
your table. I would g
Since you have used SQLyog, I will say you contact the
SQLyog people about this.
Karam
--- "Joshua J. Kugler" <[EMAIL PROTECTED]> wrote:
> You "can't?" How are you trying to display? What
> are you using? A CGI
> script? A database utility? Something else? We
> need a bit more information
>
MySQL is very stable on large databases...I would suspect inefficient indexes.
What does your query look like? What is the output when you put "EXPLAIN" in
front of your query?
I don't know anything about SQLYog blob display, so can't comment there.
j- k-
On Monday 05 April 2004 05:4
You "can't?" How are you trying to display? What are you using? A CGI
script? A database utility? Something else? We need a bit more information
to answer the question.
j- k-
On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
> Hello list,
> Recently I've b
Hello list,
Recently I've been in the job of migrating a large (about 1.5GB)
database build in MSSQL Server to MYSQL. The migration was done OK, I
used the "SQLYog" utility to do this. The problem is that one table has
image column types ... I tried to view this column types (blob data
types
land
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
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 lo
Try SQLyog - http://www.webyog.com/sqlyog
Karam
--- [EMAIL PROTECTED] wrote:
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
> MySQL 3.23
>
> I'm looking for a tool or for an algorithm which
> fully supports any
> ORACLE structures ...
> If needed I may use a commerc
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 gi
Hello,
I tried to migrate a database from a MySQL-4.0.14 to another
one hardware with MySQL-4.0.17 installed.
The database has InnoDB tables and I just executed a:
# mysqldump -A --user root --password=my_password > dump_db.txt
in the old server (MySQL-4.0.14) and
# mysql -u root -p < dump_db.
al Message-
From: Hans Zaunere [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 7:40 PM
To: [EMAIL PROTECTED]
Subject: MySQL Migration
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Orac
At 10:39 AM -0700 8/25/01, Hans Zaunere wrote:
>We have about 300,000 records currently in a MySQL
>database. A new system has been built on Oracle, and
>now we must migrate the data from MySQL to Oracle (I
>know, it's not something I wanted to do.) What is the
>best way to do this? Import into
forge an import script.
[.kate]
-Original Message-
From:Hans Zaunere [EMAIL PROTECTED]
Sent:Sat, 25 Aug 2001 10:39:52 -0700 (PDT)
To: [EMAIL PROTECTED]
Subject: MySQL Migration
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle
al Message-
From: Hans Zaunere [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 7:40 PM
To: [EMAIL PROTECTED]
Subject: MySQL Migration
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Orac
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into another database
(something like Access) then expo
Is it somebody out there who has made a migration from an Oracle server to an MySQL
server??
(Or do I have to talk to those NASA guys again?? =)))
The scenario is as simply:
A SUN machine with an Oracle 8.1.7 server with a database with content that I want to
transfer to
a MySQL database. No sp
son Bell" <[EMAIL PROTECTED]>
> To: "mysql list" <[EMAIL PROTECTED]>
> Sent: Friday, March 09, 2001 5:58 PM
> Subject: Postgres to MySQL Migration
>
> > Anyone know an easy way to migrate a Database from Postgres to MySQL?
> >
> > -Jaso
Does someone has an answer for this already done question ??
- Original Message -
From: "Jason Bell" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 5:58 PM
Subject: Postgres to MySQL Migration
> Anyone know an
Anyone know an easy way to migrate a Database from Postgres to MySQL?
-Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
32 matches
Mail list logo
