fekaduw Posted February 19, 2007 Share Posted February 19, 2007 hello all, i had an access database which contain bulky data. now, am just planning to convert it by a mysql db. i've constructed the table but am not quite sure how i can migrate the bulky data i've in the access db to mysql. i tried to use a software but it didn't work out. any help is highly appreciated thanks Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/ Share on other sites More sharing options...
hitman6003 Posted February 19, 2007 Share Posted February 19, 2007 There is a lot of different ways.... You can write a custom conversion script that will extract the data from Access and insert it into MySQL. You can export the data from Access, then, again using a custom script, insert it into MySQL. There is a MySQL ODBC connector that you can use to go directly between Access and MySQL, however your table structure would have to be EXACTLY the same for it work...and even then there is no guarantee. There is no easy way however...at least not without using some sort of conversion product...which probably isn't free. Make sure you have a back up of both databases before you try anything...... Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-188906 Share on other sites More sharing options...
fekaduw Posted February 19, 2007 Author Share Posted February 19, 2007 thanks but which tool do u think is appropriate. i mean the table structure is not similar. Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-188909 Share on other sites More sharing options...
hitman6003 Posted February 19, 2007 Share Posted February 19, 2007 Write your own script.....it's the only way to be sure you are migrating correctly Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-188915 Share on other sites More sharing options...
fekaduw Posted February 19, 2007 Author Share Posted February 19, 2007 i don't have any idea of writing the codes my self. if u can provide me a sort of link to a tutorial or sample codes, i will be delighted Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-188918 Share on other sites More sharing options...
Barand Posted February 19, 2007 Share Posted February 19, 2007 Create a query in Access that fetches the data you want to export Export the query into a CSV file Use MySql "LOAD DATA INFILE .... " command to load the CSV data into your table Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-189041 Share on other sites More sharing options...
joder Posted February 19, 2007 Share Posted February 19, 2007 http://www.kitebird.com/articles/access-migrate.html http://www.google.com/search?sourceid=navclient-ff&ie=UTF-8&rls=GGGL,GGGL:2006-37,GGGL:en&q=migrate+access+mysql Link to comment https://forums.phpfreaks.com/topic/39211-how-can-i-migrate-the-data/#findComment-189044 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.