PHP odbc to MYSQL

[nshack31]

first of all im sorry if this is in the wrong area. I can't find a DB area!

I created a site in PHP using ODBC and now wish to convert to MYSQL. I extracted my MS DB as a .sql file and imported it into MYSQL.

My question is.. Does MYSQL use the likes of primary keys and relationships? If so, will the relationships i set in microsoft access be carried to MYSQL?

Help Im a MYSQL newbie! thanks!

[mcibor]

I don't know if the relations will remain, but yes! MySQL uses relation and Primary keys. And yes, this is a place for mySQL problems (usually because in PHP one uses db a lot)

As for converting from Access to MySQL there may be some problems, I'm not familar with that. However if there is an option save as mySQL, then it should be ok. There are some programs that can convert from one db to another. just type "access mysql" in google and you'll get any. Eventually add word convert :)

Hope it explains things a bit
Best regards
Michal Cibor