Import from a MySql DB to Another

[vpalhories]

Hello,

I am in the process of converting an existing application from MS Access to MySql. The ODBC Import from Access to MySql runs without a hitch. It takes about 5 minutes to import 73 tables containing 80,000 records.

Now .. I've got my production DB created on our servers and I want to create a backup table on my computer that I can use for development. I've run into a road block.

When I try to import from one MySql DB to Another, it sometimes works and sometimes not. It actually does not work most of the time. SQLyog simply hangs. When it does work, it takes over an hour to import what took 5 minutes from Access. I am using version 3.64.

So … my question is two-fold. Why does it take longer to import from one MySql DB to another than through ODBC? Secondly, why does it keep hanging on me? I have to try the import at least 7 times for it to work.

Any ideas?

Thanks

— Val

[Ritesh]

I think there is an issue with the MySQL ODBC drivers. The most efficient way to transfer data from one MySQL Host to another is by:

1) Open a new connection to the Target DB by selecting File->Connect

2) Select DB -> Copy Database to Different Host CB

[Author]

Posts