Exporting 71MB File

[expired user #5473]'s profile image [expired user #5473] posted 13 years ago in Import/Export Permalink
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's profile image ansgar posted 13 years ago Permalink
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.
[expired user #5473]'s profile image [expired user #5473] posted 13 years ago Permalink
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's profile image ansgar posted 13 years ago Permalink
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"
[expired user #5473]'s profile image [expired user #5473] posted 13 years ago Permalink
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.