distal-attribute
distal-attribute
distal-attribute
distal-attribute

Exporting 71MB File

integrapynoy posted 4 years ago in Import/Export
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
ansgar posted 4 years ago
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.
integrapynoy posted 4 years ago
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?
ansgar posted 4 years ago
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"
integrapynoy posted 4 years ago
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.