Ian Lawther Posted February 9, 2011 Share Posted February 9, 2011 Due to a hack at the weekend I am having to rebuild my website and this has caused an unplanned move from 2.2 to 2.3.1. I saved a backup of my database to the computer before my host zapped my site and restarted everything. They assisted me in getting the dump back on to the website today before I loaded OsC again. Thinking I was linking to it I put the database name in during the installation and of course my old one got overwritten by the samples in the installation. ("Oh, bother" I said when I realized). Since then I have read some posts that say that there were changes in the database set up between the two version which sound as if I cannot simply bring in the old database. Can anyone advise on the quickest and most efficient way of of getting information on around 1000 line items and almost as many customers into the new database. Thanks, Ian Lawther PS Please speak slowly and clearly I'm not a techy....... Link to comment Share on other sites More sharing options...
burt Posted February 9, 2011 Share Posted February 9, 2011 Load up your old db. Load up a new DB. Compare the two. Remove anything from the old that is not in the new. Add anything in the new to the old. In other words, make the old have the same STRUCTURE as the new. Done. Should not take you more than a morning. Link to comment Share on other sites More sharing options...
Ian Lawther Posted February 9, 2011 Author Share Posted February 9, 2011 Thanks. In making sure the struck of the old matches I am assuming that I am matching the fields. Do I need to alter items within the fields such as vachar numbers? Ian Link to comment Share on other sites More sharing options...
burt Posted February 9, 2011 Share Posted February 9, 2011 Yes. Link to comment Share on other sites More sharing options...
Ian Lawther Posted February 9, 2011 Author Share Posted February 9, 2011 How do I change that.....many of the new tables have things set at vachar(255) where they had been lower (23, 64 etc). Also I've found one that goes from vachar(x) to text. Ian Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2011 Share Posted March 13, 2011 Hi guys, I have installed oscommerce 2.3.1 and would like to use my old database 2.2 ms2. I have configured includes/configure.php and admin/includes/configure.php to use the old database but Im not seeing the changes on my new installation. Please need assistant. Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2011 Share Posted March 13, 2011 John, Your old MS2 database is NOT compatible with the new v2.3.1 database. You will have to manually insert the old data into the new database making changes to the tables and fields as required. Chris Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.