JamesThePanda Posted July 20, 2009 Share Posted July 20, 2009 Hi I have 2 databases I want to import the customer from one databse into anouther. The systems are totally seperate but the data is the same Ie the field name are different. I want to export the old database in to excel change teh name around and then import it via php my admin. can this be done. Im am a bit of a noob were MySQL is concerned. Thanks James Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted July 20, 2009 Share Posted July 20, 2009 Of course. If you have phpMyAdmin installed on your server you can export all data to CSV format easily. Quote Link to comment Share on other sites More sharing options...
JamesThePanda Posted July 20, 2009 Author Share Posted July 20, 2009 so I import it in to CSV format and then in to excel? Thanks James Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted July 20, 2009 Share Posted July 20, 2009 export as csv. open in excel and modify the fields. save and re-import. Quote Link to comment 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.