JamesThePanda Posted March 2, 2009 Share Posted March 2, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/147601-transfering-to-a-new-database/ Share on other sites More sharing options...
Mchl Posted March 2, 2009 Share Posted March 2, 2009 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) Quote Link to comment https://forums.phpfreaks.com/topic/147601-transfering-to-a-new-database/#findComment-774965 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.