use web-base DB instead of MS Access

I would like to know is it a better idea to use MYSQL instead of using MS Access to store a large amount of data?

anythings I needa be reminded before setting up a MYSql DB on the web server?

Update:

may I know the pros and cons this two DB tools too?

2 Answers

Rating
  • ?
    Lv 7
    1 decade ago
    Favorite Answer

    Yes. you can do it. The installation procedure is very easy. if you use linux platform, the folow the setup guildline below,

    http://dev.mysql.com/doc/refman/5.0/en/installing....

    if u want to use it in windows platform, there is a package including PHP, mYSQL, PHP and phpadmin. you can download from following url,

    AppServ 2.5.10

    Apache 2.2.8

    PHP 5.2.6

    MySQL 5.0.51b

    phpMyAdmin-2.10.3

    Download

    Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv...

    MD5SUM : 279c0c39866fbecb8a3904969fd5d0f4

    One thing you should consider. When you creating tables, there are two types of table structure in MYSQL mainly use. if you make use transaction (i.e. begin tran, commit tran, rollback tran) and there is field reference between table, you should use INNODB table. it provides better transaction control so that it makes better data consistancy and not make database crash easily.

    2008-06-29 01:25:04 補充:

    u means mysql vs access????

    2008-07-01 16:49:23 補充:

    mysql pros:

    fast; reliable; no table size limit (actually it has. but the limit is very large); can store binary file easily; mulit-connection performance is good; has procedure.

    2008-07-01 16:49:26 補充:

    mysql cons:

    compare with access, maintainance the db needs more DBMS knowledge and not easy to use (it is solved by using PHP admin tools/other mysql client program); need to write program to output the data in GUI format

  • 1 decade ago

    yes...

    both adv. and disadv.

Still have questions? Get your answers by asking now.