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 Link to comment https://forums.phpfreaks.com/topic/166645-is-this-possible/ 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. Link to comment https://forums.phpfreaks.com/topic/166645-is-this-possible/#findComment-878750 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 Link to comment https://forums.phpfreaks.com/topic/166645-is-this-possible/#findComment-878760 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. Link to comment https://forums.phpfreaks.com/topic/166645-is-this-possible/#findComment-878842 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.