Access to MySQL

zitr0ne · 01-20-2011, 03:14 AM

Hey lovely Forum,

i'm back again with a question.

So, i have an access-database (.mdb) and i want to make it to a MySQL-Database ...
But the MySQL-Database works on a Linux-Distri (CentOS 5.5), so did you have any idea for convert or must i do every entry solo and type down in the MySQL-Database?

It would be great, when you had a tutorial

t3ch · 01-20-2011, 03:23 AM

Here you go http://www.bullzip.com/products/a2m/info.php

zitr0ne · 01-20-2011, 03:41 AM

Are you sure i can use this with linux?

Thanks i will test that...

t3ch · 01-20-2011, 04:21 AM

Install the app on Windows, throw in your .mdb and convert it directly to a MySQL server, or make a dump file and import it on your Linux server.

zitr0ne · 01-28-2011, 07:48 AM

So, know i have installed my phpMyAdmin, httpd (apache 2) and my MySQL...
Import all Databaes-Tables of the Access-File into my MySQL-System and cleared all

So, now i have a problem with the database..
In the Access-File, the tables are connected inside, i mean something like Cardinality.

Can i export the configs of the Access-File and import that in the mysql-system??

Best Regards,
very many thanks for the support