mavric tehnik Posted July 26, 2012 Share Posted July 26, 2012 I have a problem with database imports, so far I've tested this behaviour on 3 machines, one is our hosting provider.This ipb database is an upgrade from ipb2.3 with fixed special characters (sed tool), so it is in pure utf-8 format.The thing is that if I use different export / import tools, database size differs on import - mostly bf_message_posts and ibf_posts tables size vary, since they are biggest.This various sizes were observed when (I alway use mysql console tool for db import):- if I export database via phpmyadmin and reimport it via mysql tool, size goes over 500MiB- if I export database via mysqldump and reimport it via mysql tool, size stays the same (about 360MiB)I've migrated this dump to my hosting provider and reimported it via bigDump script (http://www.ozerov.de/bigdump) - size goes over 500MiB - those two previously mentioned tables grow on import by 70%.Why are these size differences observed with different import/export methods, since the content seems to be the same? Link to comment Share on other sites More sharing options...
Luis Manson Posted July 29, 2012 Share Posted July 29, 2012 maybe its character conversion? Link to comment Share on other sites More sharing options...
mavric tehnik Posted August 2, 2012 Author Share Posted August 2, 2012 Indeed it is. Also server global charset comes into play. In the end I was unable to port DB to UTF-8. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.