MySQL Bugs: #30093: MySQL Migration direct from mysqlserver to another ..

Bug #30093	MySQL Migration direct from mysqlserver to another ..
Submitted:	27 Jul 2007 9:43	Modified:	27 Jul 2007 12:50
Reporter:	paul sanz	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Windows (xp pro sp2)
Assigned to:		CPU Architecture:	Any
Tags:	MySQL Migration toolkit .. Plan: Bulk Transfer - gets suck doesnt transfer data

Description:
Hi Group

Is there anyone who can advise on the migration tool.

All ok untill i got to bulk trasfer part of the plan. it just gets suck and doesnt move .. 

Tasks to excecute
Analyze database objects aok!
Execute bulk transfer ...
executing ....
transfering data from table y (47066/47066 rows)
7000 rows transfered  
and it stays that way a 1/4 of the way! why? 

[Message log](where x=private infomation)

Starting online data bulk transfer ...
Initializing source JDBC driver ...
Initializing JDBC driver ... 
Driver class MySQL JDBC Driver 5.0
Opening connection ... 
Connection jdbc:mysql://192.168.0.x1:3306/?user=paul&password="x"&useServerPrepStmts=false&characterEncoding=UTF-8

Initializing target JDBC driver ...
Initializing JDBC driver ... 
Driver class MySQL JDBC Driver 5.0
Opening connection ... 
Connection jdbc:mysql://192.168.0.x2:3306/?user=psanz&password="x"&useServerPrepStmts=false&characterEncoding=UTF-8

Processing schema sia ...

Getting the number of rows of table comunicaciones
SELECT count(*) AS total_num FROM `sia`.`comunicaciones`

Transfering data from table comunicaciones (47066/47066 rows)
SELECT `id_ia`, `telefono`, `correspondencia`, `tipo`, `fecha_n` FROM `sia`.`comunicaciones`

please any info would be well apreciated

paul sanz
systems admin

How to repeat:
.

Thank you for the report.

Please indicate accurate version of MySQL Migration Toolkit you use.

Hi group

FYI ..   problem resolution

I realised that this is not a bug yet a problem of access control and permissions.

I suggest that you use an admin user with write and read permission.

i was as a recap, i was migrating an exisiting mysql server db (Win vista) to mysql server (fedora 7) and i got many grant drop errors and when transfering data the objects were created but did not transfer any data.

Note: I recomend you create the db with its permissions and users needed then migrate but becareful if you do create the db first, you must edit the "sql create script of selected objects in scheme creation and erase DROP VIEW IF EXISTS `dbname`.`tablename`;" apply changes and recreate objects. Next!

hope this will help other novices like myself

Paul
System Admin

Thank you for the feedback.

According to last comment I'll close the report as "Not a Bug"