Transfering to a new database

[JamesThePanda]

Hi

I have this old data base from a ecommerce store and I want to upgrade it to a new oscommerce one.

 

I am trying to transfer the customers over

 

Is it possible to just pick out certain field and input them into the new data base?

 

I want to pick out the folowing fields CustomerID, Firstname, lastname, Email, Password, Telephone

 

I tried changing the table name to the same one as in the Oscommerce database and then I changes the field names that I wanted. I then dropped the fiels i didnt want i then submitted it or imported it . But that doesnt seem to have work can any one help on what I should do ?

 

Thanks

 

James

[Mchl]

There are several ways you could try that.

 

For example, have both tables in one database, and use INSERT ... SELECT choosing only columns you need.

http://dev.mysql.com/doc/refman/5.1/en/insert-select.html

 

Make sure that datatypes for new column match those for old columns (and if not, process your data so that it fits into new table)