Exporting 71MB File
| User, date | Message |
|---|---|
|
Written by integrapynoy
2 years ago Category: Import/Export 3 posts since Tue, 25 Jan 11 |
Hi, So im trying to export my db from one server to another using HeidiSQL. I use the option to export the file directly to the new db server. All seems well, no error or anything but it only exports 53MB instead of the full 71.1MB. Any idea? Thanks |
|
Written by ansgar
2 years ago 3950 posts since Fri, 07 Apr 06 |
Do not look at the size of tables - can have unused harddisk space and get optimized when you recreate them. Instead, compare the number of rows to verify that everything is there. |
|
Written by integrapynoy
2 years ago 3 posts since Tue, 25 Jan 11 |
Yeah the tables and rows are the same, just the size of some is different from the original server and the new server. So does that not matter? |
|
Written by ansgar
2 years ago 3950 posts since Fri, 07 Apr 06 |
You should optimize the source table and see if the size gets shrinked to the same size: - Right click the table - Click "Maintenance" - select operation: "Optimize" - click "Execute" |
|
Written by integrapynoy
2 years ago 3 posts since Tue, 25 Jan 11 |
Oh wow, yes that definitely helped...new size is now 48.4MB...big difference. Thank you so much. |
|
Please login to leave a reply, or register at first. |