Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Replacing the database


Guest

Recommended Posts

Posted

I have moved my webshop from one server to another. Since the former installation was an old one, I installed the latest osCommerce version on the new server.

 

Using phpMyAdmin I exported the database from my old server. Then I tried to replace the database using the restore function at Database Backup Manager in the admin area. That didn't do the trick. Then I tried to import the old database into the new server using phpMyAdmin, but I can't really figure out that either. It keep telling me that "Table 'thetable' already exists".

 

The old database was based on MySQL 4.1.22 using phpMyAdmin 2.5.6.

The new database is based on MySQL 5.0.51a using phpMyAdmin 3.2.3.

 

When y'all have rofl'd and thought "noob", maybe you could give me an answer to my misery ;-)

Posted

Ok, I have now been fooling around with this problem for some time. I found that I was able to export a single table from the old database, delete the matching table in the new database and then import the old table. But then I discovered that the old table must have had another structure than the osCommerce Online Merchant v2.2 Release Candidate 2a requires. Seems like it's a question about database table structure. Any suggestions on how to make the old structured database work together with the new version of osCommerce?

Archived

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

×
×
  • Create New...