I need to move a huge table (10 GB) from one external server to another. If the table were smaller I would simply use Backup/Restore or even Export/Import but database stops the Backup or Export function about 10% into it.
What is a good way to move this database from one MySQL to another?
10 GB Table
-
alexa
Re: 10 GB Table
Could you please provide us the following information that may help us in investigating this issue:I need to move a huge table (10 GB) from one external server to another. If the table were smaller I would simply use Backup/Restore or even Export/Import but database stops the Backup or Export function about 10% into it.
1. The result of the following query reflecting the settings of the MySQL server:
show variables;
2. The CREATE definition of the table.
3. What's the speed of the channel between the client and server?
We would suggest you to perform this task with the Schema/Data Compare functionality of dbForge Studio for MySQL.What is a good way to move this database from one MySQL to another?
Please see the 'Schema Compare Demo' and 'Data Compare Demo' videos: http://www.devart.com/dbforge/mysql/stu ... -more.html