very basic questions

[jeskel]

Dear all,

here are some very basic questions that I have about MySql... I've been working with ASP/Access until now. I am doing a few things using PHP and I installed phpdev from firepages (GREAT tool for people like me). However, as you can guess, I am used to see a .mdb file with Access. I don't see such a thing with MySql. Maybe is it because I don't know where to look but my question is: how do you check the db? Do you have to do it through a script or can you do it "manually" (so to speak)?

thanx
:)

[raf]

You have a few options:
- use the commandline
- use a webfront, like phpMyAdmin (i thought it was included in Firepages package)
- use a db-front

Most host will have phpMyAdmins installed. But i don' like the layout and structure of it + all querys and data is then off course sent over the webserver and if you read large dumpfiles, your script will probably timeout.
On my machine at home, i use MySQLFront. I think it's a great db-front, but sadly, that project is discontinued. I don't know if you can still download it, but if you PM me, i'll mail it (its about 3 MB i think) or put it somewhere you can download it.
I also sometimes use the commandline for batchprocessing.

You can find more info on all these thing at mysql.com
http://www.mysql.com/doc/en/mysql.html (commandline)
http://www.mysql.com/portal/software/index.html (software you can use with mysql. some or free, some not.)
http://www.mysql.com/portal/search.php?category_id=0&q=accessdump&portal=software (accessdump --> to create dumpfiles from access-db's.)

[DrWeb]

here's another one, which isn't a free tool, but can be very helpful: MySQLyog (http://www.webyog.com/sqlyog/index.html)

[Kiwi]

Just to clarify: Access and mySQL are not equivalent products. mySQL is a database, period. Access is a database, plus a DBA and a bunch of wizards and an application language. Access is actually a more fully featured database (including triggers, views and foreign keys, which mySQL doesn't have), but nowhere near as reliable, fast or efficient as mySQL for most database functions.

To have the same functionality as Access, mySQL needs additional 'things' such as PHPmyAdmin as a DBA and doing the work of triggers et al in the application layer, rather than the database layer.

[jeskel]

Thank you for answers. phpdev includes phpadmin so... I'll start with this and will check the commandline pretty soon.
thanx again :thumbsup: