Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Manually Upgrade Database?


Guest

Recommended Posts

Posted

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.

Posted
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.

 

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

Posted
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

 

 

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?

Posted
How can I start over with a fresh (updated) database yet still have my info I need in there?

 

 

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

Posted

All I got was an error stating "#1050 - Table 'address_book' already exists ".

Posted

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.

Posted
All I got was an error stating "#1050 - Table 'address_book' already exists ".

 

Should the database be empty to begin with?

If so then I would just be duplicating my old database.

Posted
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.

 

 

Gotcha...Thanks Im looking now.

Posted

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.

  • 4 weeks later...
Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...