Please stay with me on this one as I’m not entirely sure what I am asking!!
I had some issues when updating to 1.2 where in the end I did a fresh install and imported a DB backup from the 17 December. That was my last backup via the store admin.
Before I tried to do the update I made a TAR file backup of the whole directory via SSH and also did a mysqldump via SHH. This gave me the data.sql file, but it seems that it is a little messed up as when I tried to import the db file I was getting errors.
What I need to know is this as it contains key informations relating to sales, customers and other information;
1.) Can I manually transfer information/data across table to table?
2.) Is there an automated way to do this? A better or worse way/tool to achieve this?
Perhaps I need to look at debugging the sql file? But I do not how to do that, even if that is possible..
Sorry for the long winded tale? If anyone is about and fancies digging deeper in this DB stuff then hook me on;