mm242 Posted April 12, 2011 Share Posted April 12, 2011 Hello PS-fellows! I feel a disturbance in the Force when it comes to backing up the database.Using the Tools > Database backup creates a, say 110 KB db_backup-by-pstools.sql.bz2 file but a mysqldump pstable -h pshost.tld -u psadmin -p > psbackup.sql yields a completely different result even after compression with the maximum level... Usually the mysqldump-generated files are x10 bigger than the ones created with the PS backup tool.Is there any reason for that?? and, which .sql file should I use to restore or move the PS installation to another location?Thanks and regards Link to comment Share on other sites More sharing options...
shokinro Posted April 12, 2011 Share Posted April 12, 2011 PrestaShop db backup has an option of "Backup all tables", if you choose "no", it only back core tables.not include the some large data tables such as ps_connections, ps_connections_page,...If you didn't select "yes", then this might be the main reason the size are different. Link to comment Share on other sites More sharing options...
mm242 Posted April 12, 2011 Author Share Posted April 12, 2011 which version of PS are you talking about? Link to comment Share on other sites More sharing options...
shokinro Posted April 12, 2011 Share Posted April 12, 2011 I am not sure about 1.2x, all 1.3x and higher should have this option. Link to comment Share on other sites More sharing options...
mm242 Posted April 12, 2011 Author Share Posted April 12, 2011 well, the one I'm dealing with and trying to upgrade to PS 1.4 is a very old one: PS 1.1.0.5 :-) Link to comment Share on other sites More sharing options...
mm242 Posted April 13, 2011 Author Share Posted April 13, 2011 Hi Ffxi,have you found any workaround?Thanks! Link to comment Share on other sites More sharing options...
shokinro Posted April 13, 2011 Share Posted April 13, 2011 I just checked lowest version 1.2.0.8 that I have at my hand, it seems does not have this option.so it means old version 1.1 should not have this option either.so I have not idea if the backup skips some tables or not. Link to comment Share on other sites More sharing options...
mm242 Posted April 13, 2011 Author Share Posted April 13, 2011 now the question would be: if older versions don't feature the new backup modes described on #1 ... which .sql file should we use to have a proper backup or migrate from one server to another? the one generated by the "Tools > Database backup"-thing or a plain mysqldump ??regards Link to comment Share on other sites More sharing options...
presta-dyr Posted April 13, 2011 Share Posted April 13, 2011 You can try to import both and see if the number of records for each table is right with phpMyAdmin./Kjeld Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts