Database Creation

Trish_from_Oz

Hello, i am very new to PHP, and i was wondering if anyone knew how to create a mysql database. I tried using a database made in access, and someone told me that access databases don't work in mysql.(i didn't know....they work with coldfusion) Is there any way to convert an access database to a mysql database???? If there isn't, could someone please send me in the direction of

"An idiots guide to mysql database creation"

Thanks,
Trish:p

laserlight

Well, mysql.com has some documentation.
If you manage to find the right part (it is rather long winded), it goes through the steps of installing and using a mysql database from scratch.

The docs should also be provided in your copy of mysql.

BeastRider

If you have php running, you could use phpMyAdmin to create and manage MySql databases. If you are using a web host that is supplying you with a MySql database and php, then there is a high degree of certainty that phpMyAdmin will also be available for your use. See http://www.phpmyadmin.net. Set up is not the most intuitive.

Another product to look at is MySql Control Center which is available at www.mysql.com. This product allows you to create databases, tables, etc.

One problem you will have is getting data out of the Access table and into the MySql tables without writing a program. If your MySql database is local to the Access database, then install the MySql ODBC driver (also at www.mysql.com). Then you can use the link tables feature of Access to tie the MySql tables into the Access database. From there, you can load the tables using Access routines.

Mortimer_Jazz

This looks pretty nice too
http://www.webyog.com/sqlyog/index.html

..but I have to admit I haven't used it yet. Perhaps someone with more experience using mySQL could have a look and give their opinion :]

If you happen to use Flash, then I can recommend the Friends of Ed book "Php for flash" for an above average clear and concise explanation of creating a mySQL database using the mySQL monitor, and then integrating mySQL with php.

Norman_Graham

Originally posted by Trish from Oz
If there isn't, could someone please send me in the direction of

"An idiots guide to mysql database creation"

Thanks,
Trish:p

Direction: your local bookshop or Amazon.

Norm