Migrating from Microsoft Access to MySQL

[rhxffdsxh]

I would like to hear from someone who has experience of migrating from Microsoft Access to MySQL. I really need someone to go through the whole process step by step.

I've been told previously that there are a few things important things that I need to do such as link tables from an mdb database to MySQL database on-line. As the mySQL database is fixed on the server and cannot be downloaded as a complete program, I need to get the data as an output script file to enable me to keep backups. Also need to know about add-ins for Access to enable me to link to the mySQL database using the tools/add-ins options on the Access toolbar.

However, none of this really makes much sense to me, would someone be so kind and explain the whole process to me in idiot terms please? Assistance would be eternally appreciated.

[henry0]

Welcome to WebmasterWorld!

Here is what I will do:
Check for a tool named "Access to MySQL"
Actually I have used that one but there are many on the market

once your Access DB is saved as a SQL DB

it will be very easy to insert it in a MySQL DB

go to your site PHPmyAdmin open a query window
paste the DB in it...Finished...!

that will do if you are in rush
however it will not teach you a lot
please look at How to [washington.edu]

and
MySQL Manual [dev.mysql.com]

good luck

henry

[mipapage]

I've used the same proggy as henry02 but had it (locally) update the mysql db (live server) at the punch of a button. No copying or pasting involved.

All very easy. The db wasn't too large however, around 4megs in it's access format.

[ergophobe]

These thread might help you

[webmasterworld.com...]
[webmasterworld.com...]

Tom

[txbakers]

I did it several years ago and I did it manually. Exported to text, uploaded to SQL.

The dates are in a different format in mySQL and of course you have to specify field lengths and types.

It was a very easy process.