Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Exporting products from one database to another


mark27uk3

Recommended Posts

Hi Guys,

 

Whats the best way to export data from 1 database to another?

 

I have tried exporting the products using phpmyadmin but when I try to run the products.sql file I get this error:

 

Error

 

SQL-query : 

 

INSERT INTO products

VALUES ( 52, 1, '', '3310images/nokia3310dhmuffdiver.jpeg', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '5.9900', '2004-01-06 18:40:31', '2004-01-27 17:58:34', NULL , '0.00', 1, 0, 0, 0 )

 

MySQL said:

 

 

Column count doesn't match value count at row 1

Back

 

What does this mean and what do I need to do to my new database to accept my product data.

 

Thanx

 

Mark :(

Lifes a bitch, then you marry one, then you die!

Link to comment
Share on other sites

why dont you just do a backup of the database via the admin tool backup, then go into the sql file with wordpad, dreamweaver, visual studio (some sort of text editor) and then get the items you need.

if you are adding to a database already populated, then you will need to remove the 'DROP' of the database

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...