Searshing for program ,, want Help ..

[Dr.Abdelfattah]

I am working Now to Release New Emu. put i stop in a step ....
wich is : i have (.mdb) data base , and i want to change it to MySql ....
I Searsh for any program to help in change or convert , put i don't find (all i find trial and can't convert all the mdb or work with errors and not compelete) >>

any one have this program or an Idea to convert (.mdb) to mysql , please tell me ..

and thnx

[Eckoro]

just do it manually..

[PortalDark]

Originally Posted by abdelfattah

hey all ,

I am working Now to Release New Emu. put i stop in a step ....
wich is : i have (.mdb) data base , and i want to change it to MySql ....
I Searsh for any program to help in change or convert , put i don't find (all i find trial and can't convert all the mdb or work with errors and not compelete) >>

any one have this program or an Idea to convert (.mdb) to mysql , please tell me ..

and thnx

first use google and second, you will need to do it manully

[Dr.Abdelfattah]

I searsh in Google (but with out any good result) , put any one have any Idea to how to make it manually?

[PortalDark]

Originally Posted by abdelfattah

I searsh in Google (put with out any good result) , put any one have any Idea to how to make it manually?

#removed

[Dr.Abdelfattah]

Originally Posted by darkhole1123

loolz !!

i got it , its an option in Navicat for MySQL ,,,

[Oriya9]

You can use a convertor to convert the Access file (*.mdb) to a MySQL file (*.sql) , with programs like Access2MySQL.
then you can use Navicat to execute the SQL file.

Though if you want an advice, do it manually, converting a DB is not a good thing and it isn't 100% accurate.
you can extract the desired TXT files from your Media.pk2 and then write 2 short functions:
1. Writing new fields to a table inside the DB.
2. A loop which will read from the TXT files (line by line), split the values, set them to variables and then use the 1st function to write the variables to the DB.

It isn't 100% manual work and it's the best method.
it'll be way faster than executing a SQL file in Navicat too.

Good luck.

[Dr.Abdelfattah]

Originally Posted by Oriya9

You can use a convertor to convert the Access file (*.mdb) to a MySQL file (*.sql) , with programs like Access2MySQL.
then you can use Navicat to execute the SQL file.

Though if you want an advice, do it manually, converting a DB is not a good thing and it isn't 100% accurate.
you can extract the desired TXT files from your Media.pk2 and then write 2 short functions:
1. Writing new fields to a table inside the DB.
2. A loop which will read from the TXT files (line by line), split the values, set them to variables and then use the 1st function to write the variables to the DB.

It isn't 100% manual work and it's the best method.
it'll be way faster than executing a SQL file in Navicat too.

Good luck.

thanx