Problems With Data Import

[Rohit]

This is very strange. We don't have a similar report elsewhere

Can you try the same import with an old copy of SQLyog? From you description it looks like the problem has cropped up recently.

Anything else you can do to help us reproduce the problem? Can you attach some sample cases by creating a private ticket at http://www.webyog.com/support

In the meantime, we will try to reproduce your problem in a similar environment.

Can you tell me the following info?

1) Size of the SQL dump

2) Structure of the target tables

3) Target MySQL version

4) Innodb or MyISAM tables (Insert on Innodb is sometimes slower than MyISAM)

If we can reproduce the problem, we guarantee a fix within 72 hours.

[ruirib]

'Rohit' wrote on '02:

This is very strange. We don't have a similar report elsewhere

Can you try the same import with an old copy of SQLyog? From you description it looks like the problem has cropped up recently.

Anything else you can do to help us reproduce the problem? Can you attach some sample cases by creating a private ticket at http://www.webyog.com/support

In the meantime, we will try to reproduce your problem in a similar environment.

Can you tell me the following info?

1) Size of the SQL dump

2) Structure of the target tables

3) Target MySQL version

4) Innodb or MyISAM tables (Insert on Innodb is sometimes slower than MyISAM)

If we can reproduce the problem, we guarantee a fix within 72 hours.

Hi,

Thank you for your reply.

I was very surprised with this, as I have transferred a few databases and some with sizes of up to 1 GB and never felt this was too slow. This was with a dump file with just 40 MB and it took a lot of time. Also, these were MyISAM tables.

Anyway, I found a solution – I started using the Compressed Protocol. Surprisingly, something that was taking hours, took less than 3 minutes! Have tried a few times afterwards and it's always been that fast. Also, I have tried one of the biggest tables in the problematic database and was able to transfer it to another server very fast, without using the compressed protocol.

So, whatever it was, was related to the server I was uploading to and the compressed protocol resulted in amazingly fast transfers. I don't know why the help about compressed protocol advises against its use (well, almost). I used it as a last resort!!!! Seems I will be using it a lot more.

Anyway, problem solved.

Thanks for a great product .

Regards

[Author]

Posts