Guest Posted December 6, 2004 Posted December 6, 2004 I just did a fresh install of the lastest Oscommerce and I needed to import my old database to keep my existing stuff. So far I have had to add a few fields to the database to make it work but now I have a new problem. Since putting the new site live I received an order and it's missing both the ship to and billing info. I am assuming its not saving the persons info during account setup. Is there a way to have a new database but somehow import my customers and products OR is there a list of things I need to manually add to my old database? I've searched the site so many times and the search feature isnt bringing up anything.
thetraveller Posted December 6, 2004 Posted December 6, 2004 I just did a fresh install of the lastest Oscommerce and I needed to import my old database to keep my existing stuff. So far I have had to add a few fields to the database to make it work but now I have a new problem. Since putting the new site live I received an order and it's missing both the ship to and billing info. I am assuming its not saving the persons info during account setup. Is there a way to have a new database but somehow import my customers and products OR is there a list of things I need to manually add to my old database? I've searched the site so many times and the search feature isnt bringing up anything. <{POST_SNAPBACK}> Hi: I am doing exactly what are you talking about. I have dumped my old database and imported it into my new one without any problems at all. Why did you have to add fields to make it work? You should have dumped the old database in its entirety and imported it completely as well. Can you provide more info? Thanks, John
Guest Posted December 6, 2004 Posted December 6, 2004 Hi: I am doing exactly what are you talking about. I have dumped my old database and imported it into my new one without any problems at all. Why did you have to add fields to make it work? You should have dumped the old database in its entirety and imported it completely as well. Can you provide more info? Thanks, John <{POST_SNAPBACK}> Ok thats where I am confused. I just specified my old database in the config files. How can I start over with a fresh (updated) database yet still have my info I need in there?
thetraveller Posted December 6, 2004 Posted December 6, 2004 How can I start over with a fresh (updated) database yet still have my info I need in there? <{POST_SNAPBACK}> Ok, using phpMyAdmin connect to the database. Select export and make sure that you select all of the tables in the DB. With the resulting file connect to the new DB using phpMyAdmin. Use the 'SQL' tab and import the file that you just created. You should be all set with all of the old info into a new database. John
Guest Posted December 6, 2004 Posted December 6, 2004 All I got was an error stating "#1050 - Table 'address_book' already exists ".
Guest Posted December 6, 2004 Posted December 6, 2004 are you performing an upgrade from ms1 to ms2? if so, there are a few things which need to be completed sql wise with the database, see your 'extras' directory from the osCommerce source.
Guest Posted December 6, 2004 Posted December 6, 2004 All I got was an error stating "#1050 - Table 'address_book' already exists ". <{POST_SNAPBACK}> Should the database be empty to begin with? If so then I would just be duplicating my old database.
Guest Posted December 6, 2004 Posted December 6, 2004 are you performing an upgrade from ms1 to ms2? if so, there are a few things which need to be completed sql wise with the database, see your 'extras' directory from the osCommerce source. <{POST_SNAPBACK}> Gotcha...Thanks Im looking now.
Guest Posted December 6, 2004 Posted December 6, 2004 Thanks, I ran the database upgrade php file. Created a new customer and all the info was passed and saved through the database. Is there any other critical files I need to run there to make things work properly? I see alot of files...a little confusing.
RikR Posted December 30, 2004 Posted December 30, 2004 I am trying to go from 2.2 CVS to 2.2 MS2 and can not figure out how to get my data moved to new database. In the Extras folder was an upgrade.php, uploaded it, it seemed to want the mysql.php file. Uploaded mysql.php but still get error when run upgrade.php. Tried importing data from old database but get error mentione above about table already existing. I'm stuck. Rik Rasmussen
Recommended Posts
Archived
This topic is now archived and is closed to further replies.