Re: Confused About Rows and Skipping On Import with MySQL Migration Toolkit 1.1
It's not skipping any rows. When you select records from a database, it gets them in the order that is quickest to retrieve them, not the order they were entered. The "natural" order is how they are stored on disk. As your database is updated over time, this order may change. 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/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 there's a few problems like: incorrect string value for column 'street' at row 655 0 rows transferred The problem is when I try to import just 650 or so, then I go to phpmyadim to look - well the rows are not in the original order - they start with addressID 1-2-3-4 etc but randomly skips some so there's no way I can match the imported row 655 to the addressID (655) (they were in order - no deletions) - to find the bad field to fix it... Q: why is it importing rows and seemingly skipping many? Q: how can I figure out which is the REAL row 655 (without counting by hand) to fix the field text string error? Thanks in advance - dave -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=brentt...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Confused About Rows and Skipping On Import with MySQL Migration Toolkit 1.1
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 there's a few problems like: incorrect string value for column 'street' at row 655 0 rows transferred The problem is when I try to import just 650 or so, then I go to phpmyadim to look - well the rows are not in the original order - they start with addressID 1-2-3-4 etc but randomly skips some so there's no way I can match the imported row 655 to the addressID (655) (they were in order - no deletions) - to find the bad field to fix it... Q: why is it importing rows and seemingly skipping many? Q: how can I figure out which is the REAL row 655 (without counting by hand) to fix the field text string error? Thanks in advance - dave -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql-migration-toolkit
Am using the following packages -rw-r--r-- 1 root root 4117403 May 3 2007 mysql-administrator-5.0r12-1rhel4.i386.rpm -rw-r--r-- 1 root root310923 Aug 20 17:53 mysql-gui-tools-5.0r12-195.1.x86_64.rpm -rw-r--r-- 1 root root 6265000 May 3 2007 mysql-gui-tools-5.0r12-1rhel4.i386.rpm -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 PM, Mad Unix <[EMAIL PROTECTED]> wrote: > 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-migration-toolkit-5.0r12-1rhel4.i386.rpm > Preparing...### > [100%] >1:mysql-migration-toolkit### > [100%] > > but when i run mysql-query-browser i see this > > (mysql-query-browser-bin:21015): Gtk-WARNING **: Unable to locate theme > engine in module_path: "clearlooks", > > (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property > `urgency_hint' for class `GtkWindow' > > (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property > `pack_direction' for class `GtkMenuBar' > > (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property > `child_pack_direction' for class `GtkMenuBar' > > > Any help... > > > On Wed, Aug 20, 2008 at 4:32 PM, Mad Unix <[EMAIL PROTECTED]> wrote: > >> 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 version "1.6.0_07" >> Java(TM) SE Runtime Environment (build 1.6.0_07-b06) >> Java HotSpot(TM) 64-Bit Server VM (build 10.0-b23, mixed mode) >> [EMAIL PROTECTED] download]# locate libjvm.so >> /u01/oracle/10g/jdk/jre/lib/i386/client/libjvm.so >> /u01/oracle/10g/jdk/jre/lib/i386/server/libjvm.so >> /u01/oracle/10g/jre/1.4.2/lib/i386/client/libjvm.so >> /u01/oracle/10g/jre/1.4.2/lib/i386/server/libjvm.so >> /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/client/libjvm.so >> /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/server/libjvm.so >> /usr/lib64/gcj-4.1.1/libjvm.so >> [EMAIL PROTECTED] download]# >> >> >> [EMAIL PROTECTED] download]# uname -a >> Linux PowerEdge1 2.6.18-92.1.10.el5 #1 SMP Tue Aug 5 07:42:41 EDT 2008 >> x86_64 x86_64 x86_64 GNU/Linux >> [EMAIL PROTECTED] download]# cat /etc/redhat-release >> redhat-4 >> #CentOS release 5.2 (Final) >> >> Any help how to get toolkit installed? >> -- >> Your search - madunix - did not match any documents. >> > > > > -- > Your search - madunix - did not match any documents. > -- Your search - madunix - did not match any documents.
Re: mysql-migration-toolkit
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-migration-toolkit-5.0r12-1rhel4.i386.rpm Preparing...### [100%] 1:mysql-migration-toolkit### [100%] but when i run mysql-query-browser i see this (mysql-query-browser-bin:21015): Gtk-WARNING **: Unable to locate theme engine in module_path: "clearlooks", (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property `urgency_hint' for class `GtkWindow' (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property `pack_direction' for class `GtkMenuBar' (mysql-query-browser-bin:21015): libglade-WARNING **: unknown property `child_pack_direction' for class `GtkMenuBar' Any help... On Wed, Aug 20, 2008 at 4:32 PM, Mad Unix <[EMAIL PROTECTED]> wrote: > 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 version "1.6.0_07" > Java(TM) SE Runtime Environment (build 1.6.0_07-b06) > Java HotSpot(TM) 64-Bit Server VM (build 10.0-b23, mixed mode) > [EMAIL PROTECTED] download]# locate libjvm.so > /u01/oracle/10g/jdk/jre/lib/i386/client/libjvm.so > /u01/oracle/10g/jdk/jre/lib/i386/server/libjvm.so > /u01/oracle/10g/jre/1.4.2/lib/i386/client/libjvm.so > /u01/oracle/10g/jre/1.4.2/lib/i386/server/libjvm.so > /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/client/libjvm.so > /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/server/libjvm.so > /usr/lib64/gcj-4.1.1/libjvm.so > [EMAIL PROTECTED] download]# > > > [EMAIL PROTECTED] download]# uname -a > Linux PowerEdge1 2.6.18-92.1.10.el5 #1 SMP Tue Aug 5 07:42:41 EDT 2008 > x86_64 x86_64 x86_64 GNU/Linux > [EMAIL PROTECTED] download]# cat /etc/redhat-release > redhat-4 > #CentOS release 5.2 (Final) > > Any help how to get toolkit installed? > -- > Your search - madunix - did not match any documents. > -- Your search - madunix - did not match any documents.
mysql-migration-toolkit
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 version "1.6.0_07" Java(TM) SE Runtime Environment (build 1.6.0_07-b06) Java HotSpot(TM) 64-Bit Server VM (build 10.0-b23, mixed mode) [EMAIL PROTECTED] download]# locate libjvm.so /u01/oracle/10g/jdk/jre/lib/i386/client/libjvm.so /u01/oracle/10g/jdk/jre/lib/i386/server/libjvm.so /u01/oracle/10g/jre/1.4.2/lib/i386/client/libjvm.so /u01/oracle/10g/jre/1.4.2/lib/i386/server/libjvm.so /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/client/libjvm.so /usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre/lib/x86_64/server/libjvm.so /usr/lib64/gcj-4.1.1/libjvm.so [EMAIL PROTECTED] download]# [EMAIL PROTECTED] download]# uname -a Linux PowerEdge1 2.6.18-92.1.10.el5 #1 SMP Tue Aug 5 07:42:41 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux [EMAIL PROTECTED] download]# cat /etc/redhat-release redhat-4 #CentOS release 5.2 (Final) Any help how to get toolkit installed? -- Your search - madunix - did not match any documents.
Problems with MySQL Migration Toolkit
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 User: #310201 El programador superhéroe aprende de compartir sus conocimientos. Es el referente de sus compañeros. Todo el mundo va a preguntarle y él, secretamente, lo fomenta porque es así como adquiere su legendaria sabiduría: escuchando ayudando a los demás... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table parameters not transferring while using Migration toolkit
Hi, When I use the MySQL Migration Toolkit to transfer a Database from one Mysql server to another, the table parameters configured do not seem to be transferred as well. Fields specified as Primary keys that autoincrement do not autoincrement in the transferred database and fields set as null fields with default values all of a sudden show as NOT NULL. I'm using MySQL Server 5.0.11 and Migration Toolkit 1.0.21rc. Any suggestions / ideas as to why this is happening (the transfer is done online, so all objects and data is moved online and not scripted). Thanks, Dewald Troskie GIS Developer / Database Architect GIS Global Image (Pty) Ltd. Helping the world make informed decisions P.O Box 15 The Innovation Hub 0087 Cell: +27 (0)72 685 4246 Tel: +27 (0)12 844 0660 Fax: +27 (0)12 844 0668 Email: [EMAIL PROTECTED] Web: www.globalimage.co.za Web: www.mapme.co.za Registered Linux User No: 371874 Office L15 Enterprise Building The Innovation Hub - Hotel Street Lynnwood, Pretoria, 0087 "The are 10 kinds of people, those who understand binary and those who don't"
Re: Migration toolkit
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 generate two sets of data. The first is a list of your users, their hostnames, and their password hashes from your old server: CREATE TABLE oldUsers SELECT user, host, password FROM mysql.user; You can use the utility mysqldump to convert oldUsers table to a SQL script. Save this dump into a text file (oldusers.sql) for later. Next you need to run a bunch of SHOW GRANTS for statements. A script (pick your favorite scripting language for this) can crawl through oldUsers (just created) and capture the results of SHOW GRANTS FOR 'user'@'host' for every user in the oldUsers table. Save the results into another text file (oldgrants.sql). These will be the SQL statements you will need to restore permissions to your current users in your new database. Now comes the fun part: I prefer to enter the CLI and navigate to the correct database by hand before executing scripts like these (I have seen many people just do this from the command line but I would rather be sure). On your new server, start your mysql CLI and navigate to the mysql database. Once there, execute the script that generates the oldUsers table. The sequence should look something like this: mysql -u yourlogin -p mysql mysql> source full_path_to_oldusers.sql That should create a table of all of your user accounts in the table oldUsers in the mysql database of your new server. Bulk insert them into your users table like this INSERT IGNORE user (user, host, password) SELECT user, host, password FROM oldUsers; And refresh the permissions cache: FLUSH PRIVELEGES; Now you are ready to re-apply privileges. Assuming that you correctly captured the GRANT statements from your "SHOW GRANTS for" script, you should be able to say. mysql> source full_path_to_oldgrants.sql and do one last FLUSH PRIVILEGES; Your old accounts should now exist on your new server with their old permissions restored. Sorry but you asked for "any" ideas... ;-) Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ed Reed" <[EMAIL PROTECTED]> wrote on 02/14/2006 12:11:05 PM: > 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 and is there > anything special I need to do to make it happen? > > - Thanks > > >
Re: Migration toolkit
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 password hashes from your old server: CREATE TABLE oldUsers SELECT user, host, password FROM mysql.user; You can use the utility mysqldump to convert oldUsers table to a SQL script. Save this dump into a text file (oldusers.sql) for later. Next you need to run a bunch of SHOW GRANTS for statements. A script (pick your favorite scripting language for this) can crawl through oldUsers (just created) and capture the results of SHOW GRANTS FOR 'user'@'host' for every user in the oldUsers table. Save the results into another text file (oldgrants.sql). These will be the SQL statements you will need to restore permissions to your current users in your new database. Now comes the fun part: I prefer to enter the CLI and navigate to the correct database by hand before executing scripts like these (I have seen many people just do this from the command line but I would rather be sure). On your new server, start your mysql CLI and navigate to the mysql database. Once there, execute the script that generates the oldUsers table. The sequence should look something like this: mysql -u yourlogin -p mysql mysql> source full_path_to_oldusers.sql That should create a table of all of your user accounts in the table oldUsers in the mysql database of your new server. Bulk insert them into your users table like this INSERT IGNORE user (user, host, password) SELECT user, host, password FROM oldUsers; And refresh the permissions cache: FLUSH PRIVELEGES; Now you are ready to re-apply privileges. Assuming that you correctly captured the GRANT statements from your "SHOW GRANTS for" script, you should be able to say. mysql> source full_path_to_oldgrants.sql and do one last FLUSH PRIVILEGES; Your old accounts should now exist on your new server with their old permissions restored. Sorry but you asked for "any" ideas... ;-) Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ed Reed" <[EMAIL PROTECTED]> wrote on 02/14/2006 12:11:05 PM: > 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 and is there > anything special I need to do to make it happen? > > - Thanks > > >
Re: Migration toolkit
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 and is there anything special I need to do to make it happen? - Thanks
Migration toolkit
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 and is there anything special I need to do to make it happen? - Thanks